Esempio n. 1
0
 private void UpdataData(string auto_no)
 {
     if (this.PanDuan())
     {
         PD_FOUND_OUT_Bll bll = new PD_FOUND_OUT_Bll();
         if (bll.Exists(long.Parse(auto_no)))
         {
             PD_FOUND_OUT_Model model = this.GetModel(bll.GetModel(long.Parse(auto_no)));
             bll.Update(model);
             bll.UpdateLJMoney(model.PD_PROJECT_CODE);
             PageShowText.Refurbish("修改成功", this.Page);
         }
     }
 }
Esempio n. 2
0
 private void BindList()
 {
     DataSet list = new PD_FOUND_OUT_Bll().GetList("");
     if ((list != null) && (list.Tables.Count > 0))
     {
         this.gvResult.DataSource = list.Tables[0];
         this.gvResult.DataBind();
     }
 }
Esempio n. 3
0
 private void ShowInfo(string _AUTO_ID)
 {
     if (!string.IsNullOrEmpty(_AUTO_ID))
     {
         this.AUTO_NO = long.Parse(_AUTO_ID);
         PD_FOUND_OUT_Bll bll = new PD_FOUND_OUT_Bll();
         if (bll.Exists(this.AUTO_NO))
         {
             PD_FOUND_OUT_Model modelName = bll.GetModelName(this.AUTO_NO);
             this.txtAUTO_NO.Text = modelName.AUTO_NO.ToString();
             this.ddlPD_YEAR.SelectedValue = modelName.PD_YEAR.ToString();
             this.txtPD_FOUND_DATE.Text = modelName.PD_FOUND_DATE.ToString();
             this.ddlPD_IF_HAVE.SelectedValue = modelName.PD_IF_HAVE.ToString();
             this.txtPD_PROJECT_CODE.Text = modelName.PD_PROJECT_CODE;
             this.txtPD_PROJECT_NAME.Text = modelName.PD_PROJECT_NAME;
             this.txtPD_CONTRACT_COMPANY.Text = modelName.PD_CONTRACT_COMPANY;
             this.txtPD_FOUND_COMPANY.Text = modelName.PD_FOUND_COMPANY;
             this.txtPD_CONTRACT_MONEY.Text = modelName.PD_CONTRACT_MONEY.ToString();
             this.ddlPD_FOUND_SOURCES.SelectedValue = modelName.PD_FOUND_SOURCES;
             this.ddlPD_FOUND_TYPE.SelectedValue = modelName.PD_FOUND_TYPE;
             this.ddlPD_FOUND_STYLE.SelectedValue = modelName.PD_FOUND_STYLE;
             this.txtPD_FOUND_ACC_TYPE.Text = modelName.PD_FOUND_ACC_TYPE;
             this.txtPD_FOUND_VOUNO.Text = modelName.PD_FOUND_VOUNO;
             this.txtPD_FOUND_MONEY.Text = modelName.PD_FOUND_MONEY.ToString();
             this.txtPD_FOUND_MONEY_TOTAL.Text = modelName.PD_FOUND_MONEY_TOTAL.Value.ToString("0.00");
             if ((modelName.PD_FOUND_MONEY_WCL != null) && (modelName.PD_FOUND_MONEY_WCL.Trim().Length != 0))
             {
                 this.txtPD_FOUND_MONEY_WCL.Text = modelName.PD_FOUND_MONEY_WCL + "%";
             }
             else
             {
                 this.txtPD_FOUND_MONEY_WCL.Text = "0%";
             }
             this.txtPD_FOUND_FILENAME.Text = modelName.PD_FOUND_FILENAME;
             this.txtPD_FOUND_SYS_FILENAME.Text = modelName.PD_FOUND_SYS_FILENAME;
             this.txtPD_PROJECT_CONTRACT.Text = modelName.PD_PROJECT_CONTRACT;
             this.txtPD_PROJECT_MONEY_TOTAL.Text = modelName.PD_PROJECT_MONEY_TOTAL;
             this.txtPD_FOUND_ACC_TYPE.Text = modelName.PD_PROJECT_GNFL;
             this.txtPD_FOUND_SYS_JJFL.Text = modelName.PD_PROJECT_JJFL;
             this.ddlyear.SelectedValue = modelName.PD_PZ_YEAR.ToString();
             this.ddlmonth.SelectedValue = modelName.PD_PZ_MONTH.ToString();
             this.ddlPD_CONTRACT_TYPE.SelectedValue = modelName.PD_CONTRACT_TYPE.ToString();
             this.txtPD_PROJECT_CONTRACT.Text = modelName.PD_PROJECT_CONTRACT;
             this.txtcontract_name.Text = modelName.PD_PROJECT_CONTRACT_NAME;
         }
     }
 }
