Exemplo n.º 1
0
        /// <summary>
        ///     提交编辑
        /// </summary>
        private bool SubmintEdit()
        {
            if (To != null)
            {
                To.XBill = ddlBill.SelectedValue;

                if (!string.IsNullOrEmpty(tbxFVehicleNum.Text))
                {
                    To.XVehicleNum = tbxFVehicleNum.Text;
                    To.XTo         = tbxFVehicleNum.Text;
                }

                if (!string.IsNullOrEmpty(txtFMarginEnd.Text))
                {
                    To.XMarginEnd = string.IsNullOrEmpty(txtFMarginEnd.Text) ? 0 : Convert.ToDecimal(txtFMarginEnd.Text);
                }

                if (!string.IsNullOrEmpty(txtFQty.Text))
                {
                    To.XQty = string.IsNullOrEmpty(txtFQty.Text) ? 0 : Convert.ToDecimal(txtFQty.Text);
                }

                To.XMemo = txtFMemo.Text;

                To.XFDate = DateTime.Now;

                To.XCreateBy = CurrentUser.AccountName;

                LiquidToService.SaveChanges();


                var parms = new Dictionary <string, object>();
                parms.Clear();

                parms.Add("@companyId", CurrentUser.AccountComId);
                parms.Add("@keyid", KeyId);

                SqlService.ExecuteProcedureCommand("proc_LiquidMargin", parms);

                var parmsTo = new Dictionary <string, object>();
                parmsTo.Clear();
                parmsTo.Add("@companyId", CurrentUser.AccountComId);
                parmsTo.Add("@KeyId", KeyId);

                SqlService.ExecuteProcedureCommand("proc_LiquidTo", parmsTo);

                return(true);
            }
            return(false);
        }
Exemplo n.º 2
0
        /// <summary>
        ///     提交添加
        /// </summary>
        private bool SubmintAdd()
        {
            var its = new LHLiquidTo
            {
                XKeyId     = KeyId,
                XCompanyId = CurrentUser.AccountComId,
                XBill      = ddlBill.SelectedValue
            };

            if (!string.IsNullOrEmpty(tbxFVehicleNum.SelectedValue))
            {
                its.XTo = tbxFVehicleNum.SelectedValue;
            }

            if (!string.IsNullOrEmpty(txtFMarginEnd.Text))
            {
                its.XMarginEnd = string.IsNullOrEmpty(txtFMarginEnd.Text) ? 0 : Convert.ToDecimal(txtFMarginEnd.Text);
            }

            if (!string.IsNullOrEmpty(txtFQty.Text))
            {
                its.XQty = string.IsNullOrEmpty(txtFQty.Text) ? 0 : Convert.ToDecimal(txtFQty.Text);
            }

            its.XMemo = txtFMemo.Text;

            LiquidToService.Add(its);


            var parms = new Dictionary <string, object>();

            parms.Clear();

            parms.Add("@companyId", CurrentUser.AccountComId);
            parms.Add("@keyid", KeyId);

            SqlService.ExecuteProcedureCommand("proc_LiquidMargin", parms);

            var parmsTo = new Dictionary <string, object>();

            parmsTo.Clear();
            parmsTo.Add("@companyId", CurrentUser.AccountComId);
            parmsTo.Add("@KeyId", KeyId);

            SqlService.ExecuteProcedureCommand("proc_LiquidTo", parmsTo);

            return(true);
        }
Exemplo n.º 3
0
        /// <summary>
        ///     Grid1_RowCommand
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        protected void Grid1_RowCommand(object sender, GridCommandEventArgs e)
        {
            var commandName = e.CommandName;
            var datakey     = Grid1.DataKeys[e.RowIndex][0].ToString();


            switch (commandName)
            {
            case "Delete":
                LiquidPlanService.Delete(p => p.KeyId == datakey && p.FCompanyId == CurrentUser.AccountComId);

                Alert.Show("删除成功。", MessageBoxIcon.Information);

                break;

            case "Pound":

                PageContext.RegisterStartupScript(
                    Window1.GetShowReference(string.Format("./PoundEdit.aspx?KeyId={0}&action=2",
                                                           datakey), "填写磅单"));
                break;

            case "Submit":

                var parms = new Dictionary <string, object>();
                parms.Clear();

                parms.Add("@companyId", CurrentUser.AccountComId);
                parms.Add("@keyId", datakey);

                SqlService.ExecuteProcedureCommand("proc_LiquidPlan", parms);

                Alert.Show("磅单成功。", MessageBoxIcon.Information);

                break;


            case "To":
                var dataqty = Grid1.DataKeys[e.RowIndex][1].ToString();


                var to =
                    LiquidToService.FirstOrDefault(
                        p => p.XCompanyId == CurrentUser.AccountComId && p.XKeyId == datakey);
                if (to != null)
                {
                    PageContext.RegisterStartupScript(
                        Window4.GetShowReference(string.Format("./LiquidTo.aspx?KeyId={0}&qty={1}&action=2",
                                                               datakey, dataqty), "导气"));
                }
                else
                {
                    PageContext.RegisterStartupScript(
                        Window4.GetShowReference(string.Format("./LiquidTo.aspx?KeyId={0}&qty={1}&action=1",
                                                               datakey, dataqty), "导气"));
                }

                //var parmsTo = new Dictionary<string, object>();
                //parmsTo.Clear();
                //parmsTo.Add("@companyId", CurrentUser.AccountComId);
                //parmsTo.Add("@KeyId", datakey);

                //SqlService.ExecuteProcedureCommand("proc_LiquidTo",parmsTo);


                break;
            }

            BindDataGrid();
        }