Exemple #1
0
        /// <summary>
        ///     提交编辑
        /// </summary>
        private bool SubmintEdit()
        {
            if (StockIn != null)
            {
                ModifiedGrid();

                StockIn.FSalesman             = ddlFSalesman.SelectedValue;
                StockIn.FT6ReceiveSendType    = ddlT6ReceiveSendType.SelectedText;
                StockIn.FT6ReceiveSendTypeNum = ddlT6ReceiveSendType.SelectedValue;
                StockIn.FFreight     = 0;
                StockIn.FLinkman     = "";
                StockIn.FMemo        = txtFMemo.Text.Trim();
                StockIn.FT6Warehouse = ddlFWarehouse.SelectedValue;
                StockIn.FGroup       = ddlFGroup.SelectedValue;

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

                parms.Add("@keyID", StockIn.KeyId);
                parms.Add("@companyId", CurrentUser.AccountComId);
                var amt =
                    Convert.ToDecimal(SqlService.ExecuteProcedureCommand("proc_SalesReturnAmt", parms).Tables[0].Rows[0][0]);

                StockIn.FAmount            = amt;
                StockIn.FDate              = txtFDate.SelectedDate;
                StockIn.FDistributionPoint = ddlFDistributionPoint.SelectedValue;
                StockIn.FCate              = ddlFCate.SelectedValue;
                //StockIn.CreateBy = CurrentUser.AccountName;

                return(StockInService.SaveChanges() >= 0);
            }
            return(false);
        }
Exemple #2
0
        /// <summary>
        ///     提交编辑
        /// </summary>
        private bool SubmintEdit()
        {
            if (StockIn != null)
            {
                ModifiedGrid();


                StockIn.FCompanyId         = CurrentUser.AccountComId;
                StockIn.FDistributionPoint = ddlFDistributionPoint.SelectedValue;

                StockIn.FMemo = txtFMemo.Text.Trim();
                StockIn.FDate = txtFDate.SelectedDate;


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

                parms.Add("@keyID", StockIn.KeyId);
                parms.Add("@companyId", CurrentUser.AccountComId);
                var amt =
                    Convert.ToDecimal(SqlService.ExecuteProcedureCommand("proc_PurchaseAmt", parms).Tables[0].Rows[0][0]);

                StockIn.FAmount  = amt;
                StockIn.CreateBy = CurrentUser.AccountName;

                return(StockInService.SaveChanges() >= 0);
            }
            return(false);
        }
Exemple #3
0
        /// <summary>
        ///     加载页面数据
        /// </summary>
        private void LoadData()
        {
            switch (Actions)
            {
            case WebAction.Add:
                Region1.Title = "添加盘盈单";

                txtKeyId.Text = SequenceService.CreateSequence("TM", CurrentUser.AccountComId);
                var temp = new LHStockIn
                {
                    KeyId = txtKeyId.Text,

                    FFlag = 1,

                    FDeleteFlag = 1,

                    //盘盈单
                    FType = Convert.ToInt32(GasEnumBill.Profit),

                    CreateBy = CurrentUser.AccountName,

                    FDate = txtFDate.SelectedDate,

                    FCompanyId = CurrentUser.AccountComId,

                    FStatus = Convert.ToInt32(GasEnumBillStauts.Add),

                    FProgress = Convert.ToInt32(GasEnumBillStauts.Add),
                };

                //临时写入单据
                StockInService.Add(temp);


                var summary = new JObject
                {
                    { "FItemCode", "合计" },
                    { "FQty", 0 },
                    { "FAmount", 0 }
                };

                Grid1.SummaryData = summary;

                break;

            case WebAction.Edit:
                Region1.Title = "编辑盘盈单";

                txtKeyId.Text = KeyId;
                if (StockIn != null)
                {
                    txtFMemo.Text          = StockIn.FMemo;
                    ddlFCate.SelectedValue = StockIn.FCate;

                    BindDataGrid();
                }
                break;
            }
        }
Exemple #4
0
 public delegateController(IManageRepository _manageRepository, IBomRepository _bomrepository, IPurchaseRepository _bomRepository, IStockInRepository _stockinrepository, IStockOutRepository _stockoutrepository)
 {
     manageService   = new ManageService(_manageRepository);
     bomService      = new BomService(_bomrepository);
     stockoutService = new StockOutService(_stockoutrepository);
     stockinService  = new StockInService(_stockinrepository);
     purchaseService = new PurchaseService(_bomRepository);
 }
Exemple #5
0
        /// <summary>
        ///     提交编辑
        /// </summary>
        private bool SubmintEdit()
        {
            if (StockIn != null)
            {
                ModifiedGrid();

                StockIn.FCate = "内部";
                StockIn.FCode = CurrentUser.AccountComId.ToString(CultureInfo.InvariantCulture);
                StockIn.FName = "";
                StockIn.FMemo = txtFMemo.Text.Trim();
                var parms = new Dictionary <string, object>();
                parms.Clear();

                parms.Add("@keyID", StockIn.KeyId);
                parms.Add("@companyId", CurrentUser.AccountComId);
                var amt =
                    Convert.ToDecimal(SqlService.ExecuteProcedureCommand("proc_PurchaseAmt", parms).Tables[0].Rows[0][0]);

                StockIn.FAmount      = amt;
                StockIn.FBatchNumber = txtFBatchNumber.Text.Trim();

                StockIn.FSurveyor           = !ddlFSurveyor.SelectedValue.Equals("-1") ? ddlFSurveyor.SelectedText : "";
                StockIn.FProducer           = !ddlFProducer.SelectedValue.Equals("-1") ? ddlFProducer.SelectedText : "";//GasHelper.GetDropDownListArrayString(ddlFProducer.SelectedItemArray);
                StockIn.FProductionWorkshop = ddlWorkShop.SelectedValue;
                StockIn.FDate    = txtFDate.SelectedDate;
                StockIn.CreateBy = CurrentUser.AccountName;

                StockInService.SaveChanges();

                var prod =
                    StockInDetailsService.FirstOrDefault(
                        p => p.KeyId == txtKeyId.Text && p.FCompanyId == CurrentUser.AccountComId);

                if (prod != null)
                {
                    prod.FItemCode  = txtFCode.Text;
                    prod.FQty       = Convert.ToDecimal(txtFQty.Text);
                    prod.FBottle    = tbxFBottle.SelectedValue;
                    prod.FBottleQty = Convert.ToInt16(txtFBottleQty.Text);
                    prod.FCostPrice = Convert.ToDecimal(txtFCostPrice.Text);
                    prod.FBalance   = Convert.ToDecimal(txtFBalance.Text);
                    prod.FCostPrice = Convert.ToDecimal(txtFCostPrice.Text);
                    prod.FBalance   = Convert.ToDecimal(txtFBalance.Text);

                    StockInDetailsService.SaveChanges();
                }

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

                SqlService.ExecuteProcedureCommand("proc_ProuctOrder", orders);

                return(true);
            }
            return(false);
        }