Esempio n. 4
0
 private PD_FOUND_OUT_Model GetModel(PD_FOUND_OUT_Model model)
 {
     if (model == null)
     {
         model = new PD_FOUND_OUT_Model();
         PD_FOUND_OUT_Bll bll = new PD_FOUND_OUT_Bll();
         decimal num = bll.getProjectJSZJE(this.txtPD_PROJECT_CODE.Text);
         DateTime? nullable = null;
         if (PublicDal.PageValidate.IsDateTime(this.txtPD_FOUND_DATE.Text))
         {
             nullable = new DateTime?(DateTime.Parse(this.txtPD_FOUND_DATE.Text));
         }
         decimal num2 = bll.getLJMoney(this.txtPD_PROJECT_CODE.Text, -1L, nullable) + decimal.Parse(this.txtPD_FOUND_MONEY.Text);
         model.PD_FOUND_MONEY_TOTAL = new decimal?(num2);
         model.PD_FOUND_MONEY_WCL = ((model.PD_FOUND_MONEY_TOTAL.Value / num) * 100M).ToString("0.00");
     }
     else
     {
         PD_FOUND_OUT_Bll bll2 = new PD_FOUND_OUT_Bll();
         decimal num3 = bll2.getProjectJSZJE(this.txtPD_PROJECT_CODE.Text);
         DateTime? nullable2 = null;
         if (PublicDal.PageValidate.IsDateTime(this.txtPD_FOUND_DATE.Text))
         {
             nullable2 = new DateTime?(DateTime.Parse(this.txtPD_FOUND_DATE.Text));
         }
         decimal num4 = bll2.getLJMoney(this.txtPD_PROJECT_CODE.Text, model.AUTO_NO, nullable2) + decimal.Parse(this.txtPD_FOUND_MONEY.Text);
         model.PD_FOUND_MONEY_TOTAL = new decimal?(num4);
         model.PD_FOUND_MONEY_WCL = ((model.PD_FOUND_MONEY_TOTAL.Value / num3) * 100M).ToString("0.00");
     }
     if (PublicDal.PageValidate.IsInt(this.ddlPD_YEAR.SelectedValue))
     {
         model.PD_YEAR = new int?(int.Parse(this.ddlPD_YEAR.SelectedValue));
     }
     if (PublicDal.PageValidate.IsInt(this.ddlmonth.SelectedValue))
     {
         model.PD_PZ_MONTH = new int?(int.Parse(this.ddlmonth.SelectedValue));
     }
     if (PublicDal.PageValidate.IsDateTime(this.txtPD_FOUND_DATE.Text))
     {
         model.PD_FOUND_DATE = new DateTime?(DateTime.Parse(this.txtPD_FOUND_DATE.Text));
     }
     if (PublicDal.PageValidate.IsInt(this.ddlPD_IF_HAVE.SelectedValue))
     {
         model.PD_IF_HAVE = new int?(int.Parse(this.ddlPD_IF_HAVE.SelectedValue));
     }
     model.PD_PROJECT_CODE = this.txtPD_PROJECT_CODE.Text;
     model.PD_PROJECT_NAME = this.txtPD_PROJECT_NAME.Text;
     model.PD_CONTRACT_COMPANY = this.txtPD_CONTRACT_COMPANY.Text;
     model.PD_FOUND_COMPANY = this.txtPD_FOUND_COMPANY.Text;
     if (PublicDal.PageValidate.IsDecimal(this.txtPD_CONTRACT_MONEY.Text))
     {
         model.PD_CONTRACT_MONEY = new decimal?(decimal.Parse(this.txtPD_CONTRACT_MONEY.Text));
     }
     model.PD_FOUND_SOURCES = this.ddlPD_FOUND_SOURCES.SelectedValue;
     model.PD_FOUND_TYPE = this.ddlPD_FOUND_TYPE.SelectedValue;
     model.PD_FOUND_STYLE = this.ddlPD_FOUND_STYLE.SelectedValue;
     model.PD_FOUND_ACC_TYPE = this.txtPD_FOUND_ACC_TYPE.Text;
     model.PD_FOUND_VOUNO = this.txtPD_FOUND_VOUNO.Text;
     if (PublicDal.PageValidate.IsDecimal(this.txtPD_FOUND_MONEY.Text))
     {
         model.PD_FOUND_MONEY = new decimal?(decimal.Parse(this.txtPD_FOUND_MONEY.Text));
     }
     model.PD_FOUND_FILENAME = this.txtPD_FOUND_FILENAME.Text;
     model.PD_FOUND_SYS_FILENAME = this.txtPD_FOUND_SYS_FILENAME.Text;
     model.PD_PROJECT_CONTRACT = this.txtPD_PROJECT_CONTRACT.Text;
     model.PD_CONTRACT_TYPE = this.ddlPD_CONTRACT_TYPE.SelectedValue;
     model.PD_CONTRACT_NO = this.txtPD_PROJECT_CONTRACT.Text;
     model.PD_PZ_YEAR = new int?(int.Parse(this.ddlyear.SelectedValue));
     return model;
 }
