You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
89 lines
2.3 KiB
89 lines
2.3 KiB
using System;
|
|
using System.Collections.Generic;
|
|
using System.Linq;
|
|
using System.Text;
|
|
using ICSSoft.Frame.Data.Entity;
|
|
using ICSSoft.Frame.Data.DAL;
|
|
|
|
namespace ICSSoft.Frame.Data.BLL
|
|
{
|
|
public class ICSAQLBLL
|
|
{
|
|
#region 新增和修改
|
|
public static void Add(FormICSAQLUIModel aqlInfo, string dsconn)
|
|
{
|
|
try
|
|
{
|
|
if (string.IsNullOrWhiteSpace(dsconn))
|
|
{
|
|
throw new Exception("数据库连接字符串错误");
|
|
}
|
|
List<FormICSAQLUIModel> aqlInfoList = new List<FormICSAQLUIModel>() { aqlInfo };
|
|
ICSAQLDAL.Add(aqlInfoList, dsconn);
|
|
|
|
}
|
|
catch (Exception ex)
|
|
{
|
|
throw ex;
|
|
}
|
|
}
|
|
#endregion
|
|
#region 代码是否存在
|
|
public static bool IsIncluding(int AQLSEQ, string AQLLEVEL,string workpoint, string dsconn)
|
|
{
|
|
try
|
|
{
|
|
return ICSAQLDAL.IsIncluding(AQLSEQ, AQLLEVEL, workpoint,dsconn);
|
|
}
|
|
catch (Exception ex)
|
|
{
|
|
throw ex;
|
|
}
|
|
|
|
}
|
|
#endregion
|
|
#region 通过guid查询
|
|
public static FormICSAQLUIModel SearchAQLInfoByID(string aqlid, string dsconn)
|
|
{
|
|
try
|
|
{
|
|
List<FormICSAQLUIModel> returnlist = ICSAQLDAL.SearchAQLInfoByID(aqlid, dsconn);
|
|
return returnlist[0];
|
|
}
|
|
catch (Exception ex)
|
|
{
|
|
throw ex;
|
|
}
|
|
}
|
|
#endregion
|
|
#region 删除
|
|
public static void deleteInfo(List<string> aqlid, string dsconn)
|
|
{
|
|
try
|
|
{
|
|
ICSAQLDAL.deleteInfo(aqlid, dsconn);
|
|
}
|
|
catch (Exception ex)
|
|
{
|
|
throw ex;
|
|
}
|
|
|
|
|
|
}
|
|
#endregion
|
|
#region 通过检验标准查询
|
|
public static List<FormICSAQLUIModel> SearchAQLInfoByLevel(string aqllevel, string dsconn)
|
|
{
|
|
try
|
|
{
|
|
List<FormICSAQLUIModel> returnlist = ICSAQLDAL.SearchAQLInfoByLevel(aqllevel, dsconn);
|
|
return returnlist;
|
|
}
|
|
catch (Exception ex)
|
|
{
|
|
throw ex;
|
|
}
|
|
}
|
|
#endregion
|
|
}
|
|
}
|