private void SaveBDData(string PD_PROJECT_CODE) { TB_PROJECT_BZ_Bll bll = new TB_PROJECT_BZ_Bll(); TB_PROJECT_BZ_Model model = bll.GetModel(PD_PROJECT_CODE); model.PD_PROJECT_JGJL = this.jgjlText_H.Value; if (bll.Update(model)) { PageShowText.ShowMessage("保存成功!", this.Page); } else { PageShowText.ShowMessage("保存失败!", this.Page); } }
private void UpdataData(string PD_PROJECT_CODE, string CCXC) { string strErr = ""; if (!this.Panduan(ref strErr)) { this.TabContainer1.ActiveTabIndex = 0; } else { TB_PROJECT_BZ_Bll bll = new TB_PROJECT_BZ_Bll(); TB_PROJECT_BZ_Model model = this.GetModel(bll.GetModel(PD_PROJECT_CODE)); model.PD_PROJECT_CODE = PD_PROJECT_CODE; bll.Update(model); PD_PROJECT_ATTACH_BZ_Bll bll2 = new PD_PROJECT_ATTACH_BZ_Bll(); List<PD_PROJECT_ATTACH_BZ_Model> modelList = this.GetATTACH_BZ_Model(model.PD_PROJECT_CODE); bll2.Delete(model.PD_PROJECT_CODE); bll2.AddList(modelList); PD_PROJECT_INSPECTION_Bll bll3 = new PD_PROJECT_INSPECTION_Bll(); List<PD_PROJECT_INSPECTION_Model> inspectionModel = this.GetInspectionModel(model.PD_PROJECT_CODE); bll3.Delete(model.PD_PROJECT_CODE, " and PD_DB_LOOP=0 "); bll3.AddList(inspectionModel); PageShowText.Refurbish("修改成功", this.Page); } }
protected void ShowData_Input() { string showText = null; try { string s = base.Server.UrlDecode(this.FilePostCtr1.getFileName); string path = null; DataSet set = null; if ((s != null) && (s.Trim() != "")) { set = new DataSet(); XmlTextReader reader = new XmlTextReader(new StringReader(s)); set.ReadXml(reader); path = base.Server.MapPath("~/temp/" + set.Tables[0].Rows[0]["FileSysName"]); } else { showText = "请先选择需要导入的Excel文件"; } if ((set != null) && File.Exists(path)) { DataSet dataSet = ExcelToDataset.GetDataSet(path); showText = new TB_PROJECT_BZ_Bll().InputData(dataSet); if (showText != "") { showText = "以下记录未导入成功:" + showText; } else { showText = "导入成功!"; } File.Delete(path); } else { showText = "请先选择需要导入的Excel文件"; } } catch (Exception exception) { this.el = new ExceptionLog.ExceptionLog(); this.el.ErrClassName = base.GetType().ToString(); this.el.ErrMessage = exception.Message.ToString(); this.el.ErrMethod = "bind()"; this.el.WriteExceptionLog(true); showText = "导入出现异常:" + exception; } this.FilePostCtr1.getFileName = ""; this.JS_BindShow(showText); }
private void ShowInfo(string PD_PROJECT_CODE) { TB_PROJECT_BZ_Model modelName = new TB_PROJECT_BZ_Bll().GetModelName(PD_PROJECT_CODE); this.lblPD_PROJECT_FILENO_ZB.Text = modelName.PD_PROJECT_FILENO_ZB; this.txtPD_PROJECT_FILENO_ZB.Value = modelName.PD_PROJECT_FILENO_ZB_CODE; this.lblPD_PROJECT_CODE.Value = modelName.PD_PROJECT_CODE; this.txtPD_PROJECT_NAME.Text = modelName.PD_PROJECT_NAME; this.ddlPD_YEAR.SelectedValue = modelName.PD_YEAR.ToString(); this.ddlPD_PROJECT_TYPE.SelectedValue = modelName.PD_PROJECT_TYPE; this.ddlPD_GK_DEPART.SelectedValue = modelName.PD_GK_DEPART; this.ddlPD_FOUND_XZ.SelectedValue = modelName.PD_FOUND_XZ; this.ddlPD_PROJECT_IFGS.SelectedValue = modelName.PD_PROJECT_IFGS.ToString(); this.ddlPD_PROJECT_IFGS_BEFORE.SelectedValue = modelName.PD_PROJECT_IFGS_BEFORE.ToString(); this.txtPD_PROJECT_OPEN_BODY.Text = modelName.PD_PROJECT_OPEN_BODY; this.ddlPD_PROJECT_STATUS.SelectedValue = modelName.PD_PROJECT_STATUS; this.txtPD_PROJECT_FILENO_JG.Text = modelName.PD_PROJECT_FILENO_JG; this.txtPD_PROJECT_INPUT_COMPANY.Text = modelName.PD_PROJECT_INPUT_COMPANY; this.txtPD_PROJECT_INPUT_MAN.Text = modelName.PD_PROJECT_INPUT_MAN; this.txtPD_PROJECT_INPUT_DATE.Text = modelName.PD_PROJECT_INPUT_DATE; this.txtPD_PROJECT_BZYJ.Text = modelName.PD_PROJECT_BZYJ; this.txtPD_PROJECT_BZFW.Text = modelName.PD_PROJECT_BZFW; this.txtPD_PROJECT_BZDX.Text = modelName.PD_PROJECT_BZDX; this.txtPD_PROJECT_BZNUM.Text = modelName.PD_PROJECT_BZNUM.ToString(); this.txtPD_PROJECT_BZSTAND_NUM.Text = modelName.PD_PROJECT_BZSTAND_NUM.ToString(); this.txtPD_PROJECT_BZMONEY.Text = Convert.ToDecimal(!modelName.PD_PROJECT_BZMONEY.HasValue ? 0 : modelName.PD_PROJECT_BZMONEY).ToString("F2"); this.txtPD_PROJECT_BZFF_DATE.Text = modelName.PD_PROJECT_BZFF_DATE.ToString(); this.txtPD_PROJECT_SJFF_DATE.Text = modelName.PD_PROJECT_SJFF_DATE.ToString(); this.ddlPD_PROJECT_IFFF.SelectedValue = modelName.PD_PROJECT_IFFF.ToString(); this.txtPD_PROJECT_JGYQ.Text = modelName.PD_PROJECT_JGYQ; this.txtPD_PROJECT_JGJL.Text = modelName.PD_PROJECT_JGJL; this.txtPD_PROJECT_JG_RESULT.Text = modelName.PD_PROJECT_JG_RESULT; }