Exemple #6
0
 public mainController(IAccountRepository _accountRepository, IManageRepository _manageRepository, IPurchaseRepository _purchaseRepository, IStockInRepository _stockinrepository, IStockOutRepository _stockoutrepository, IBomRepository _bomrepository)
 {
     accountService  = new AccountService(_accountRepository);
     purchaseService = new PurchaseService(_purchaseRepository);
     stockinService  = new StockInService(_stockinrepository);
     stockoutService = new StockOutService(_stockoutrepository);
     manageService   = new ManageService(_manageRepository);
     bomService      = new BomService(_bomrepository);
 }
Exemple #7
0
        /// <summary>
        ///     提交添加
        /// </summary>
        private bool SubmintAdd()
        {
            var stock = StockInService.Where(p => p.KeyId == txtKeyId.Text.Trim()).FirstOrDefault();

            if (stock != null)
            {
                ModifiedGrid();

                stock.FCompanyId         = CurrentUser.AccountComId;
                stock.FDeleteFlag        = 0;
                stock.FMemo              = txtFMemo.Text.Trim();
                stock.FDate              = txtFDate.SelectedDate;
                stock.FDistributionPoint = ddlFDistributionPoint.SelectedValue;

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

                parms.Add("@keyID", stock.KeyId);
                parms.Add("@companyId", CurrentUser.AccountComId);
                var amt =
                    Convert.ToDecimal(SqlService.ExecuteProcedureCommand("proc_PurchaseAmt", parms).Tables[0].Rows[0][0]);

                stock.FAmount = amt;

                StockInService.SaveChanges();

                if (txtKeyId.Text.Contains("TM"))
                {
                    //单据号问题
                    string newKeyId   = SequenceService.CreateSequence(Convert.ToDateTime(txtFDate.SelectedDate), "PY", CurrentUser.AccountComId);
                    var    orderParms = new Dictionary <string, object>();
                    orderParms.Clear();
                    orderParms.Add("@oldKeyId", txtKeyId.Text);
                    orderParms.Add("@newKeyId", newKeyId);
                    orderParms.Add("@Bill", "10");
                    orderParms.Add("@companyId", CurrentUser.AccountComId);
                    SqlService.ExecuteProcedureCommand("proc_num", orderParms);
                    txtKeyId.Text = newKeyId;

                    //新增日志
                    var billStatus = new LHBillStatus
                    {
                        KeyId       = newKeyId,
                        FCompanyId  = CurrentUser.AccountComId,
                        FActionName = "新增",
                        FDate       = DateTime.Now,
                        FDeptId     = CurrentUser.AccountOrgId,
                        FOperator   = CurrentUser.AccountName,
                        FMemo       = String.Format("单据号{0},{1}新增盘盈单据。", newKeyId, CurrentUser.AccountName)
                    };
                    GasHelper.AddBillStatus(billStatus);
                }

                return(true);
            }
            return(false);
        }
        public void FillInventoryDataGridView(DataGridView dgv)        //To be moved to ServiceFacade
        {
            StockInService employeeService = new StockInService();
            var            InventoryList   = employeeService.GetInventoryList();

            dgv.DataSource    = InventoryList;
            dgv.ReadOnly      = true;
            dgv.SelectionMode = DataGridViewSelectionMode.FullRowSelect;
            dgv.DefaultCellStyle.SelectionBackColor = Color.Gray;
        }
Exemple #9
0
        // 根据serial nuber读取入库信息
        private void btnReadStockIn_Click(object sender, EventArgs e)
        {
            string serialNumber = txtSerialNumber.Text;

            stockIn = StockInService.GetBySerialNumber(serialNumber);

            IList <Product> products = ProductService.GetProductsBuStockIn(stockIn);

            dgProducts.DataSource = products;
        }
Exemple #10
0
        /// <summary>
        ///     提交编辑
        /// </summary>
        private bool SubmintEdit()
        {
            if (StockIn != null)
            {
                ModifiedGrid();

                StockIn.FCode              = txtFCode.Text;
                StockIn.FName              = tbxFCustomer.Text;
                StockIn.FAddress           = txtFAddress.Text.Trim();
                StockIn.FCompanyId         = CurrentUser.AccountComId;
                StockIn.FDistributionPoint = ddlFDistributionPoint.SelectedValue;

                //StockIn.FDriver = !ddlFDriver.SelectedValue.Equals("-1") ? ddlFDriver.SelectedText : "";
                StockIn.FShipper = !ddlFShipper.SelectedValue.Equals("-1") ? ddlFShipper.SelectedText : "";
                //StockIn.FSupercargo = !ddlFSupercargo.SelectedValue.Equals("-1") ? ddlFSupercargo.SelectedText : "";
                StockIn.FVehicleNum = !ddlFVehicleNum.SelectedValue.Equals("-1") ? ddlFVehicleNum.SelectedText : "";

                StockIn.FDeliveryMethod = ddlDeliveryMethod.SelectedValue;
                StockIn.FFlag           = 1;
                StockIn.FFreight        = 0;//Convert.ToDecimal(txtFFreight.Text.Trim());
                StockIn.FLinkman        = txtFLinkman.Text.Trim();
                StockIn.FMemo           = txtFMemo.Text.Trim();
                StockIn.FPhone          = txtFPhone.Text.Trim();

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

                parms.Add("@keyID", StockIn.KeyId);
                parms.Add("@companyId", CurrentUser.AccountComId);
                var amt =
                    Convert.ToDecimal(SqlService.ExecuteProcedureCommand("proc_SalesReturnAmt", parms).Tables[0].Rows[0][0]);

                StockIn.FAmount = amt;


                StockIn.FSupercargo = GasHelper.GetDropDownListArrayString(ddlFSupercargo.SelectedItemArray);

                StockIn.FDriver = GasHelper.GetDropDownListArrayString(ddlFDriver.SelectedItemArray);
                StockIn.FClass  = ddlReturn.SelectedValue;
                LHCustomer custmernodel = new CustomerService().FirstOrDefault(p => p.FCode == txtFCode.Text.Trim());
                if (custmernodel != null)
                {
                    hfdCate.Text = "客户";
                }
                else
                {
                    hfdCate.Text = "供应商";
                }
                StockIn.FCate    = hfdCate.Text;
                StockIn.CreateBy = CurrentUser.AccountName;
                StockIn.FDate    = txtFDate.SelectedDate;
                return(StockInService.SaveChanges() >= 0);
            }
            return(false);
        }
