锐腾搅拌上料功能
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.

150 lines
3.7 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 ICSForecastBLL
{
#region 新增和修改
public static void Add(ICSForecast Info, DataTable dt,string Version, string dsconn)
{
try
{
if (string.IsNullOrWhiteSpace(dsconn))
{
throw new Exception("数据库连接字符串错误");
}
ICSForecastDAL.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("数据库连接字符串错误");
}
ICSForecastDAL.AddList(dt, dsconn);
}
catch (Exception ex)
{
throw ex;
}
}
#endregion
#region 通过ID查询
public static DataSet SearchInfoByID(string ID, string dsconn)
{
try
{
return ICSForecastDAL.SearchInfoByID(ID, dsconn);
}
catch (Exception ex)
{
throw ex;
}
}
#endregion
#region 删除
public static void deleteInfo(List<string> IDList, string dsconn)
{
try
{
ICSForecastDAL.deleteInfo(IDList, dsconn);
}
catch (Exception ex)
{
throw ex;
}
}
#endregion
#region 审核
public static void Check(List<string> IDList, string dsconn)
{
try
{
ICSForecastDAL.Check(IDList, dsconn);
}
catch (Exception ex)
{
throw ex;
}
}
#endregion
#region 弃审
public static void RefuseCheck(List<string> IDList, string dsconn)
{
try
{
ICSForecastDAL.RefuseCheck(IDList, dsconn);
}
catch (Exception ex)
{
throw ex;
}
}
#endregion
#region 复审
public static void Review(List<string> IDList, string dsconn)
{
try
{
ICSForecastDAL.Review(IDList, dsconn);
}
catch (Exception ex)
{
throw ex;
}
}
#endregion
#region 取消复审
public static void ReviewBack(List<string> IDList, string dsconn)
{
try
{
ICSForecastDAL.ReviewBack(IDList, dsconn);
}
catch (Exception ex)
{
throw ex;
}
}
#endregion
#region 获取物料编码,助记码.客户编码
/// <summary>
/// 查询a.物料(表0) b.客户编码(表1)
/// </summary>
/// <param name="pk_org"></param>
/// <returns></returns>
public static DataSet GetInvInfoAndCust(string pk_org)
{
return ICSForecastDAL.GetInvInfoAndCust(pk_org);
}
#endregion
public static void UploadErp(string ids, string dsconn)
{
ICSForecastDAL.UploadErp(ids, dsconn);
}
}
}