예제 #1
0
        /// <summary>
        ///
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        protected void Grid1_AfterEdit(object sender, GridAfterEditEventArgs e)
        {
            var addList = Grid1.GetNewAddedList();

            foreach (var add in addList)
            {
                var dictValues = add.Values;

                //商品代码
                var firstOrDefault = dictValues.First();

                if (firstOrDefault != null && !string.IsNullOrEmpty(firstOrDefault.ToString()))
                {
                    DataSet dataSet = GasHelper.GetSalesItem(firstOrDefault.ToString(), CurrentUser.AccountComId);

                    DataTable table = dataSet.Tables[0];

                    if (table != null && table.Rows.Count > 0)
                    {
                        decimal price = GasHelper.GeCustomerPrice(txtFCode.Text,//
                                                                  table.Rows[0]["FItemCode"].ToString(), CurrentUser.AccountComId);

                        table.Rows[0]["FPrice"] = price;

                        var details = new LHLeaseDetails
                        {
                            FBottle    = table.Rows[0]["FItemCode"].ToString(),
                            FPrice     = price,
                            FBottleQty = 1,
                            FAmount    = price,
                            //单日租金
                            FRentDay   = 1,
                            FCompanyId = CurrentUser.AccountComId,
                            KeyId      = txtKeyId.Text.Trim(),
                            FCateId    = Convert.ToInt32(table.Rows[0]["FId"].ToString())
                        };

                        switch (Actions)
                        {
                        case WebAction.Add:
                            break;

                        case WebAction.Edit:
                            //记录一下当前新增人操作内容
                            var detailslog = new LHLeaseDetails_Log
                            {
                                FUpdateBy   = CurrentUser.AccountName,
                                FUpdateDate = DateTime.Now,
                                FBottle     = table.Rows[0]["FItemCode"].ToString(),
                                FPrice      = price,
                                FBottleQty  = 1,
                                FAmount     = price,
                                KeyId       = txtKeyId.Text.Trim(),
                                FRentDay    = 1,
                                FCompanyId  = CurrentUser.AccountComId,
                                FStatus     = "新增",
                                //FMemo = string.Format(@"时间:{0} 新增人:{1}", DateTime.Now, CurrentUser.AccountName)
                            };

                            //detailslog.FCompanyId = CurrentUser.AccountComId;
                            //detailslog.FCateId = Convert.ToInt32(table.Rows[0]["FId"].ToString());

                            LeaseDetailsLogService.Add(detailslog);

                            break;
                        }

                        LeaseDetailsService.Add(details);
                    }
                }
            }



            if (addList.Count > 0)
            {
                BindDataGrid();
            }
        }