Exemple #11
0
        /// <summary>
        ///     作废
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        protected void btnBatchDelete_Click(object sender, EventArgs e)
        {
            IEnumerable <string> selectIds = GetSelectIds();

            try
            {
                Log(string.Format(@"作废单据号:{0}成功。", selectIds));

                //
                foreach (var ids in selectIds)
                {
                    var status = new LHBillStatus();
                    status.FCompanyId  = CurrentUser.AccountComId;
                    status.FDeptId     = CurrentUser.AccountOrgId;
                    status.FDate       = DateTime.Now;
                    status.FOperator   = CurrentUser.AccountName;
                    status.FActionName = EnumDescription.GetFieldText(GasEnumBillStauts.Voided);
                    status.KeyId       = ids;
                    status.FMemo       = string.Format("单据号{0}被{1}作废处理。", ids, CurrentUser.AccountName);

                    GasHelper.AddBillStatus(status);


                    var parms = new Dictionary <string, object>();
                    parms.Clear();
                    parms.Add("@KeyId", ids);
                    parms.Add("@companyId", CurrentUser.AccountComId);
                    parms.Add("@Bill", 6);
                    SqlService.ExecuteProcedureNonQuery("proc_DeleteFlag", parms);
                }

                StockInService.Update(p => p.FCompanyId == CurrentUser.AccountComId && selectIds.Contains(p.KeyId), p => new LHStockIn
                {
                    FFlag     = 0,                                         //
                    FStatus   = Convert.ToInt32(GasEnumBillStauts.Voided), //
                    FProgress = Convert.ToInt32(GasEnumBillStauts.Voided)
                });


                Alert.Show("作废成功!", MessageBoxIcon.Information);
                BindDataGrid();
            }
            catch (Exception)
            {
                Alert.Show("作废失败!", MessageBoxIcon.Warning);
            }
        }
Exemple #12
0
        /// <summary>
        ///     绑定数据表格
        /// </summary>
        private void BindDataGrid()
        {
            int output;

            dynamic orderingSelector;
            Expression <Func <LHStockIn, bool> > predicate = BuildPredicate(out orderingSelector);

            //取数据源
            IQueryable <LHStockIn> list = StockInService.Where(predicate, Grid1.PageSize, Grid1.PageIndex + 1,
                                                               orderingSelector, EnumHelper.ParseEnumByString <OrderingOrders>(SortDirection), out output);

            //设置页面大小
            Grid1.RecordCount = output;

            //绑定数据源
            Grid1.DataSource = list;
            Grid1.DataBind();

            ddlPageSize.SelectedValue = Grid1.PageSize.ToString(CultureInfo.InvariantCulture);
        }
Exemple #13
0
        /// <summary>
        ///     加载页面数据
        /// </summary>
        private void LoadData()
        {
            switch (Actions)
            {
            case WebAction.Add:
                Region1.Title = "添加空瓶回收单";

                txtKeyId.Text = SequenceService.CreateSequence("TM", CurrentUser.AccountComId);
                var temp = new LHStockIn
                {
                    KeyId = txtKeyId.Text,

                    FFlag = 1,

                    FDeleteFlag = 1,

                    //空瓶回收单
                    FType = Convert.ToInt32(GasEnumBill.BottleReturn),

                    CreateBy = CurrentUser.AccountName,

                    FDate = txtFDate.SelectedDate,

                    FCompanyId = CurrentUser.AccountComId,

                    FStatus = Convert.ToInt32(GasEnumBillStauts.Add),

                    FProgress = Convert.ToInt32(GasEnumBillStauts.Add),
                };

                //临时写入单据
                StockInService.Add(temp);

                break;

            case WebAction.Edit:
                Region1.Title = "编辑空瓶回收单";
                txtKeyId.Text = KeyId;
                if (StockIn != null)
                {
                    WebControlHandler.BindObjectToControls(StockIn, SimpleForm1);
                    txtFDate.SelectedDate = StockIn.FDate;
                    tbxFCustomer.Text     = StockIn.FName;

                    if (!string.IsNullOrEmpty(StockIn.FDriver))
                    {
                        ddlFDriver.SelectedValueArray = StockIn.FDriver.Split(',');
                    }
                    if (!string.IsNullOrEmpty(StockIn.FShipper))
                    {
                        ddlFShipper.SelectedValueArray = StockIn.FShipper.Split(',');
                    }
                    if (!string.IsNullOrEmpty(StockIn.FSupercargo))
                    {
                        ddlFSupercargo.SelectedValueArray = StockIn.FSupercargo.Split(',');
                    }
                    if (!string.IsNullOrEmpty(StockIn.FSalesman))
                    {
                        ddlFSalesman.SelectedValueArray = StockIn.FSalesman.Split(',');
                    }

                    ddlFVehicleNum.SelectedValue    = StockIn.FVehicleNum;
                    ddlFArea.SelectedValue          = StockIn.FArea;
                    ddlDeliveryMethod.SelectedValue = StockIn.FDeliveryMethod;
                    ddlReturn.SelectedValue         = StockIn.FClass;
                    ddlDeliveryMethod.SelectedValue = StockIn.FDeliveryMethod;

                    ddlFDistributionPoint.SelectedValue = StockIn.FDistributionPoint;

                    hfdCate.Text = StockIn.FCate;

                    BindDataGrid();
                }
                break;
            }
        }