Esempio n. 5
0
 private void CreateData()
 {
     if (this.PanDuan())
     {
         PD_FOUND_OUT_Model model = this.GetModel(null);
         PD_FOUND_OUT_Bll bll = new PD_FOUND_OUT_Bll();
         model.PD_NOW_SERVERPK = PublicDal.SetCreateServiceStream(this.Page);
         bll.Add(model);
         bll.UpdateLJMoney(model.PD_PROJECT_CODE);
         Const.DoSuccessNoClose("添加成功", this.Page.Request.Url.LocalPath + "?UpdatePK=" + model.AUTO_NO, this.Page);
     }
 }
Esempio n. 6
0
 public void OutPut_PingZheng(string auto_no)
 {
     PD_FOUND_OUT_Bll bll = new PD_FOUND_OUT_Bll();
     string str = this.txt_kjkmDB_JF.Value.Trim();
     string str2 = this.txt_kjkmDB_DF.Value.Trim();
     string fzhs = this.txt_fzhs_DB.Value.Trim();
     string databaseName = this.db_name.Value.Trim();
     string str5 = bll.OutPut_PingZheng(auto_no, databaseName, str, str2, fzhs);
     if (str5 == null)
     {
         str5 = "拨付成功,已导入凭证";
     }
     PageShowText.Refurbish(str5, this.Page);
 }
