RuiTengJb/ICSSoft.AppSln/ICSSoft.Frame.Data.BLL/ICSSENDINVPLANBLL.cs

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 ICSSENDINVPLANBLL
    {
        #region 查询物料
        public static DataTable SearchItemInfoList(string dsconn)
        {
            try
            {

                DataTable returndt = new DataTable();
                returndt.Columns.Add("guid", typeof(string));
                returndt.Columns.Add("物料代码", typeof(string));
                returndt.Columns.Add("存货名称", typeof(string));
                returndt.Columns.Add("物料描述", typeof(string));
                List<FormICSINVENTORYUIModel> returndal = ICSSENDINVPLANDAL.SearchItemInfoList(dsconn);
                foreach (FormICSINVENTORYUIModel returntype in returndal)
                {
                    DataRow dr = returndt.NewRow();
                    dr["guid"] = returntype.ID;
                    dr["物料代码"] = returntype.INVCODE;
                    dr["存货名称"] = returntype.INVNAME;
                    dr["物料描述"] = returntype.INVDESC;
                    returndt.Rows.Add(dr);

                }
                return returndt;
            }
            catch (Exception ex)
            {
                throw ex;
            }

        }
        #endregion
        #region 查询工单
        public static DataTable SearchMOInfoList(string dsconn)
        {
            try
            {

                DataTable returndt = new DataTable();
                returndt.Columns.Add("guid", typeof(string));
                returndt.Columns.Add("生产订单号", typeof(string));
                returndt.Columns.Add("工单备注", typeof(string));
                returndt.Columns.Add("工单描述", typeof(string));
                List<FormICSMOUIModel> returndal = ICSSENDINVPLANDAL.SearchMOInfoList(dsconn);
                foreach (FormICSMOUIModel returntype in returndal)
                {
                    DataRow dr = returndt.NewRow();
                    dr["guid"] = returntype.ID;
                    dr["生产订单号"] = returntype.MOCODE;
                    dr["工单备注"] = returntype.MOMEMO;
                    dr["工单描述"] = returntype.MODESC;
                    returndt.Rows.Add(dr);
                }
                return returndt;
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
        #endregion

        #region 新增和修改
        public static void Add(FormICSSENDINVPLANUIModel sendInfo, string dsconn)
        {
            try
            {
                if (string.IsNullOrWhiteSpace(dsconn))
                {
                    throw new Exception("数据库连接字符串错误");
                }
                List<FormICSSENDINVPLANUIModel> sendInfoList = new List<FormICSSENDINVPLANUIModel>() { sendInfo };
                ICSSENDINVPLANDAL.Add(sendInfoList, dsconn);
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
        #endregion
        #region 业务类型代码是否存在
        public static bool IsIncluding(decimal version, string workpoint, string dsconn)
        {
            try
            {
                return ICSSENDINVPLANDAL.IsIncluding(version, workpoint, dsconn);
            }
            catch (Exception ex)
            {
                throw ex;
            }

        }
        #endregion
        #region 通过guid查询
        public static FormICSSENDINVPLANUIModel SearchSendInfoByID(string sendid, string dsconn)
        {
            try
            {
                List<FormICSSENDINVPLANUIModel> returnlist = ICSSENDINVPLANDAL.SearchSendInfoByID(sendid, dsconn);
                return returnlist[0];
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
        #endregion
        #region 删除
        public static void deleteInfo(List<string> sendidList, string dsconn)
        {
            try
            {
                ICSSENDINVPLANDAL.deleteInfo(sendidList, dsconn);
            }
            catch (Exception ex)
            {
                throw ex;
            }


        }
        #endregion

    }
}