Exemple #14
0
        /// <summary>
        ///     加载页面数据
        /// </summary>
        private void LoadData()
        {
            switch (Actions)
            {
            case WebAction.Add:

                Region1.Title = "添加生产单";
                txtKeyId.Text = SequenceService.CreateSequence("TM", CurrentUser.AccountComId);
                var temp = new LHStockIn
                {
                    KeyId = txtKeyId.Text,

                    FFlag = 1,

                    FDeleteFlag = 1,

                    //发货单
                    FType = Convert.ToInt32(GasEnumBill.Production),

                    CreateBy = CurrentUser.AccountName,

                    FDate = txtFDate.SelectedDate,

                    FCompanyId = CurrentUser.AccountComId,

                    FStatus = Convert.ToInt32(GasEnumBillStauts.Add),

                    FProgress = Convert.ToInt32(GasEnumBillStauts.Add),
                };

                //临时写入单据
                StockInService.Add(temp);

                break;

            case WebAction.Edit:
                txtKeyId.Text = KeyId;
                Region1.Title = "编辑生产单";

                if (StockIn != null)
                {
                    txtFMemo.Text = StockIn.FMemo;
                    ddlFProducer.SelectedValue = StockIn.FProducer;
                    ddlFSurveyor.SelectedValue = StockIn.FSurveyor;
                    ddlWorkShop.SelectedValue  = StockIn.FProductionWorkshop;
                    var product =
                        StockInDetailsService.Where(
                            p => p.KeyId == KeyId && p.FCompanyId == CurrentUser.AccountComId).FirstOrDefault();

                    if (product != null)
                    {
                        txtFCode.Text            = product.FItemCode;
                        txtFQty.Text             = product.FQty.ToString();
                        tbxFBottle.SelectedValue = product.FBottle;
                        txtFBottleQty.Text       = product.FBottleQty.ToString();
                        txtFCostPrice.Text       = product.FCostPrice.ToString();
                        txtFBalance.Text         = product.FBalance.ToString();

                        //
                        var item =
                            new ItemsService().Where(
                                p => p.FCode == txtFCode.Text && p.FCompanyId == CurrentUser.AccountComId)
                            .FirstOrDefault();

                        if (item != null)
                        {
                            tbxFName.Text = item.FName;
                        }
                    }

                    BindDataGrid();
                }
                break;
            }
        }
Exemple #15
0
        /// <summary>
        ///     提交添加
        /// </summary>
        private bool SubmintAdd()
        {
            var stock = StockInService.Where(p => p.KeyId == txtKeyId.Text.Trim() && p.FCompanyId == CurrentUser.AccountComId).FirstOrDefault();


            if (stock != null)
            {
                ModifiedGrid();

                stock.FFlag       = 1;
                stock.FDeleteFlag = 0;

                stock.FSalesman             = ddlFSalesman.SelectedValue;
                stock.FT6ReceiveSendType    = ddlT6ReceiveSendType.SelectedText;
                stock.FT6ReceiveSendTypeNum = ddlT6ReceiveSendType.SelectedValue;
                stock.FFreight           = 0;
                stock.FLinkman           = "";
                stock.FMemo              = txtFMemo.Text.Trim();
                stock.FT6Warehouse       = ddlFWarehouse.SelectedValue;
                stock.FT6Status          = "未同步";
                stock.FGroup             = ddlFGroup.SelectedValue;
                stock.FDistributionPoint = ddlFDistributionPoint.SelectedValue;

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

                parms.Add("@keyID", stock.KeyId);
                parms.Add("@companyId", CurrentUser.AccountComId);
                var amt =
                    Convert.ToDecimal(SqlService.ExecuteProcedureCommand("proc_SalesReturnAmt", parms).Tables[0].Rows[0][0]);

                stock.FAmount = amt;

                stock.FDate = txtFDate.SelectedDate;

                stock.FCate  = ddlFCate.SelectedValue;
                stock.FTime1 = DateTime.Now;
                StockInService.SaveChanges();

                if (txtKeyId.Text.Contains("TM"))
                {
                    //单据号问题
                    string newKeyId   = SequenceService.CreateSequence(Convert.ToDateTime(txtFDate.SelectedDate), "IN", CurrentUser.AccountComId);
                    var    orderParms = new Dictionary <string, object>();
                    orderParms.Clear();
                    orderParms.Add("@oldKeyId", txtKeyId.Text);
                    orderParms.Add("@newKeyId", newKeyId);
                    orderParms.Add("@Bill", "21");
                    orderParms.Add("@companyId", CurrentUser.AccountComId);
                    SqlService.ExecuteProcedureCommand("proc_num", orderParms);
                    txtKeyId.Text = newKeyId;

                    //新增日志
                    var billStatus = new LHBillStatus
                    {
                        KeyId       = newKeyId,
                        FCompanyId  = CurrentUser.AccountComId,
                        FActionName = "新增",
                        FDate       = DateTime.Now,
                        FDeptId     = CurrentUser.AccountOrgId,
                        FOperator   = CurrentUser.AccountName,
                        FMemo       = String.Format("单据号{0},{1}新增{2}单据。", newKeyId, CurrentUser.AccountName, ddlFCate.SelectedValue)
                    };
                    GasHelper.AddBillStatus(billStatus);
                }

                return(true);
            }


            return(false);
        }
Exemple #16
0
 public StockInManager(int connectorId)
 {
     service = base.CreateService(typeof(StockInService), connectorId) as StockInService;
 }
