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
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);
|
|
}
|
|
}
|
|
}
|