Beispiel #1
0
 /// <summary>
 /// 增加一条数据
 /// </summary>
 public int  Add(TSM.Model.pms_Quotation_Info model)
 {
     return(dal.Add(model));
 }
Beispiel #2
0
 /// <summary>
 /// 更新审批标志记录
 /// </summary>
 public void UpdateStatus(TSM.Model.pms_Quotation_Info model)
 {
     dal.UpdateStatus(model);
 }
Beispiel #3
0
        /// <summary>
        /// 获得数据列表
        /// </summary>
        public List <TSM.Model.pms_Quotation_Info> DataTableToList(DataTable dt)
        {
            List <TSM.Model.pms_Quotation_Info> modelList = new List <TSM.Model.pms_Quotation_Info>();
            int rowsCount = dt.Rows.Count;

            if (rowsCount > 0)
            {
                TSM.Model.pms_Quotation_Info model;
                for (int n = 0; n < rowsCount; n++)
                {
                    model = new TSM.Model.pms_Quotation_Info();
                    if (dt.Rows[n]["QuotationInfoID"].ToString() != "")
                    {
                        model.QuotationInfoID = int.Parse(dt.Rows[n]["QuotationInfoID"].ToString());
                    }
                    if (dt.Rows[n]["ProductInfoID"].ToString() != "")
                    {
                        model.ProductInfoID = int.Parse(dt.Rows[n]["ProductInfoID"].ToString());
                    }
                    if (dt.Rows[n]["QuotationDepart"].ToString() != "")
                    {
                        model.QuotationDepart = int.Parse(dt.Rows[n]["QuotationDepart"].ToString());
                    }
                    if (dt.Rows[n]["UserInfoID"].ToString() != "")
                    {
                        model.UserInfoID = int.Parse(dt.Rows[n]["UserInfoID"].ToString());
                    }
                    if (dt.Rows[n]["KnifeCharges"].ToString() != "")
                    {
                        model.KnifeCharges = decimal.Parse(dt.Rows[n]["KnifeCharges"].ToString());
                    }
                    if (dt.Rows[n]["ToolCharges"].ToString() != "")
                    {
                        model.ToolCharges = decimal.Parse(dt.Rows[n]["ToolCharges"].ToString());
                    }
                    if (dt.Rows[n]["QuotationPrice"].ToString() != "")
                    {
                        model.QuotationPrice = decimal.Parse(dt.Rows[n]["QuotationPrice"].ToString());
                    }
                    model.ApprovalStatus = dt.Rows[n]["ApprovalStatus"].ToString();
                    if (dt.Rows[n]["QuotationTime"].ToString() != "")
                    {
                        model.QuotationTime = DateTime.Parse(dt.Rows[n]["QuotationTime"].ToString());
                    }
                    if (dt.Rows[n]["SprayingCharges"].ToString() != "")
                    {
                        model.SprayingCharges = decimal.Parse(dt.Rows[n]["SprayingCharges"].ToString());
                    }
                    if (dt.Rows[n]["PackingCharges"].ToString() != "")
                    {
                        model.PackingCharges = decimal.Parse(dt.Rows[n]["PackingCharges"].ToString());
                    }
                    if (dt.Rows[n]["TestingCharges"].ToString() != "")
                    {
                        model.TestingCharges = decimal.Parse(dt.Rows[n]["TestingCharges"].ToString());
                    }
                    if (dt.Rows[n]["TransportCharges"].ToString() != "")
                    {
                        model.TransportCharges = decimal.Parse(dt.Rows[n]["TransportCharges"].ToString());
                    }
                    modelList.Add(model);
                }
            }
            return(modelList);
        }