Exemple #17
0
        /// <summary>
        ///     提交添加
        /// </summary>
        private bool SubmintAdd()
        {
            var stock = StockInService.Where(p => p.KeyId == txtKeyId.Text.Trim() && p.FCompanyId == CurrentUser.AccountComId).FirstOrDefault();

            if (stock != null)
            {
                ModifiedGrid();


                //stock.FClass = ddlFCate.SelectedValue;
                stock.FCode       = txtFCode.Text;
                stock.FName       = tbxFCustomer.Text;
                stock.FAddress    = txtFAddress.Text.Trim();
                stock.FCompanyId  = CurrentUser.AccountComId;
                stock.FFlag       = 1;
                stock.FDeleteFlag = 0;
                if (!string.IsNullOrEmpty(txtFFreight.Text.Trim()))
                {
                    stock.FFreight = Convert.ToDecimal(txtFFreight.Text.Trim());
                }
                stock.FLinkman = txtFLinkman.Text.Trim();
                stock.FMemo    = txtFMemo.Text.Trim();
                stock.FPhone   = txtFPhone.Text.Trim();

                stock.FShipper    = !ddlFShipper.SelectedValue.Equals("-1") ? ddlFShipper.SelectedText : "";
                stock.FVehicleNum = !ddlFVehicleNum.SelectedValue.Equals("-1") ? ddlFVehicleNum.SelectedText : "";


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

                parms.Add("@keyID", stock.KeyId);
                parms.Add("@companyId", CurrentUser.AccountComId);
                var amt =
                    Convert.ToDecimal(SqlService.ExecuteProcedureCommand("proc_PurchaseAmt", parms).Tables[0].Rows[0][0]);

                stock.FAmount          = amt;
                stock.FDate            = txtFDate.SelectedDate;
                stock.FReconciliation  = txtFReconciliation.Text;
                stock.FDeliveryMethod  = ddlDeliveryMethod.SelectedValue;
                stock.FLogisticsNumber = tbxFLogisticsNumber.Text;

                stock.FAmt = string.IsNullOrEmpty(txtFAmt.Text.Trim()) ? 0 : Convert.ToDecimal(txtFAmt.Text.Trim());

                stock.FSupercargo  = GasHelper.GetDropDownListArrayString(ddlFSupercargo.SelectedItemArray);
                stock.FDriver      = GasHelper.GetDropDownListArrayString(ddlFDriver.SelectedItemArray);
                stock.FSubjectCode = ddlSubject.SelectedValue;
                stock.FSubjectName = ddlSubject.SelectedText;

                stock.FDate = txtFDate.SelectedDate;


                #region T6 对接接口
                //---------------------------------------------------------
                //收发类型
                stock.FT6ReceiveSendType    = ddlT6ReceiveSendType.SelectedText;
                stock.FT6ReceiveSendTypeNum = ddlT6ReceiveSendType.SelectedValue;
                //部门名称
                stock.FT6Department = "";
                //部门代码
                stock.FT6DepartmentNum = "";
                //业务员代码
                stock.FT6SalesmanNum = "";
                //币种
                stock.FT6Currency = ddlFT6Currency.SelectedValue;
                //汇率
                stock.FT6ExchangeRate = Convert.ToDecimal(txtFT6ExchangeRate.Text);
                //销售类型
                stock.FT6PurchaseType    = ddlFT6PurchaseType.SelectedText;
                stock.FT6PurchaseTypeNum = ddlFT6PurchaseType.SelectedValue;
                //T6同步
                stock.FT6Status    = "未同步";
                stock.FT6Warehouse = ddlWarehouse.SelectedValue;
                //---------------------------------------------------------
                #endregion


                stock.FDistributionPoint = ddlFDistributionPoint.SelectedValue;


                StockInService.SaveChanges();

                //订单出库
                var passCard = PassCardService.Where(p => p.KeyId == tbxFLogisticsNumber.Text.Trim()).FirstOrDefault();

                if (passCard != null)
                {
                    passCard.FOutFlag = "已出库";

                    PassCardService.SaveChanges();
                }


                if (txtKeyId.Text.Contains("TM"))
                {
                    //单据号问题
                    string newKeyId   = SequenceService.CreateSequence(Convert.ToDateTime(txtFDate.SelectedDate), "WC", CurrentUser.AccountComId);
                    var    orderParms = new Dictionary <string, object>();
                    orderParms.Clear();
                    orderParms.Add("@oldKeyId", txtKeyId.Text);
                    orderParms.Add("@newKeyId", newKeyId);
                    orderParms.Add("@Bill", "4");
                    orderParms.Add("@companyId", CurrentUser.AccountComId);
                    SqlService.ExecuteProcedureCommand("proc_num", orderParms);
                    txtKeyId.Text = newKeyId;

                    //新增日志
                    var billStatus = new LHBillStatus
                    {
                        KeyId       = newKeyId,
                        FCompanyId  = CurrentUser.AccountComId,
                        FActionName = "新增",
                        FDate       = DateTime.Now,
                        FDeptId     = CurrentUser.AccountOrgId,
                        FOperator   = CurrentUser.AccountName,
                        FMemo       = String.Format("单据号{0},{1}新增采购单据。", newKeyId, CurrentUser.AccountName)
                    };
                    GasHelper.AddBillStatus(billStatus);


                    //付款部分
                    var parmsAuto = new Dictionary <string, object>();
                    parmsAuto.Clear();

                    parmsAuto.Add("@KeyId", newKeyId);
                    parmsAuto.Add("@companyId", CurrentUser.AccountComId);
                    parmsAuto.Add("@FCate", "供应商");
                    parmsAuto.Add("@date", Convert.ToDateTime(stock.FDate).ToString("yyyy-MM-dd"));
                    parmsAuto.Add("@FSKNum", string.IsNullOrEmpty(stock.FSKNum) ? "" : stock.FSKNum);

                    SqlService.ExecuteProcedureCommand("proc_FKOrderAuto", parmsAuto);
                }
                return(true);
            }
            return(false);
        }
Exemple #18
0
        /// <summary>
        ///     提交编辑
        /// </summary>
        private bool SubmintEdit()
        {
            if (StockIn != null)
            {
                ModifiedGrid();

                //StockIn.FClass = ddlFCate.SelectedValue;
                StockIn.FCode = txtFCode.Text;
                StockIn.FName = tbxFCustomer.Text;

                StockIn.FAddress   = txtFAddress.Text.Trim();
                StockIn.FCompanyId = CurrentUser.AccountComId;

                StockIn.FShipper    = !ddlFShipper.SelectedValue.Equals("-1") ? ddlFShipper.SelectedText : "";
                StockIn.FVehicleNum = !ddlFVehicleNum.SelectedValue.Equals("-1") ? ddlFVehicleNum.SelectedText : "";

                StockIn.FFlag = 1;
                if (!string.IsNullOrEmpty(txtFFreight.Text.Trim()))
                {
                    StockIn.FFreight = Convert.ToDecimal(txtFFreight.Text.Trim());
                }
                StockIn.FLinkman = txtFLinkman.Text.Trim();
                StockIn.FMemo    = txtFMemo.Text.Trim();
                StockIn.FPhone   = txtFPhone.Text.Trim();

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

                parms.Add("@keyID", StockIn.KeyId);
                parms.Add("@companyId", CurrentUser.AccountComId);
                var amt =
                    Convert.ToDecimal(SqlService.ExecuteProcedureCommand("proc_PurchaseAmt", parms).Tables[0].Rows[0][0]);

                StockIn.FAmount         = amt;
                StockIn.FDate           = txtFDate.SelectedDate;
                StockIn.FSalesman       = ddlFSalesman.SelectedValue;
                StockIn.FArea           = ddlFArea.SelectedValue;
                StockIn.FAmt            = string.IsNullOrEmpty(txtFAmt.Text.Trim()) ? 0 : Convert.ToDecimal(txtFAmt.Text.Trim());
                StockIn.FReconciliation = txtFReconciliation.Text;

                StockIn.FDeliveryMethod  = ddlDeliveryMethod.SelectedValue;
                StockIn.FLogisticsNumber = tbxFLogisticsNumber.Text;

                StockIn.FSupercargo  = GasHelper.GetDropDownListArrayString(ddlFSupercargo.SelectedItemArray);
                StockIn.FDriver      = GasHelper.GetDropDownListArrayString(ddlFDriver.SelectedItemArray);
                StockIn.FSubjectCode = ddlSubject.SelectedValue;
                StockIn.FSubjectName = ddlSubject.SelectedText;
                //StockIn.CreateBy = CurrentUser.AccountName;


                //---------------------------------------------------------
                //收发类型
                StockIn.FT6ReceiveSendType    = ddlT6ReceiveSendType.SelectedText;
                StockIn.FT6ReceiveSendTypeNum = ddlT6ReceiveSendType.SelectedValue;
                //部门名称
                StockIn.FT6Department = "";
                //部门代码
                StockIn.FT6DepartmentNum = "";
                //业务员代码
                StockIn.FT6SalesmanNum = "";
                //币种
                StockIn.FT6Currency = ddlFT6Currency.SelectedValue;
                //汇率
                StockIn.FT6ExchangeRate = Convert.ToDecimal(txtFT6ExchangeRate.Text);
                //销售类型
                StockIn.FT6PurchaseType    = ddlFT6PurchaseType.SelectedText;
                StockIn.FT6PurchaseTypeNum = ddlFT6PurchaseType.SelectedValue;
                //T6同步
                //StockOut.FT6Status = "未同步";
                StockIn.FT6Warehouse       = ddlWarehouse.SelectedValue;
                StockIn.FDistributionPoint = ddlFDistributionPoint.SelectedValue;


                StockInService.SaveChanges();

                //付款部分
                var parmsAuto = new Dictionary <string, object>();
                parmsAuto.Clear();

                parmsAuto.Add("@KeyId", StockIn.KeyId);
                parmsAuto.Add("@companyId", CurrentUser.AccountComId);
                parmsAuto.Add("@FCate", "供应商");
                parmsAuto.Add("@date", Convert.ToDateTime(StockIn.FDate).ToShortDateString());
                parmsAuto.Add("@FSKNum", string.IsNullOrEmpty(StockIn.FSKNum) ? "" : StockIn.FSKNum);

                SqlService.ExecuteProcedureCommand("proc_FKOrderAuto", parmsAuto);

                return(true);
            }
            return(false);
        }
