Esempio n. 1
0
        /// ****************************************************************************
        /// <summary>
        /// 删除数据
        /// </summary>
        /// ****************************************************************************
        public void Delete()
        {
            BLL.BiddingDtl cBiddingDtl = new BLL.BiddingDtl();
            cBiddingDtl.BiddingCode = this.ApplicationCode;
            DataTable dtBiddingdtl = cBiddingDtl.GetBiddingDtls();

            foreach (DataRow tempdr in dtBiddingdtl.Select())
            {
                cBiddingDtl.BiddingDtlCode = tempdr["BiddingDtlCode"].ToString();
                cBiddingDtl.BiddingDtlDelete();
            }
        }
Esempio n. 2
0
 /// ****************************************************************************
 /// <summary>
 /// 数据加载
 /// </summary>
 /// ****************************************************************************
 private void LoadData(bool Flag)
 {
     if (this.ApplicationCode != "")
     {
         if (Flag)
         {
             this.dgListEdit.DataSource = GetSourceTable();
             this.dgListEdit.DataBind();
         }
         else
         {
             BLL.BiddingDtl cBiddingDtl = new BLL.BiddingDtl();
             cBiddingDtl.BiddingCode = this.ApplicationCode;
             DataTable dt;
             DataTable dtc;
             if (this.BiddingEmitCode == "")
             {
                 cBiddingDtl.flag = "1";
                 dt  = cBiddingDtl.GetBiddingDtls();
                 dtc = dt;
             }
             else
             {
                 dt  = cBiddingDtl.GetBiddingDtls();
                 dtc = cBiddingDtl.GetBiddingDtls();
                 dtc.Clear();
                 BLL.BiddingReturn bed = new BLL.BiddingReturn();
                 bed.BiddingEmitCode = this.BiddingEmitCode;
                 DataTable det = bed.GetBiddingReturns();
                 for (int i = 0; i < dt.Rows.Count; i++)
                 {
                     if (det.Select(" BiddingDtlCode=" + dt.Rows[i]["BiddingDtlCode"].ToString()).Length != 0)
                     {
                         DataRow dr = dtc.NewRow();
                         dr.ItemArray = dt.Rows[i].ItemArray;
                         dtc.Rows.Add(dr);
                     }
                 }
             }
             this.dgListView.DataSource = dtc;
             this.dgListView.DataBind();
         }
     }
     else
     {
         if (Flag)
         {
             AddNewRows();
         }
     }
 }
Esempio n. 3
0
        private DataTable GetSourceTable()
        {
            BLL.BiddingDtl cBiddingDtl = new BLL.BiddingDtl();
            cBiddingDtl.BiddingCode = this.ApplicationCode;
            cBiddingDtl.flag        = "1";
            DataTable dt = cBiddingDtl.GetBiddingDtls();

            foreach (DataGridItem dgItem in dgListEdit.Items)
            {
                if (dt.Select("BiddingDtlCode=" + dgItem.Cells[0].Text).Length == 0)
                {
                    DataRow dr = dt.NewRow();
                    dr["BiddingDtlCode"] = dgItem.Cells[0].Text;
                    dr["Title"]          = ((TextBox)dgItem.FindControl("txtTitle")).Text;
                    dr["Remark"]         = ((TextBox)dgItem.FindControl("txtRemark")).Text;
                    dr["Money"]          = ((WebNumericEdit)dgItem.FindControl("TxtTemMoney")).Value;
                    //增加特殊需求

                    string companyName = System.Configuration.ConfigurationManager.AppSettings["PMName"].ToString().ToLower();
                    switch (companyName)
                    {
                    case "gaokepm":
                        dr["OtherMoney"] = System.Convert.ToDecimal(((WebNumericEdit)dgItem.FindControl("TxtOtherMoney")).Value);

                        break;

                    default:
                        dr["OtherMoney"] = 0;
                        break;
                    }
                    RmsPM.Web.UserControls.InputCostBudgetDtl cb = ((RmsPM.Web.UserControls.InputCostBudgetDtl)dgItem.FindControl("Inputcostbudgetdtl1"));
                    dr["CostCode"]          = cb.CostCode;
                    dr["CostBudgetSetCode"] = cb.CostBudgetSetCode;
                    dr["PBSCode"]           = cb.PBSCode;
                    dr["PBSType"]           = cb.PBSType;
                    dr["BiddingCode"]       = this.ApplicationCode;
                    dt.Rows.Add(dr);
                }
            }
            foreach (DataRow dr in dt.Select())
            {
                if (this.CheckDtlCode(dr["BiddingDtlCode"].ToString(), this.ViewState["DeleteItems"].ToString()))
                {
                    dt.Rows.Remove(dr);
                }
            }
            return(dt);
        }
