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.
127 lines
3.2 KiB
127 lines
3.2 KiB
using System;
|
|
using System.Collections.Generic;
|
|
using System.Linq;
|
|
using System.Text;
|
|
using ICSSoft.Frame.Data.Entity;
|
|
using ICSSoft.Frame.Data.DAL;
|
|
using System.Data;
|
|
namespace ICSSoft.Frame.Data.BLL
|
|
{
|
|
public class ICSMaterielLOTBLL
|
|
{
|
|
#region 新增和修改
|
|
public static void Add(List<ICSITEMLot> InfoList, string dsconn)
|
|
{
|
|
try
|
|
{
|
|
if (string.IsNullOrWhiteSpace(dsconn))
|
|
{
|
|
throw new Exception("数据库连接字符串错误");
|
|
}
|
|
ICSMaterielLOTDAL.Add(InfoList, dsconn);
|
|
|
|
}
|
|
catch (Exception ex)
|
|
{
|
|
throw ex;
|
|
}
|
|
}
|
|
#endregion
|
|
|
|
#region 成品条码新增和修改
|
|
public static void AddInv(List<ICSITEMLot> InfoList, string dsconn)
|
|
{
|
|
try
|
|
{
|
|
if (string.IsNullOrWhiteSpace(dsconn))
|
|
{
|
|
throw new Exception("数据库连接字符串错误");
|
|
}
|
|
ICSMaterielLOTDAL.AddInv(InfoList, dsconn);
|
|
|
|
}
|
|
catch (Exception ex)
|
|
{
|
|
throw ex;
|
|
}
|
|
}
|
|
#endregion
|
|
|
|
#region 更新打印信息
|
|
public static void updatePrint(List<ICSITEMLot> InfoList, string dsconn)
|
|
{
|
|
try
|
|
{
|
|
if (string.IsNullOrWhiteSpace(dsconn))
|
|
{
|
|
throw new Exception("数据库连接字符串错误");
|
|
}
|
|
ICSMaterielLOTDAL.updatePrint(InfoList, dsconn);
|
|
|
|
}
|
|
catch (Exception ex)
|
|
{
|
|
throw ex;
|
|
}
|
|
}
|
|
#endregion
|
|
|
|
#region 通过代码、行号查询
|
|
public static FormICSPurchaseLOTUIModelX SearchInfo(string CODE, string RowNo, string dsconn)
|
|
{
|
|
try
|
|
{
|
|
return ICSMaterielLOTDAL.SearchInfo(CODE,RowNo, dsconn);
|
|
}
|
|
catch (Exception ex)
|
|
{
|
|
throw ex;
|
|
}
|
|
}
|
|
#endregion
|
|
|
|
#region 通过物料查询
|
|
public static FormICSPurchaseLOTUIModelX SearchInfoInv(string CODE, string dsconn)
|
|
{
|
|
try
|
|
{
|
|
return ICSMaterielLOTDAL.SearchInfoInv(CODE, dsconn);
|
|
}
|
|
catch (Exception ex)
|
|
{
|
|
throw ex;
|
|
}
|
|
}
|
|
#endregion
|
|
|
|
#region 通过主表行和子表
|
|
public static DataSet SearchData(string CODE, string RowNo, string dsconn)
|
|
{
|
|
try
|
|
{
|
|
return ICSMaterielLOTDAL.SearchData(CODE, RowNo, dsconn);
|
|
}
|
|
catch (Exception ex)
|
|
{
|
|
throw ex;
|
|
}
|
|
}
|
|
#endregion
|
|
|
|
#region 删除
|
|
public static void deleteInfo(List<string> codeList, string dsconn)
|
|
{
|
|
try
|
|
{
|
|
ICSMaterielLOTDAL.deleteInfo(codeList, dsconn);
|
|
}
|
|
catch (Exception ex)
|
|
{
|
|
throw ex;
|
|
}
|
|
|
|
|
|
}
|
|
#endregion
|
|
}
|
|
}
|