|
|
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 ICSSOPriceSheetBLL { public static DataTable SearchStorageInfoList(string dsconn) { try { DataTable returndt = new DataTable(); returndt.Columns.Add("Serial", typeof(string)); returndt.Columns.Add("库别代码", typeof(string)); returndt.Columns.Add("库别名称", typeof(string)); List<FormICSStorageUIModel> returndal = ICSSOPriceSheetDAL.SearchStorageInfoList(dsconn); foreach (FormICSStorageUIModel returns in returndal) { DataRow dr = returndt.NewRow(); dr["Serial"] = returns.Serial; dr["库别代码"] = returns.StorageCode; dr["库别名称"] = returns.StorageName; returndt.Rows.Add(dr);
} return returndt; } catch (Exception ex) { throw ex; }
} public static DataTable SearchVendorInfoList(string dsconn) { try { DataTable returndt = new DataTable(); returndt.Columns.Add("ID", typeof(string)); returndt.Columns.Add("厂商代码", typeof(string)); returndt.Columns.Add("厂商名称", typeof(string)); List<FormICSVendorUIModel> returndal = ICSSOPriceSheetDAL.SearchVendorInfoList(dsconn); foreach (FormICSVendorUIModel returnv in returndal) { DataRow dr = returndt.NewRow(); dr["ID"] = returnv.ID; dr["厂商代码"] = returnv.VendorCode; dr["厂商名称"] = returnv.VendorName; returndt.Rows.Add(dr);
} return returndt; } catch (Exception ex) { throw ex; }
} #region 新增和修改
public static void Add(List<XS001_0001_E001_2020> SoMainList, List<XS001_0001_E002_2020> SoDetailLIist, string dsconn) { try { if (string.IsNullOrWhiteSpace(dsconn)) { throw new Exception("数据库连接字符串错误"); } ICSSOPriceSheetDAL.Add(SoMainList,SoDetailLIist, dsconn); } catch (Exception ex) { throw ex; } }
/// <summary>
/// 新增入库单明细
/// </summary>
/// <param name="Picking"></param>
/// <param name="dsconn"></param>
/// <returns></returns>
public static string AddAndEditDetail(FormICSPickingModel Picking, string dsconn) { try { if (string.IsNullOrWhiteSpace(dsconn)) { throw new Exception("数据库连接字符串错误"); } return ICSSOPriceSheetDAL.AddAndEditDetail(Picking, dsconn); } catch (Exception ex) { throw ex; } }
public static string GetOutInNo(string dsconn) { try { if (string.IsNullOrWhiteSpace(dsconn)) { throw new Exception("数据库连接字符串错误"); } return ICSSOPriceSheetDAL.GetOutInNo(dsconn); } catch (Exception ex) { throw ex; } } public static string GetPickingRowNo(string pickingId, string dsconn) { try { if (string.IsNullOrWhiteSpace(dsconn)) { throw new Exception("数据库连接字符串错误"); } return ICSSOPriceSheetDAL.GetPickingRowNo(pickingId, dsconn); } catch (Exception ex) { throw ex; } }
#endregion
#region 通过入库guid查询
public static FormICSPickingModel SearchInfoByID(string Rguid, string dsconn) { try { List<FormICSPickingModel> returnlist = ICSSOPriceSheetDAL.SearchInfoByID(Rguid, dsconn); return returnlist[0]; } catch (Exception ex) { throw ex; } } #endregion
#region 删除
public static void deleteInfo(string code, string dsconn) { try { ICSSOPriceSheetDAL.deleteInfo(code, dsconn); } catch (Exception ex) { throw ex; } }
public static void deleteDetailInfo(string code,string row, string dsconn) { try { ICSSOPriceSheetDAL.deleteDetailInfo(code,row, dsconn); } catch (Exception ex) { throw ex; } } #endregion
#region 入库代码是否存在
public static bool IsIncluding(string noCODE, string workpoint, string dsconn) { try { return ICSSOPriceSheetDAL.IsIncluding(noCODE, workpoint, dsconn); } catch (Exception ex) { throw ex; }
} #endregion
public static bool IsIncludingDetail(List<string> RIDList, string dsconn) {
try { return ICSSOPriceSheetDAL.IsIncludingDetail(RIDList, dsconn);
} catch (Exception ex) { throw ex; }
}
#region 子件资料信息
public static DataTable GetDetail(string Sql) { try { return ICSSOPriceSheetDAL.GetDetail(Sql); } catch (Exception ex) { throw ex; } }
public static DataTable GetDetailList(string VouchCode,string dsconn) { try { if (string.IsNullOrWhiteSpace(dsconn)) { throw new Exception("数据库连接字符串错误"); } return ICSSOPriceSheetDAL.GetDetailList(VouchCode, dsconn); } catch (Exception ex) { throw ex; } }
public static DataTable GetDetailInfo(string code, string row, string dsconn) { try { if (string.IsNullOrWhiteSpace(dsconn)) { throw new Exception("数据库连接字符串错误"); } return ICSSOPriceSheetDAL.GetDetailInfo(code, row, dsconn); } catch (Exception ex) { throw ex; } }
#endregion
#region 部门审核
public static void Check(string id, string dsconn) { try { ICSSOPriceSheetDAL.Check(id, dsconn); } catch (Exception ex) { throw ex; } } #endregion
#region 弃审
public static void DiscardedTrialCheck(string id, string dsconn) { try { ICSSOPriceSheetDAL.DiscardedTrialCheck(id, dsconn); } catch (Exception ex) { throw ex; } } #endregion
#region 弃审
public static void RefuseCheck(string id, string dsconn) { try { ICSSOPriceSheetDAL.RefuseCheck(id, dsconn); } catch (Exception ex) { throw ex; } } #endregion
#region 通过ID查询
public static DataTable searchInfoByID(string ID, string dsconn) { try { return ICSSOPriceSheetDAL.searchInfoByID(ID, dsconn); } catch (Exception ex) { throw ex; }
} #endregion
}}
|