Esempio n. 4
0
        /// ****************************************************************************
        /// <summary>
        /// 数据加载
        /// </summary>
        /// ****************************************************************************
        private void LoadData(bool Flag)
        {
            this.CheckBox2.Visible = this.IsWSZTB;
            this.TbWSZTB.Visible   = this.IsWSZTB;
            this.GridView1.Visible = this.IsWSZTB;
            if (this.BiddingEmitCode != "")
            {
                BLL.BiddingReturn cBiddingReturn = new BLL.BiddingReturn();
                cBiddingReturn.BiddingEmitCode = this.BiddingEmitCode;
                BLL.BiddingEmit biddingemit = new BLL.BiddingEmit();
                biddingemit.BiddingEmitCode = this.BiddingEmitCode;
                this.BiddingCode            = biddingemit.BiddingCode;

                DataTable dt = cBiddingReturn.GetBiddingReturns();
                if (Flag)
                {
                    ////////////////////////////////////////////////////////////
                    BLL.BiddingDtl cBiddingDtl = new BLL.BiddingDtl();
                    cBiddingDtl.BiddingCode = this.ApplicationCode;
                    DataTable dtl;
                    dtl = cBiddingDtl.GetBiddingDtls();
                    BLL.BiddingReturn bed = new BLL.BiddingReturn();
                    bed.BiddingEmitCode = this.BiddingEmitCode;
                    DataTable det = bed.GetBiddingReturns();
                    for (int i = 0; i < dtl.Rows.Count; i++)
                    {
                        if ((det.Select(" BiddingDtlCode=" + dtl.Rows[i]["BiddingDtlCode"].ToString()).Length) == 0)
                        {
                            dtl.Rows.Remove(dt.Rows[i]);
                        }
                    }
                    ////////////////////////////////////////////////////////////
                    Bind_dgListEdit(dt);
                    this.txtTotalRemark.Text = biddingemit.TotalRemark;
                }
                else
                {
                    Bind_dgListView(dt);
                }
                dt.Dispose();
                LoadBiddingOpener(false);
                dpAllowAfterClose.SelectedValue = biddingemit.AllowAfterClose.ToString();
            }
            else
            {
                if (this.ViewState["dt"] == null)
                {
                    BLL.BiddingReturn cBiddingReturn = new BLL.BiddingReturn();
                    cBiddingReturn.BiddingEmitCode = this.ApplicationCode;
                    DataTable dt = cBiddingReturn.GetBiddingReturns();

                    //增加新列
                    dt.Columns.Add("BiddingSupplierCode", System.Type.GetType("System.String"));
                    dt.Columns.Add("State2", System.Type.GetType("System.String"));

                    BLL.BiddingPrejudication cBiddingPrejudication = new BLL.BiddingPrejudication();
                    cBiddingPrejudication.BiddingCode = this.BiddingCode;
                    DataTable dtPrejudication = cBiddingPrejudication.GetBiddingPrejudications();
                    for (int i = 0; i < dtPrejudication.Rows.Count; i++)
                    {
                        BLL.BiddingDtl bdl = new BLL.BiddingDtl();
                        bdl.BiddingCode = this.BiddingCode;
                        bdl.flag        = "1";
                        DataTable dtbdl = bdl.GetBiddingDtls();
                        for (int x = 0; x < dtbdl.Rows.Count; x++)
                        {
                            BLL.BiddingSupplier cBiddingSupplier = new BLL.BiddingSupplier();
                            cBiddingSupplier.BiddingPrejudicationCode = dtPrejudication.Rows[i][0].ToString();
                            cBiddingSupplier.Flag = "1";
                            DataTable dtSupplier = cBiddingSupplier.GetBiddingSuppliers();
                            for (int j = 0; j < dtSupplier.Rows.Count; j++)
                            {
                                DataRow dr = dt.NewRow();
                                dr["BiddingReturnCode"]   = DAL.EntityDAO.SystemManageDAO.GetNewSysCode("BiddingReturn");
                                dr["SupplierCode"]        = dtSupplier.Rows[j]["SupplierCode"].ToString();
                                dr["BiddingDtlCode"]      = dtbdl.Rows[x]["BiddingDtlCode"].ToString();
                                dr["OrderCode"]           = dtSupplier.Rows[j]["OrderCode"].ToString();
                                dr["BiddingSupplierCode"] = dtSupplier.Rows[j]["BiddingSupplierCode"].ToString();
                                dr["State2"] = dtSupplier.Rows[j]["State"].ToString();
                                dt.Rows.Add(dr);
                            }
                            dtSupplier.Dispose();
                        }
                    }
                    dtPrejudication.Dispose();
                    this.ViewState["dt"] = dt;
                    dt.Dispose();
                }
                Bind_dgListView((DataTable)this.ViewState["dt"]);
                LoadBiddingOpener(true);
            }
        }