예제 #2
0
        /// <summary>
        ///     ModifiedGrid
        /// </summary>
        private void ModifiedGrid()
        {
            var dictModified = Grid1.GetModifiedDict();

            foreach (var rowKey in dictModified.Keys)
            {
                int datakey = Convert.ToInt32(Grid1.DataKeys[rowKey][1].ToString());

                var sKeys   = new StringBuilder();
                var sValues = new StringBuilder();
                foreach (var key in dictModified[rowKey].Keys)
                {
                    sKeys.AppendFormat("{0},", key);
                }

                foreach (var dictValue in dictModified[rowKey].Values)
                {
                    sValues.AppendFormat("{0},", dictValue);
                }

                var details = LeaseDetailsService.Where(p => p.FId == datakey && p.FCompanyId == CurrentUser.AccountComId).FirstOrDefault();

                //写入原始,通过存储过程完成明细复制
                var parms = new Dictionary <string, object>();
                parms.Clear();

                parms.Add("@fid", datakey);
                parms.Add("@opr", CurrentUser.AccountName);
                parms.Add("@companyId", CurrentUser.AccountComId);
                SqlService.ExecuteProcedureCommand("proc_LeaseDetails_Log", parms);

                var keys   = sKeys.ToString().Split(',');
                var values = sValues.ToString().Split(',');
                for (int i = 0; i < keys.Count(); i++)
                {
                    #region 修改内容

                    var key   = keys[i];
                    var value = values[i];

                    if (!string.IsNullOrEmpty(key))
                    {
                        if (details != null)
                        {
                            if (key.Equals("FBottleQty"))
                            {
                                details.FBottleQty = Convert.ToInt32(value);
                                details.FAmount    = details.FBottleQty * details.FPrice;
                            }

                            if (key.Equals("FRentDay"))
                            {//租金/天
                                details.FRentDay = Convert.ToDecimal(value);
                            }

                            if (key.Equals("FPrice"))
                            {//押金/个
                                details.FPrice  = Convert.ToDecimal(value);
                                details.FAmount = details.FPrice * details.FBottleQty;
                            }

                            if (key.Equals("FAmount"))
                            {//押金
                                details.FAmount = details.FBottleQty * details.FPrice;
                            }
                        }

                        var detailslog = new LHLeaseDetails_Log
                        {
                            FUpdateBy   = CurrentUser.AccountName,
                            FUpdateDate = DateTime.Now,
                            FBottle     = details.FBottle,
                            FPrice      = details.FPrice,
                            FBottleQty  = details.FBottleQty,
                            FAmount     = details.FAmount,
                            KeyId       = details.KeyId,
                            FRentDay    = details.FRentDay,
                            FStatus     = "变更",
                            FCompanyId  = CurrentUser.AccountComId,
                            //FMemo = string.Format(@"时间:{0} 变更人:{1}", DateTime.Now, CurrentUser.AccountName)
                        };

                        LeaseDetailsLogService.Add(detailslog);
                    }
                    #endregion
                }

                LeaseDetailsService.SaveChanges();
            }
        }