Exemple #19
0
        /// <summary>
        ///     加载页面数据
        /// </summary>
        private void LoadData()
        {
            switch (Actions)
            {
            case WebAction.Add:
                txtKeyId.Text           = SequenceService.CreateSequence("TM", CurrentUser.AccountComId);
                Region1.Title           = "添加采购单";
                txtFT6ExchangeRate.Text = "1";
                var temp = new LHStockIn
                {
                    KeyId = txtKeyId.Text,

                    FFlag = 1,

                    FDeleteFlag = 1,

                    //发货单
                    FType = Convert.ToInt32(GasEnumBill.Purchase),

                    CreateBy = CurrentUser.AccountName,

                    FDate = txtFDate.SelectedDate,

                    FCompanyId = CurrentUser.AccountComId,

                    FStatus = Convert.ToInt32(GasEnumBillStauts.Add),

                    FProgress = Convert.ToInt32(GasEnumBillStauts.Add),

                    FCate = "供应商"
                };

                //临时写入单据
                StockInService.Add(temp);

                //合计
                var summary = new JObject
                {
                    { "FItemCode", "合计" },
                    { "FQty", 0 },
                    { "FAmount", 0 }
                };
                Grid1.SummaryData = summary;
                break;

            case WebAction.Edit:
                Region1.Title = "编辑采购单";
                txtKeyId.Text = KeyId;
                if (StockIn != null)
                {
                    WebControlHandler.BindObjectToControls(StockIn, SimpleForm1);

                    txtFDate.SelectedDate = StockIn.FDate;
                    tbxFCustomer.Text     = StockIn.FName;

                    if (!string.IsNullOrEmpty(StockIn.FDriver))
                    {
                        ddlFDriver.SelectedValueArray = StockIn.FDriver.Split(',');
                    }
                    if (!string.IsNullOrEmpty(StockIn.FShipper))
                    {
                        ddlFShipper.SelectedValueArray = StockIn.FShipper.Split(',');
                    }
                    if (!string.IsNullOrEmpty(StockIn.FSupercargo))
                    {
                        ddlFSupercargo.SelectedValueArray = StockIn.FSupercargo.Split(',');
                    }
                    if (!string.IsNullOrEmpty(StockIn.FSalesman))
                    {
                        ddlFSalesman.SelectedValueArray = StockIn.FSalesman.Split(',');
                    }

                    ddlSubject.SelectedValue        = StockIn.FSubjectCode;
                    ddlFVehicleNum.SelectedValue    = StockIn.FVehicleNum;
                    ddlFArea.SelectedValue          = StockIn.FArea;
                    ddlDeliveryMethod.SelectedValue = StockIn.FDeliveryMethod;

                    ddlFT6PurchaseType.SelectedValue    = StockIn.FT6PurchaseTypeNum;
                    ddlFT6Currency.SelectedValue        = StockIn.FT6Currency;
                    ddlT6ReceiveSendType.SelectedValue  = StockIn.FT6ReceiveSendTypeNum;
                    tbxFLogisticsNumber.Text            = StockIn.FLogisticsNumber;
                    ddlWarehouse.SelectedValue          = StockIn.FT6Warehouse;
                    ddlFDistributionPoint.SelectedValue = StockIn.FDistributionPoint;

                    BindDataGrid();
                }
                break;
            }
        }
Exemple #20
0
        /// <summary>
        ///     加载页面数据
        /// </summary>
        private void LoadData()
        {
            switch (Actions)
            {
            case WebAction.Add:
                txtKeyId.Text = SequenceService.CreateSequence("TM", CurrentUser.AccountComId);
                Region3.Title = "添加入库单";

                var temp = new LHStockIn
                {
                    KeyId = txtKeyId.Text,

                    FFlag = 1,

                    FAuditFlag = 1,

                    FDeleteFlag = 1,

                    //发货单
                    FType = Convert.ToInt32(GasEnumBill.output),

                    CreateBy = CurrentUser.AccountName,

                    FDate = txtFDate.SelectedDate,

                    FCompanyId = CurrentUser.AccountComId,

                    FStatus = Convert.ToInt32(GasEnumBillStauts.Add),

                    FProgress = Convert.ToInt32(GasEnumBillStauts.Add),
                };

                //临时写入单据
                StockInService.Add(temp);

                //合计
                var summary = new JObject
                {
                    { "FItemCode", "合计" },
                    { "FQty", 0 },
                    { "FAmount", 0 }
                };

                Grid1.SummaryData = summary;

                break;

            case WebAction.Edit:
                txtKeyId.Text = KeyId;

                Region3.Title = "编辑入库单";
                if (StockIn != null)
                {
                    WebControlHandler.BindObjectToControls(StockIn, SimpleForm1);
                    txtFDate.SelectedDate = StockIn.FDate;

                    ddlFCate.SelectedValue = StockIn.FCate;

                    ddlFSalesman.SelectedValue = StockIn.FSalesman;

                    ddlFWarehouse.SelectedValue = StockIn.FT6Warehouse;

                    ddlT6ReceiveSendType.SelectedValue = StockIn.FT6ReceiveSendTypeNum;

                    ddlFGroup.SelectedValue = StockIn.FGroup;

                    ddlFDistributionPoint.SelectedValue = StockIn.FDistributionPoint;

                    BindDataGrid();
                }
                break;
            }
        }