Esempio n. 5
0
        /// ****************************************************************************
        /// <summary>
        /// 提交数据
        /// </summary>
        /// <param name="flag">是否修改(true为修改,false为新增)</param>
        /// ****************************************************************************
        private void _SubmitData(bool flag)
        {
            BLL.BiddingDtl bd = new BLL.BiddingDtl();
            bd.BiddingCode = this.ApplicationCode;
            bd.flag        = "1";
            EntityData entity = bd.GetBiddingDtlEntity();

            foreach (DataRow dr in entity.CurrentTable.Rows)
            {
                dr["Flag"] = "0";
            }
            bd.SubmitDtlEntity(entity);

            decimal TeamMoneyTemp = 0;

            foreach (DataGridItem dgItem in dgListEdit.Items)
            {
                BLL.BiddingDtl cBiddingDtl = new BLL.BiddingDtl();
                cBiddingDtl.BiddingDtlCode = dgItem.Cells[0].Text;
                cBiddingDtl.Title          = ((TextBox)dgItem.FindControl("txtTitle")).Text;
                cBiddingDtl.remark         = ((TextBox)dgItem.FindControl("txtRemark")).Text;
                cBiddingDtl.Money          = ((WebNumericEdit)dgItem.FindControl("TxtTemMoney")).Value.ToString();
                //增加特殊需求

                string companyName = System.Configuration.ConfigurationManager.AppSettings["PMName"].ToString().ToLower();
                switch (companyName)
                {
                case "gaokepm":
                    cBiddingDtl.OtherMoney = ((WebNumericEdit)dgItem.FindControl("TxtOtherMoney")).Value.ToString();

                    break;

                default:
                    cBiddingDtl.OtherMoney = "0";
                    break;
                }

                RmsPM.Web.UserControls.InputCostBudgetDtl cb = ((RmsPM.Web.UserControls.InputCostBudgetDtl)dgItem.FindControl("Inputcostbudgetdtl1"));
                cBiddingDtl.CostCode          = cb.CostCode;
                cBiddingDtl.CostBudgetSetCode = cb.CostBudgetSetCode;
                cBiddingDtl.PBSCode           = cb.PBSCode;
                cBiddingDtl.PBSType           = cb.PBSType;
                cBiddingDtl.flag = "1";
                if (flag)
                {
                    cBiddingDtl.BiddingCode = this.ApplicationCode;
                    cBiddingDtl.BiddingDtlSubmit();
                }
                else
                {
                    cBiddingDtl.BiddingCode = this.ApplicationCode;
                    cBiddingDtl.BiddingDtlAdd();
                }
                TeamMoneyTemp += decimal.Parse(((WebNumericEdit)dgItem.FindControl("TxtTemMoney")).Value.ToString());
            }
            BLL.Bidding b = new BLL.Bidding();
            b.BiddingCode = this.ApplicationCode;
            b.Money       = TeamMoneyTemp.ToString();
            b.BiddingSubmit();
            this.TeamMoney = TeamMoneyTemp.ToString();
        }