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.
66 lines
2.0 KiB
66 lines
2.0 KiB
using System;
|
|
using System.Collections.Generic;
|
|
using System.Linq;
|
|
using System.Text;
|
|
using System.Data;
|
|
using ICSSoft.Frame.Data.DAL;
|
|
using ICSSoft.Frame.Data.Entity;
|
|
using System.Data.SqlClient;
|
|
|
|
namespace ICSSoft.Frame.Data.BLL
|
|
{
|
|
public class ICSWBSSpecailTransferBLL
|
|
{
|
|
public static void Add(List<ICSWBSSpecialTransfer> InfoList, string dsconn)
|
|
{
|
|
try
|
|
{
|
|
if (string.IsNullOrWhiteSpace(dsconn))
|
|
{
|
|
throw new Exception("数据库连接字符串错误");
|
|
}
|
|
ICSWBSSpecailTransferDAL.AddAndEdit(InfoList, dsconn);
|
|
|
|
}
|
|
catch (Exception ex)
|
|
{
|
|
throw ex;
|
|
}
|
|
}
|
|
#region 项目转换
|
|
public static void UpdateWBS(SqlConnection sqlConnection, SqlTransaction trans,string LotCode,string QtyCode,string IDCode, string dsconn)
|
|
{
|
|
try
|
|
{
|
|
if (string.IsNullOrWhiteSpace(dsconn))
|
|
{
|
|
throw new Exception("数据库连接字符串错误");
|
|
}
|
|
ICSWBSSpecailTransferDAL.UpdateWBS(sqlConnection, trans, LotCode, QtyCode, IDCode,dsconn);
|
|
}
|
|
catch (Exception ex)
|
|
{
|
|
throw new Exception(ex.Message);
|
|
}
|
|
}
|
|
#endregion
|
|
|
|
#region 更新WMS
|
|
public static void UpdateTransWMS(SqlConnection sqlConnection, SqlTransaction trans, List<ICSWBSSpecialTransfer> InfoList,List<ICSITEMLot> lotList,string dsconn)
|
|
{
|
|
try
|
|
{
|
|
if (string.IsNullOrWhiteSpace(dsconn))
|
|
{
|
|
throw new Exception("数据库连接字符串错误");
|
|
}
|
|
ICSWBSSpecailTransferDAL.UpdateTransWMS(sqlConnection, trans, InfoList, lotList, dsconn);
|
|
}
|
|
catch (Exception ex)
|
|
{
|
|
throw new Exception(ex.Message);
|
|
}
|
|
}
|
|
#endregion
|
|
}
|
|
}
|