Exemple #21
0
        /// <summary>
        ///     提交添加
        /// </summary>
        private bool SubmintAdd()
        {
            var stock = StockInService.Where(p => p.KeyId == txtKeyId.Text.Trim() && p.FCompanyId == CurrentUser.AccountComId).FirstOrDefault();

            if (stock != null)
            {
                ModifiedGrid();

                stock.FCode       = txtFCode.Text;
                stock.FName       = tbxFCustomer.Text;
                stock.FAddress    = txtFAddress.Text.Trim();
                stock.FCompanyId  = CurrentUser.AccountComId;
                stock.FFlag       = 1;
                stock.FDeleteFlag = 0;
                stock.FFreight    = 0;// Convert.ToDecimal(txtFFreight.Text.Trim());
                stock.FLinkman    = txtFLinkman.Text.Trim();
                stock.FMemo       = txtFMemo.Text.Trim();
                stock.FPhone      = txtFPhone.Text.Trim();

                //stock.FDriver = !ddlFDriver.SelectedValue.Equals("-1") ? ddlFDriver.SelectedText : "";
                stock.FShipper = !ddlFShipper.SelectedValue.Equals("-1") ? ddlFShipper.SelectedText : "";
                //stock.FSupercargo = !ddlFSupercargo.SelectedValue.Equals("-1") ? ddlFSupercargo.SelectedText : "";
                stock.FVehicleNum = !ddlFVehicleNum.SelectedValue.Equals("-1") ? ddlFVehicleNum.SelectedText : "";


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

                parms.Add("@keyID", stock.KeyId);
                parms.Add("@companyId", CurrentUser.AccountComId);
                var amt =
                    Convert.ToDecimal(SqlService.ExecuteProcedureCommand("proc_SalesReturnAmt", parms).Tables[0].Rows[0][0]);

                stock.FAmount          = amt;
                stock.FReconciliation  = txtFReconciliation.Text;
                stock.FDeliveryMethod  = ddlDeliveryMethod.SelectedValue;
                stock.FLogisticsNumber = txtFLogisticsNumber.Text;

                stock.FSupercargo = GasHelper.GetDropDownListArrayString(ddlFSupercargo.SelectedItemArray);
                stock.FDriver     = GasHelper.GetDropDownListArrayString(ddlFDriver.SelectedItemArray);

                stock.FClass = ddlReturn.SelectedValue;
                LHCustomer custmernodel = new CustomerService().FirstOrDefault(p => p.FCode == txtFCode.Text.Trim());
                if (custmernodel != null)
                {
                    hfdCate.Text = "客户";
                }
                else
                {
                    hfdCate.Text = "供应商";
                }
                stock.FCate = hfdCate.Text;
                stock.FDate = txtFDate.SelectedDate;
                stock.FDistributionPoint = ddlFDistributionPoint.SelectedValue;
                stock.FTime1             = DateTime.Now;

                StockInService.SaveChanges();


                if (txtKeyId.Text.Contains("TM"))
                {
                    //单据号问题
                    string newKeyId   = SequenceService.CreateSequence(Convert.ToDateTime(txtFDate.SelectedDate), "HK", CurrentUser.AccountComId);
                    var    orderParms = new Dictionary <string, object>();
                    orderParms.Clear();
                    orderParms.Add("@oldKeyId", txtKeyId.Text);
                    orderParms.Add("@newKeyId", newKeyId);
                    orderParms.Add("@Bill", "13");
                    orderParms.Add("@companyId", CurrentUser.AccountComId);
                    SqlService.ExecuteProcedureCommand("proc_num", orderParms);
                    txtKeyId.Text = newKeyId;

                    //新增日志
                    var billStatus = new LHBillStatus
                    {
                        KeyId       = newKeyId,
                        FCompanyId  = CurrentUser.AccountComId,
                        FActionName = "新增",
                        FDate       = DateTime.Now,
                        FDeptId     = CurrentUser.AccountOrgId,
                        FOperator   = CurrentUser.AccountName,
                        FMemo       = String.Format("单据号{0},{1}新增空瓶回收单据。", newKeyId, CurrentUser.AccountName)
                    };
                    GasHelper.AddBillStatus(billStatus);
                }
                return(true);
            }
            return(false);
        }