예제 #3
0
        /// <summary>
        ///     Page_Load
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
                //初始化控件数据
                InitData();

                //加载数据
                LoadData();
            }
            else
            {
                #region reloadGrid
                if (GetRequestEventArgument().Contains("reloadGrid:"))
                {
                    //查找所选商品代码,查访产品集合
                    string keys = GetRequestEventArgument().Split(':')[1];

                    var values = keys.Split(',');

                    string codes = String.Empty;
                    for (int i = 0; i < values.Count(); i++)
                    {
                        codes += string.Format("'{0}',", values[i]);
                    }

                    var value = codes.Substring(0, codes.Length - 1);

                    var data = SqlService.Where(string.Format("SELECT * FROM dbo.vm_SalesItem a WHERE a.FItemCode IN ({0}) and FCompanyId={1}", value, CurrentUser.AccountComId));

                    if (data != null && data.Tables.Count > 0 && data.Tables[0].Rows.Count > 0)
                    {
                        var table = data.Tables[0];
                        for (int i = 0; i < table.Rows.Count; i++)
                        {
                            var details = new LHLeaseDetails();

                            decimal price = GasHelper.GeCustomerPrice(txtFCode.Text, //
                                                                      table.Rows[i]["FItemCode"].ToString(), CurrentUser.AccountComId);

                            details.FBottle    = table.Rows[i]["FItemCode"].ToString();
                            details.FPrice     = price;
                            details.FBottleQty = 1;
                            details.FAmount    = price;
                            details.FBottleQty = 1;
                            //details.FBottleOweQty = 0;
                            details.FCompanyId = CurrentUser.AccountComId;
                            details.KeyId      = txtKeyId.Text.Trim();
                            details.FCateId    = Convert.ToInt32(table.Rows[i]["FId"].ToString());
                            //每天租赁费
                            details.FRentDay = 0;
                            //押金
                            details.FAmount = price;

                            //已归还量
                            details.FReturnQty = 0;

                            LeaseDetailsService.AddEntity(details);

                            //日志
                            switch (Actions)
                            {
                            case WebAction.Add:
                                break;

                            case WebAction.Edit:
                                //记录一下当前新增人操作内容
                                var detailslog = new LHLeaseDetails_Log
                                {
                                    FUpdateBy   = CurrentUser.AccountName,
                                    FUpdateDate = DateTime.Now,
                                    FBottle     = details.FBottle,
                                    FPrice      = price,
                                    FBottleQty  = 1,
                                    FAmount     = price,
                                    FCompanyId  = CurrentUser.AccountComId,
                                    KeyId       = txtKeyId.Text.Trim(),
                                    FStatus     = "新增",
                                };

                                LeaseDetailsLogService.Add(detailslog);

                                break;
                            }
                        }

                        LeaseDetailsService.SaveChanges();

                        //重新绑定值
                        BindDataGrid();
                    }
                }
                else if (GetRequestEventArgument().Contains("reloadSalesGrid:"))
                {
                    string key = GetRequestEventArgument().Split(':')[1];

                    tbxFSalesNum.Text = key;

                    var sales = new StockOutService().Where(p => p.KeyId == key && p.FCompanyId == CurrentUser.AccountComId
                                                            ).FirstOrDefault();
                    if (sales != null)
                    {
                        txtFCode.Text     = sales.FCode;
                        tbxFCustomer.Text = sales.FName;
                        txtFAddress.Text  = sales.FAddress;
                        txtFPhone.Text    = sales.FPhone;
                        txtFLinkman.Text  = sales.FLinkman;
                    }

                    var data = SqlService.Where(string.Format(@"SELECT * FROM dbo.vm_SalesDetails WHERE FCateId =2000 AND keyId='{0}' and FCompanyId={1}", tbxFSalesNum.Text, CurrentUser.AccountComId));

                    if (data != null && data.Tables.Count > 0 && data.Tables[0].Rows.Count > 0)
                    {
                        var table = data.Tables[0];
                        for (int i = 0; i < table.Rows.Count; i++)
                        {
                            var details = new LHLeaseDetails();

                            decimal price = GasHelper.GeCustomerPrice(txtFCode.Text, //
                                                                      table.Rows[i]["FBottleCode"].ToString(), CurrentUser.AccountComId);

                            details.FBottle    = table.Rows[i]["FBottleCode"].ToString();
                            details.FPrice     = price;
                            details.FAmount    = price;
                            details.FBottleQty = Convert.ToInt32(table.Rows[i]["FBottleQty"]);
                            details.FCompanyId = CurrentUser.AccountComId;
                            details.KeyId      = txtKeyId.Text.Trim();

                            //钢瓶
                            details.FCateId = Convert.ToInt32(table.Rows[i]["FCateId"].ToString());
                            //每天租赁费
                            details.FRentDay = 0;
                            //押金
                            details.FAmount = price;

                            //已归还量
                            details.FReturnQty = 0;

                            LeaseDetailsService.AddEntity(details);

                            //日志
                            switch (Actions)
                            {
                            case WebAction.Add:
                                break;

                            case WebAction.Edit:
                                //记录一下当前新增人操作内容
                                var detailslog = new LHLeaseDetails_Log
                                {
                                    FUpdateBy   = CurrentUser.AccountName,
                                    FUpdateDate = DateTime.Now,
                                    FBottle     = details.FBottle,
                                    FPrice      = price,
                                    FBottleQty  = 1,
                                    FAmount     = price,
                                    KeyId       = txtKeyId.Text.Trim(),
                                    FCompanyId  = CurrentUser.AccountComId,
                                    FStatus     = "新增",
                                };

                                LeaseDetailsLogService.Add(detailslog);

                                break;
                            }
                        }

                        LeaseDetailsService.SaveChanges();

                        //重新绑定值
                        BindDataGrid();
                    }
                }

                #endregion


                #region 更新合计

                //if (Grid1.Rows.Count > 0)
                //{
                //    if (GetRequestEventArgument() == "UPDATE_SUMMARY")
                //    {
                // 页面要求重新计算合计行的值
                OutputSummaryData();

                //写入
                ModifiedGrid();

                // 为了保持前后台上传,回发更新合计行值后,必须进行数据绑定或者提交更改
                Grid1.CommitChanges();
                //    }
                //}

                #endregion
            }
        }