Esempio n. 7
0
 private void ShowInfo(string PD_PROJECT_CODE)
 {
     TB_PROJECT_Model model = new TB_PROJECT_Bll().GetModel(PD_PROJECT_CODE);
     this.txtPD_PROJECT_CODE.Enabled = false;
     this.txtPD_PROJECT_NAME.Enabled = false;
     this.imgSearch.Attributes.Remove("onclick");
     this.txtPD_PROJECT_NAME.Attributes.Remove("QiPao");
     this.txtPD_PROJECT_CODE.Text = model.PD_PROJECT_CODE;
     this.txtPD_PROJECT_NAME.Text = model.PD_PROJECT_NAME;
     this.ddlPD_YEAR.SelectedValue = model.PD_YEAR.ToString();
     this.ddlPD_PROJECT_TYPE.SelectedValue = model.PD_PROJECT_TYPE;
     this.ddlPD_FOUND_XZ.SelectedValue = model.PD_FOUND_XZ;
     this.ddlPD_PROJECT_COUNTRY.Text = model.PD_PROJECT_COUNTRY;
     this.ddlPD_PROJECT_VILLAGE.Value = model.PD_PROJECT_VILLAGE;
     this.ddlPD_PROJECT_GROUP.Value = model.PD_PROJECT_GROUP;
     this.txtPD_PROJECT_CONTENT.Text = model.PD_PROJECT_CONTENT;
     this.txtPD_PROJECT_XMYT.Text = model.PD_PROJECT_XMYT;
     this.ddlPD_PROJECT_IFXZGL.SelectedValue = model.PD_PROJECT_IFXZGL.ToString();
     this.ddlPD_PROJECT_IFGS.SelectedValue = model.PD_PROJECT_IFGS.ToString();
     this.ddlPD_PROJECT_IFGS_BEFORE.SelectedValue = model.PD_PROJECT_IFGS_BEFORE.ToString();
     this.txtPD_PROJECT_OPEN_BODY.Text = model.PD_PROJECT_OPEN_BODY;
     this.txtPD_PROJECT_FZR.Text = model.PD_PROJECT_FZR;
     this.txtPD_PROJECT_CWFZR.Text = model.PD_PROJECT_CWFZR;
     this.txtPD_PROJECT_SYRS.Text = model.PD_PROJECT_SYRS.ToString();
     this.ddlPD_PROJECT_STATUS.SelectedValue = model.PD_PROJECT_STATUS;
     this.txtPD_PROJECT_BEGIN_DATE.Text = model.PD_PROJECT_BEGIN_DATE.ToString();
     this.txtPD_PROJECT_END_DATE.Text = model.PD_PROJECT_END_DATE.ToString();
     this.txtPD_PROJECT_YEARS.Text = model.PD_PROJECT_YEARS.ToString();
     this.txtPD_PROJECT_FILENO_LX.Text = model.PD_PROJECT_FILENO_LX;
     this.ShowPD_PROJECT_INPUT_COMPANY.Text = model.ShowPD_PROJECT_INPUT_COMPANY;
     this.ShowPD_PROJECT_INPUT_MAN.Text = model.ShowPD_PROJECT_INPUT_MAN;
     this.txtPD_PROJECT_INPUT_COMPANY.Text = model.PD_PROJECT_INPUT_COMPANY;
     this.txtPD_PROJECT_INPUT_MAN.Text = model.PD_PROJECT_INPUT_MAN;
     this.txtPD_PROJECT_INPUT_DATE.Text = model.PD_PROJECT_INPUT_DATE;
     this.ddlPD_PROJECT_COUNTRY.Text = model.PD_PROJECT_COUNTRY;
     this.txtPD_PROJECT_MONEY_TOTAL.Text = model.PD_PROJECT_MONEY_TOTAL.ToString();
     this.txtPD_PROJECT_MONEY_CZ_TOTAL.Text = model.PD_PROJECT_MONEY_CZ_TOTAL.ToString();
     this.txtPD_PROJECT_MONEY_CZ_SJ.Value = model.PD_PROJECT_MONEY_CZ_SJ.ToString();
     this.txtPD_PROJECT_MONEY_CZ_BJ.Value = model.PD_PROJECT_MONEY_CZ_BJ.ToString();
     this.txtPD_PROJECT_MONEY_ZC.Value = model.PD_PROJECT_MONEY_ZC.ToString();
     this.txtPD_PROJECT_MONEY_QT.Value = model.PD_PROJECT_MONEY_QT.ToString();
     this.lblPD_PROJECT_FILENO_PF.Value = model.PD_PROJECT_FILENO_PF;
     this.txtPD_PROJECT_FILENO_PF.Value = model.PD_PROJECT_FILENO_PF_CODE;
     this.txtPD_PROJECT_SSFW.Text = model.PD_PROJECT_SSFW;
     this.HdFree1.Value = model.Free1;
     this.pd_project_cm.Text = model.Free2;
     this.FREE8.Text = model.Free8.ToString();
     decimal num = new PD_FOUND_OUT_Bll().getLJMoney(model.PD_PROJECT_CODE, -1L);
     if (model.Free8 != 0M)
     {
         this.pd_project_jsje.Text = (((num / model.Free8) * 100M)).ToString("0.00") + "%";
     }
     else
     {
         this.pd_project_jsje.Text = "0%";
     }
     PD_PROJECT_ZTB_Model modelPROJECT = new PD_PROJECT_ZTB_Bll().GetModelPROJECT(PD_PROJECT_CODE);
     if (modelPROJECT != null)
     {
         this.ddlPD_PROJECT_ZTB_IF_SSFA.SelectedValue = modelPROJECT.PD_PROJECT_ZTB_IF_SSFA.ToString();//黄文华加tostring()
         this.ddlPD_PROJECT_ZTB_IF_ZTB.SelectedValue = modelPROJECT.PD_PROJECT_ZTB_IF_ZTB.ToString();//黄文华加tostring()
         this.ddlPD_PROJECT_ZTB_STYLE.SelectedValue = modelPROJECT.PD_PROJECT_ZTB_STYLE;
         this.ddlPD_PROJECT_ISCONTRACT.SelectedValue = modelPROJECT.PD_PROJECT_ISCONTRACT;
         this.txtPD_PROJECT_XXJD.Text = modelPROJECT.PD_PROJECT_XXJD;
         this.txtPD_PROJECT_FCXMGCL.Text = modelPROJECT.PD_PROJECT_FCXMGCL;
         this.txtPD_PROJECT_GCZLQK.Text = modelPROJECT.PD_PROJECT_GCZLQK;
     }
     this.BindImg();
     PD_PROJECT_JGYS_Model modelByProCode = new PD_PROJECT_JGYS_Bll().GetModelByProCode(PD_PROJECT_CODE);
     if (modelByProCode != null)
     {
         if (PublicDal.PageValidate.IsDateTime(modelByProCode.PD_PROJECT_COMPLETE_DATE))
         {
             this.txtPD_PROJECT_COMPLETE_DATE.Value = modelByProCode.PD_PROJECT_COMPLETE_DATE.ToString();
         }
         if (PublicDal.PageValidate.IsDateTime(modelByProCode.PD_PROJECT_YSSQ_DATE))
         {
             this.txtPD_PROJECT_YSSQ_DATE.Value = modelByProCode.PD_PROJECT_YSSQ_DATE.Value.ToShortDateString();
         }
         if (PublicDal.PageValidate.IsDateTime(modelByProCode.PD_PROJECT_YS_DATE))
         {
             this.txtPD_PROJECT_YS_DATE.Value = modelByProCode.PD_PROJECT_YS_DATE.Value.ToShortDateString();
         }
         this.ddlPD_PROJECT_YS_COMPANY.SelectedValue = modelByProCode.PD_PROJECT_YS_COMPANY;
         this.txtPD_PROJECT_YS_ZRR.Text = modelByProCode.PD_PROJECT_YS_ZRR;
         this.txtPD_PROJECT_YS_NAME.Text = modelByProCode.PD_PROJECT_YS_NAME;
         this.txtPD_PROJECT_YS_SUGGEST.Text = modelByProCode.PD_PROJECT_YS_SUGGEST;
         this.ddlPD_PROJECT_YS_RESULT.SelectedValue = modelByProCode.PD_PROJECT_YS_RESULT;
         this.txtPD_PROJECT_YS_CONDITION.Text = modelByProCode.PD_PROJECT_YS_CONDITION;
     }
     PD_PROJECT_APPRAISE_Model modelByProjectCode = new PD_PROJECT_APPRAISE_Bll().GetModelByProjectCode(PD_PROJECT_CODE);
     if (modelByProjectCode != null)
     {
         this.txtAUTO_NO_APPRAISE.Text = modelByProjectCode.AUTO_NO.ToString();
         if (PublicDal.PageValidate.IsDateTime(modelByProjectCode.PD_PROJECT_APP_DATE))
         {
             this.txtPD_PROJECT_APP_DATE.Value = modelByProjectCode.PD_PROJECT_APP_DATE.Value.ToShortDateString();
         }
         this.txtPD_PROJECT_APP_COMPANY.Text = modelByProjectCode.PD_PROJECT_APP_COMPANY;
         this.txtPD_PROJECT_APP_COMPANY_LIST.Text = modelByProjectCode.PD_PROJECT_APP_COMPANY_LIST;
         this.txtPD_PROJECT_APP_MAN_LIST.Text = modelByProjectCode.PD_PROJECT_APP_MAN_LIST;
         this.txtPD_PROJECT_APPRAISE_FILENO.Text = modelByProjectCode.PD_PROJECT_APPRAISE_FILENO.ToString();
     }
     if (this.ddlPD_PROJECT_STATUS.SelectedValue.Trim() == "05")
     {
         DataSet ds = DbHelperOra.Query("select * from  view_pd_project_gkgs where PD_Project_Code = '" + PD_PROJECT_CODE + "'  order by pd_project_code,auto_no desc ");
         if ((ds != null) && (ds.Tables[0].Rows.Count > 0))
         {
             this.gvResult_gkgs.DataSource = ds.Tables[0];
             this.gvResult_gkgs.DataBind();
         }
         else
         {
             DataTable table = new DataTable();
             table = ds.Tables[0];
             DataRow row = table.NewRow();
             table.Rows.Add(row);
             this.gvResult_gkgs.DataSource = table.DefaultView;
             this.gvResult_gkgs.DataBind();
         }
         ds = DbHelperOra.Query("select * from view_inspection_list where PD_Project_Code = '" + PD_PROJECT_CODE + "' order by pd_project_code,auto_no desc ");
         if ((ds != null) && (ds.Tables[0].Rows.Count > 0))
         {
             DataView defaultView = ds.Tables[0].DefaultView;
             if ((this.ViewState["SortOrder"] != null) && (this.ViewState["OrderDire"] != null))
             {
                 string str2 = ((string)this.ViewState["SortOrder"]) + " " + ((string)this.ViewState["OrderDire"]);
                 defaultView.Sort = str2;
             }
             this.gvResult_xmxc.DataSource = defaultView;
             this.gvResult_xmxc.DataBind();
         }
         else
         {
             DataTable table2 = new DataTable();
             table2 = ds.Tables[0];
             DataRow row2 = table2.NewRow();
             table2.Rows.Add(row2);
             this.gvResult_xmxc.DataSource = table2.DefaultView;
             this.gvResult_xmxc.DataBind();
         }
         ds = DbHelperOra.Query("select * from view_contract_change_list where pd_project_code='" + PD_PROJECT_CODE + "' order by auto_no  ");
         if ((ds != null) && (ds.Tables[0].Rows.Count > 0))
         {
             this.gvResult_HeTong.DataSource = ds;
             this.gvResult_HeTong.DataBind();
         }
         else
         {
             DataTable table3 = new DataTable();
             table3 = ds.Tables[0];
             DataRow row3 = table3.NewRow();
             table3.Rows.Add(row3);
             this.gvResult_HeTong.DataSource = table3.DefaultView;
             this.gvResult_HeTong.DataBind();
         }
         ds = DbHelperOra.Query("select * from v_pd_found_out_xmlist where pd_project_code='" + PD_PROJECT_CODE + "' order by auto_no  ");
         if (this.gvResult_zjbf.Columns.Count == 0)
         {
             PublicDal.setGViewColumns(ds, this.gvResult_zjbf);
         }
         if ((ds != null) && (ds.Tables[0].Rows.Count > 0))
         {
             this.gvResult_zjbf.DataSource = ds;
             this.gvResult_zjbf.DataBind();
         }
         else
         {
             DataTable table4 = new DataTable();
             table4 = ds.Tables[0];
             DataRow row4 = table4.NewRow();
             table4.Rows.Add(row4);
             this.gvResult_zjbf.DataSource = table4.DefaultView;
             this.gvResult_zjbf.DataBind();
         }
     }
     else
     {
         this.RemoveTab();
     }
 }