Exemple #22
0
        /// <summary>
        ///     提交添加
        /// </summary>
        private bool SubmintAdd()
        {
            var stock = StockInService.Where(p => p.KeyId == txtKeyId.Text.Trim() && p.FCompanyId == CurrentUser.AccountComId).FirstOrDefault();

            if (stock != null)
            {
                ModifiedGrid();

                var prod =
                    StockInDetailsService.FirstOrDefault(
                        p => p.KeyId == txtKeyId.Text && p.FCompanyId == CurrentUser.AccountComId);

                if (prod == null)
                {
                    //生产产品入库
                    var product = new LHStockInDetails
                    {
                        KeyId         = txtKeyId.Text,
                        FItemCode     = txtFCode.Text,
                        FPrice        = 0,
                        FAmount       = 0,
                        FQty          = Convert.ToDecimal(txtFQty.Text),
                        FBottle       = tbxFBottle.SelectedValue,
                        FBottleQty    = Convert.ToInt16(txtFBottleQty.Text),
                        FBottleOweQty = 0,
                        FCompanyId    = CurrentUser.AccountComId,
                        FCateId       = 2000,
                        FMemo         = "生产入库",
                        FCostPrice    = Convert.ToDecimal(txtFCostPrice.Text),
                        FBalance      = Convert.ToDecimal(txtFBalance.Text),
                    };

                    StockInDetailsService.Add(product);
                }
                else
                {
                    prod.FItemCode  = txtFCode.Text;
                    prod.FQty       = Convert.ToDecimal(txtFQty.Text);
                    prod.FBottle    = tbxFBottle.SelectedValue;
                    prod.FBottleQty = Convert.ToInt32(txtFBottleQty.Text);
                    prod.FCostPrice = Convert.ToDecimal(txtFCostPrice.Text);
                    prod.FBalance   = Convert.ToDecimal(txtFBalance.Text);

                    StockInDetailsService.SaveChanges();
                }
                //-------------------------------------------------------------------

                stock.FCompanyId  = CurrentUser.AccountComId;
                stock.FFlag       = 1;
                stock.FDeleteFlag = 0;
                stock.FMemo       = txtFMemo.Text.Trim();

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

                parms.Add("@keyID", stock.KeyId);
                parms.Add("@companyId", CurrentUser.AccountComId);
                var amt =
                    Convert.ToDecimal(SqlService.ExecuteProcedureCommand("proc_PurchaseAmt", parms).Tables[0].Rows[0][0]);

                stock.FAmount = amt;

                stock.FSurveyor = !ddlFSurveyor.SelectedValue.Equals("-1") ? ddlFSurveyor.SelectedText : "";
                stock.FProducer = !ddlFProducer.SelectedValue.Equals("-1") ? ddlFProducer.SelectedText : "";//GasHelper.GetDropDownListArrayString(ddlFProducer.SelectedItemArray);

                stock.FBatchNumber = txtFBatchNumber.Text.Trim();

                stock.FProductionWorkshop = ddlWorkShop.SelectedValue;

                stock.FCate = "内部";
                stock.FCode = CurrentUser.AccountComId.ToString(CultureInfo.InvariantCulture);
                stock.FName = "";
                stock.FDate = txtFDate.SelectedDate;


                StockInService.SaveChanges();


                if (txtKeyId.Text.Contains("TM"))
                {
                    //单据号问题
                    string newKeyId   = SequenceService.CreateSequence(Convert.ToDateTime(txtFDate.SelectedDate), "PR", CurrentUser.AccountComId);
                    var    orderParms = new Dictionary <string, object>();
                    orderParms.Clear();
                    orderParms.Add("@oldKeyId", txtKeyId.Text);
                    orderParms.Add("@newKeyId", newKeyId);
                    orderParms.Add("@Bill", "6");
                    orderParms.Add("@companyId", CurrentUser.AccountComId);
                    SqlService.ExecuteProcedureCommand("proc_num", orderParms);
                    txtKeyId.Text = newKeyId;



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

                    SqlService.ExecuteProcedureCommand("proc_ProuctOrder", orders);


                    //新增日志
                    var billStatus = new LHBillStatus
                    {
                        KeyId       = newKeyId,
                        FCompanyId  = CurrentUser.AccountComId,
                        FActionName = "新增",
                        FDate       = DateTime.Now,
                        FDeptId     = CurrentUser.AccountOrgId,
                        FOperator   = CurrentUser.AccountName,
                        FMemo       = String.Format("单据号{0},{1}新增生产单据。", newKeyId, CurrentUser.AccountName)
                    };
                    GasHelper.AddBillStatus(billStatus);
                }

                return(true);
            }
            return(false);
        }
Exemple #23
0
        protected void btnSubmit_Click(object sender, EventArgs e)
        {
            bool isSucceed = false;

            try
            {
                switch (Actions)
                {
                case WebAction.Add:
                    isSucceed = SubmintAdd();
                    break;

                case WebAction.Edit:
                    isSucceed = SubmintEdit();
                    break;
                }

                tmsModel t = new tmsModel();
                try
                {
                    IQueryable <LHDispatchCenter> center = DispatchCenterService.Where(p => p.KeyId == lblKeyId.Text);
                    if (center.Count() > 0)
                    {
                        t.dispatchCenterList = center.ToList();
                    }
                    IQueryable <LHStockOut> iP = new StockOutService().Where(p => p.FDispatchNum == lblKeyId.Text);
                    t.stockOutList        = iP.ToList <LHStockOut>();
                    t.stockOutDetailsList = new List <LHStockOutDetails>();
                    foreach (LHStockOut item in iP)
                    {
                        IQueryable <LHStockOutDetails> li = new StockOutDetailsService().Where(p => p.KeyId == item.KeyId);
                        foreach (LHStockOutDetails outDetails in li)
                        {
                            t.stockOutDetailsList.Add(outDetails);
                        }
                    }
                    IQueryable <LHPassCard> lHPasses = PassCardService.Where(p => p.FDispatchNum == lblKeyId.Text);
                    if (lHPasses != null)
                    {
                        t.passCardList = lHPasses.ToList();
                    }

                    t.passCardDetailsList = new List <LHPassCardDetails>();
                    foreach (LHPassCard item in t.passCardList)
                    {
                        IQueryable <LHPassCardDetails> cardDetails = new PassCardDetailsService().Where(p => p.KeyId == item.KeyId);
                        foreach (LHPassCardDetails details in cardDetails)
                        {
                            t.passCardDetailsList.Add(details);
                        }
                    }

                    IQueryable <LHStockIn> skin = new StockInService().Where(p => p.FDispatchNum == lblKeyId.Text);
                    if (skin != null && skin.Count() > 0)
                    {
                        t.stockInList        = skin.ToList();
                        t.stockInDetailsList = new List <LHStockInDetails>();
                        foreach (LHStockIn item in skin)
                        {
                            IQueryable <LHStockInDetails> inDetails = new StockInDetailsService().Where(p => p.KeyId == item.KeyId);
                            foreach (LHStockInDetails inDetail in inDetails)
                            {
                                t.stockInDetailsList.Add(inDetail);
                            }
                        }
                    }
                    new HttpRequest().httpRequest(t, "open/dbo/dboData");
                }
                catch (Exception)
                {
                }
            }
            catch (DbEntityValidationException ex)
            {
                string msg = string.Empty;
                List <ICollection <DbValidationError> > errors = (from u in ex.EntityValidationErrors select u.ValidationErrors).ToList();
                foreach (ICollection <DbValidationError> item in errors)
                {
                    msg += item.FirstOrDefault().ErrorMessage;
                }
                isSucceed = false;
            }
            finally
            {
                if (isSucceed)
                {
                    PageContext.RegisterStartupScript(ActiveWindow.GetHidePostBackReference());
                }
                else
                {
                    Alert.Show("提交失败!", MessageBoxIcon.Error);
                }
            }
        }
Exemple #24
0
 public manageController(IManageRepository _manageRepository, IStockInRepository _stockinrepository)
 {
     manageService = new ManageService(_manageRepository); stockinService = new StockInService(_stockinrepository);
 }