Example #1
0
        /// <summary>
        /// 添加网络订单明细
        /// </summary>
        /// <param name="webOrderFormList">网络订单信息</param>
        /// <param name="error">出错时返回错误信息,无错时返回null</param>
        /// <returns>添加成功返回True,添加失败返回False</returns>
        public bool AddBill(B_WebForOrderFormList webOrderFormList, out string error)
        {
            try
            {
                error = null;

                DepotManagementDataContext dataContext = CommentParameter.DepotDataContext;

                var varData = from a in dataContext.B_WebForOrderFormList
                              where a.GoodsID == webOrderFormList.GoodsID &&
                              a.Provider == webOrderFormList.Provider &&
                              a.Ny == webOrderFormList.Ny
                              select a;

                if (varData.Count() > 0)
                {
                    error = "此记录已存在,不可重复录入";
                    return(false);
                }
                else
                {
                    dataContext.B_WebForOrderFormList.InsertOnSubmit(webOrderFormList);
                    dataContext.SubmitChanges();
                }

                return(true);
            }
            catch (Exception ex)
            {
                error = ex.Message;
                return(false);
            }
        }
Example #2
0
        /// <summary>
        /// 修改网络订单明细
        /// </summary>
        /// <param name="webOrderFormList">网络订单明细信息</param>
        /// <param name="error">出错时返回错误信息,无错时返回null</param>
        /// <returns>修改成功返回True,修改失败返回False</returns>
        public bool UpdateListInfo(B_WebForOrderFormList webOrderFormList, out string error)
        {
            try
            {
                error = null;

                DepotManagementDataContext dataContext = CommentParameter.DepotDataContext;

                var varData = from a in dataContext.B_WebForOrderFormList
                              where a.ID == Convert.ToInt32(webOrderFormList.ID)
                              select a;

                if (varData.Count() != 1)
                {
                    error = "数据不唯一或者为空";
                    return(false);
                }
                else
                {
                    B_WebForOrderFormList lnqWebForOrderForm = varData.Single();

                    lnqWebForOrderForm.BargainNumber   = webOrderFormList.BargainNumber;
                    lnqWebForOrderForm.CheckPersonnel  = webOrderFormList.CheckPersonnel;
                    lnqWebForOrderForm.GoodsID         = webOrderFormList.GoodsID;
                    lnqWebForOrderForm.OrderFormCount  = webOrderFormList.OrderFormCount;
                    lnqWebForOrderForm.OrderFormNumber = webOrderFormList.OrderFormNumber;
                    lnqWebForOrderForm.Provider        = webOrderFormList.Provider;
                    lnqWebForOrderForm.StockCount      = webOrderFormList.StockCount;
                    lnqWebForOrderForm.ChangeFlag      = webOrderFormList.ChangeFlag;

                    dataContext.SubmitChanges();
                }

                return(true);
            }
            catch (Exception ex)
            {
                error = ex.Message;
                return(false);
            }
        }