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.
155 lines
3.9 KiB
155 lines
3.9 KiB
using System;
|
|
using System.Collections.Generic;
|
|
using System.Linq;
|
|
using System.Text;
|
|
using System.Data;
|
|
using ICSSoft.Frame.Data.Entity;
|
|
using ICSSoft.Frame.Data.DAL;
|
|
|
|
namespace ICSSoft.Frame.Data.BLL
|
|
{
|
|
public class ICSDeliveryPlanBLL
|
|
{
|
|
#region 新增和修改
|
|
public static void Add(ICSDeliveryPlan Info, DataTable dt,string Version, string dsconn)
|
|
{
|
|
try
|
|
{
|
|
if (string.IsNullOrWhiteSpace(dsconn))
|
|
{
|
|
throw new Exception("数据库连接字符串错误");
|
|
}
|
|
ICSDeliveryPlanDAL.Add(Info, dt, Version, dsconn);
|
|
}
|
|
catch (Exception ex)
|
|
{
|
|
throw ex;
|
|
}
|
|
}
|
|
#endregion
|
|
|
|
#region 导入
|
|
public static void AddList(DataTable dt, string dsconn)
|
|
{
|
|
try
|
|
{
|
|
if (string.IsNullOrWhiteSpace(dsconn))
|
|
{
|
|
throw new Exception("数据库连接字符串错误");
|
|
}
|
|
ICSDeliveryPlanDAL.AddList(dt, dsconn);
|
|
}
|
|
catch (Exception ex)
|
|
{
|
|
throw ex;
|
|
}
|
|
}
|
|
#endregion
|
|
|
|
#region 通过ID查询
|
|
public static DataSet SearchInfoByID(string ID, string dsconn)
|
|
{
|
|
try
|
|
{
|
|
return ICSDeliveryPlanDAL.SearchInfoByID(ID, dsconn);
|
|
}
|
|
catch (Exception ex)
|
|
{
|
|
throw ex;
|
|
}
|
|
}
|
|
#endregion
|
|
|
|
#region 删除
|
|
public static void deleteInfo(List<string> IDList, string dsconn)
|
|
{
|
|
try
|
|
{
|
|
ICSDeliveryPlanDAL.deleteInfo(IDList, dsconn);
|
|
}
|
|
catch (Exception ex)
|
|
{
|
|
throw ex;
|
|
}
|
|
}
|
|
#endregion
|
|
|
|
#region 审核
|
|
public static void Check(List<string> IDList, string dsconn)
|
|
{
|
|
try
|
|
{
|
|
ICSDeliveryPlanDAL.Check(IDList, dsconn);
|
|
}
|
|
catch (Exception ex)
|
|
{
|
|
throw ex;
|
|
}
|
|
}
|
|
#endregion
|
|
|
|
#region 弃审
|
|
public static void RefuseCheck(List<string> IDList, string dsconn)
|
|
{
|
|
try
|
|
{
|
|
ICSDeliveryPlanDAL.RefuseCheck(IDList, dsconn);
|
|
}
|
|
catch (Exception ex)
|
|
{
|
|
throw ex;
|
|
}
|
|
}
|
|
#endregion
|
|
|
|
#region 复审
|
|
public static void Review(List<string> IDList, string dsconn)
|
|
{
|
|
try
|
|
{
|
|
ICSDeliveryPlanDAL.Review(IDList, dsconn);
|
|
}
|
|
catch (Exception ex)
|
|
{
|
|
throw ex;
|
|
}
|
|
}
|
|
#endregion
|
|
|
|
#region 取消复审
|
|
public static void ReviewBack(List<string> IDList, string dsconn)
|
|
{
|
|
try
|
|
{
|
|
ICSDeliveryPlanDAL.ReviewBack(IDList, dsconn);
|
|
}
|
|
catch (Exception ex)
|
|
{
|
|
throw ex;
|
|
}
|
|
}
|
|
#endregion
|
|
|
|
#region 获取物料编码,助记码.客户编码
|
|
/// <summary>
|
|
/// 查询a.物料(表0) b.客户编码(表2)
|
|
/// </summary>
|
|
/// <param name="pk_org"></param>
|
|
/// <returns></returns>
|
|
public static DataSet GetInvInfoAndCust(string pk_org)
|
|
{
|
|
return ICSDeliveryPlanDAL.GetInvInfoAndCust(pk_org);
|
|
}
|
|
#endregion
|
|
//获取信息
|
|
public static DataSet GetPlanInfo(string vourchs)
|
|
{
|
|
return ICSDeliveryPlanDAL.GetPlanInfo(vourchs);
|
|
}
|
|
//更新erp
|
|
public static void UploadErp(string ids, string dsconn)
|
|
{
|
|
ICSDeliveryPlanDAL.UploadErp(ids, dsconn);
|
|
}
|
|
}
|
|
}
|