コード例 #1
0
 /// <summary>
 /// 增加一条数据
 /// </summary>
 public void Add(MobileSoft.Model.Management.Tb_Management_Order model)
 {
     dal.Add(model);
 }
コード例 #2
0
 /// <summary>
 /// 更新一条数据
 /// </summary>
 public void Update(MobileSoft.Model.Management.Tb_Management_Order model)
 {
     dal.Update(model);
 }
コード例 #3
0
        /// <summary>
        /// 获得数据列表
        /// </summary>
        public List <MobileSoft.Model.Management.Tb_Management_Order> DataTableToList(DataTable dt)
        {
            List <MobileSoft.Model.Management.Tb_Management_Order> modelList = new List <MobileSoft.Model.Management.Tb_Management_Order>();
            int rowsCount = dt.Rows.Count;

            if (rowsCount > 0)
            {
                MobileSoft.Model.Management.Tb_Management_Order model;
                for (int n = 0; n < rowsCount; n++)
                {
                    model             = new MobileSoft.Model.Management.Tb_Management_Order();
                    model.OrderCode   = dt.Rows[n]["OrderCode"].ToString();
                    model.CommID      = dt.Rows[n]["CommID"].ToString();
                    model.ServiceCode = dt.Rows[n]["ServiceCode"].ToString();
                    model.OrderNum    = dt.Rows[n]["OrderNum"].ToString();
                    //model.CustID=dt.Rows[n]["CustID"].ToString();
                    //model.RoomID=dt.Rows[n]["RoomID"].ToString();
                    if (dt.Rows[n]["OrderDate"].ToString() != "")
                    {
                        model.OrderDate = DateTime.Parse(dt.Rows[n]["OrderDate"].ToString());
                    }
                    model.OrderMethod = dt.Rows[n]["OrderMethod"].ToString();
                    model.Contact     = dt.Rows[n]["Contact"].ToString();
                    model.ContactTel  = dt.Rows[n]["ContactTel"].ToString();
                    if (dt.Rows[n]["StartDate"].ToString() != "")
                    {
                        model.StartDate = DateTime.Parse(dt.Rows[n]["StartDate"].ToString());
                    }
                    if (dt.Rows[n]["EndDate"].ToString() != "")
                    {
                        model.EndDate = DateTime.Parse(dt.Rows[n]["EndDate"].ToString());
                    }
                    if (dt.Rows[n]["OrderCount"].ToString() != "")
                    {
                        model.OrderCount = int.Parse(dt.Rows[n]["OrderCount"].ToString());
                    }
                    if (dt.Rows[n]["OrderAmount"].ToString() != "")
                    {
                        model.OrderAmount = decimal.Parse(dt.Rows[n]["OrderAmount"].ToString());
                    }
                    if (dt.Rows[n]["TotalAmount"].ToString() != "")
                    {
                        model.TotalAmount = decimal.Parse(dt.Rows[n]["TotalAmount"].ToString());
                    }
                    model.IsPay      = dt.Rows[n]["IsPay"].ToString();
                    model.Memo       = dt.Rows[n]["Memo"].ToString();
                    model.IsAssign   = dt.Rows[n]["IsAssign"].ToString();
                    model.AssignName = dt.Rows[n]["AssignName"].ToString();
                    if (dt.Rows[n]["AssignDate"].ToString() != "")
                    {
                        model.AssignDate = DateTime.Parse(dt.Rows[n]["AssignDate"].ToString());
                    }
                    if (dt.Rows[n]["IsDeal"].ToString() != "")
                    {
                        model.IsDeal = dt.Rows[n]["IsDeal"].ToString();
                    }
                    model.DealName = dt.Rows[n]["DealName"].ToString();
                    if (dt.Rows[n]["DealDate"].ToString() != "")
                    {
                        model.DealDate = DateTime.Parse(dt.Rows[n]["DealDate"].ToString());
                    }
                    if (dt.Rows[n]["DeliveryCount"].ToString() != "")
                    {
                        model.DeliveryCount = int.Parse(dt.Rows[n]["DeliveryCount"].ToString());
                    }
                    model.IsVisit   = dt.Rows[n]["IsVisit"].ToString();
                    model.VisitName = dt.Rows[n]["VisitName"].ToString();
                    if (dt.Rows[n]["VisitDate"].ToString() != "")
                    {
                        model.VisitDate = DateTime.Parse(dt.Rows[n]["VisitDate"].ToString());
                    }
                    model.Evaluation  = dt.Rows[n]["Evaluation"].ToString();
                    model.CustOpinion = dt.Rows[n]["CustOpinion"].ToString();
                    model.IsExit      = dt.Rows[n]["IsExit"].ToString();
                    model.ExitName    = dt.Rows[n]["ExitName"].ToString();
                    if (dt.Rows[n]["ExitDate"].ToString() != "")
                    {
                        model.ExitDate = DateTime.Parse(dt.Rows[n]["ExitDate"].ToString());
                    }
                    model.ExitReason      = dt.Rows[n]["ExitReason"].ToString();
                    model.DealMemo        = dt.Rows[n]["DealMemo"].ToString();
                    model.StanName        = dt.Rows[n]["StanName"].ToString();
                    model.StanFormulaName = dt.Rows[n]["StanFormulaName"].ToString();
                    if (dt.Rows[n]["StanAmount"].ToString() != "")
                    {
                        model.StanAmount = decimal.Parse(dt.Rows[n]["StanAmount"].ToString());
                    }
                    if (dt.Rows[n]["IsDelete"].ToString() != "")
                    {
                        model.IsDelete = int.Parse(dt.Rows[n]["IsDelete"].ToString());
                    }
                    modelList.Add(model);
                }
            }
            return(modelList);
        }