protected void Btn_Save_Click(object sender, EventArgs e) { KnowledgeDataModel kdm = new KnowledgeDataModel(); kdm = this.GetValueFromText(); if (base.Request.QueryString["optype"] == "ADD") { if (KnowledgeDataAction.AddNewData(kdm) != 1) { this.js.Text = "alert('增加失败!');"; return; } this.js.Text = "alert('增加成功!');window.returnValue=true;window.close();"; return; } else { if (KnowledgeDataAction.UpdateData(kdm) != 1) { this.js.Text = "alert('修改失败!');"; return; } this.js.Text = "alert('修改成功!');window.returnValue=true;window.close();"; return; } }
private KnowledgeDataModel GetValueFromText() { KnowledgeDataModel knowledgeDataModel = new KnowledgeDataModel(); this.DI = (DatumInfo)this.MPTabDatum.FindControl("DatumInfo"); knowledgeDataModel.KnowledgeCode = new Guid(this.Session["DATUMCODE"].ToString()); knowledgeDataModel.ProjectCode = new Guid(base.Request.QueryString["PrjCode"].ToString()); knowledgeDataModel.AuditingDate = DateTime.Now; knowledgeDataModel.AddDate = DateTime.Now; knowledgeDataModel.UpdateDate = DateTime.Now; knowledgeDataModel.IsAuditing = "1"; knowledgeDataModel.Viscera = this.DI.Viscera; knowledgeDataModel.TypeId = Convert.ToInt32(this.DI.ddlClass); if (this.DI.boolVisable) { knowledgeDataModel.IsValid = "1"; } else { knowledgeDataModel.IsValid = "0"; } knowledgeDataModel.DatumName = this.DI.txtTitle; knowledgeDataModel.Author = this.Session["yhdm"].ToString(); return(knowledgeDataModel); }
public static int UpdateData(KnowledgeDataModel kdm) { object obj2 = " update EPM_Datum_Data set DatumName = '" + kdm.DatumName + "',Author = '" + kdm.Author + "',"; object obj3 = string.Concat(new object[] { obj2, " Viscera = '", kdm.Viscera, "',UpdateDate = '", kdm.UpdateDate, "',IsValid = '", kdm.IsValid, "'," }) + "TypeId = " + kdm.TypeId; return(publicDbOpClass.ExecSqlString(string.Concat(new object[] { obj3, " where KnowledgeCode = '", kdm.KnowledgeCode, "' " }))); }
public static int AddNewData(KnowledgeDataModel kdm) { object obj2 = " insert into EPM_Datum_Data (KnowledgeCode,DatumName,Author,Viscera,AddDate,UpdateDate,AuditingDate,IsValid,IsAuditing,TypeId,ProjectCode) values ('" + kdm.KnowledgeCode + "', "; object obj3 = string.Concat(new object[] { obj2, " '", kdm.DatumName, "','", kdm.Author, "','", kdm.Viscera, "','", kdm.AddDate, "', " }); object obj4 = string.Concat(new object[] { obj3, " '", kdm.UpdateDate, "','", kdm.AuditingDate, "','", kdm.IsValid, "'," }); return(publicDbOpClass.ExecSqlString(string.Concat(new object[] { obj4, " '", kdm.IsAuditing, "','", kdm.TypeId, "','", kdm.ProjectCode, "')" }))); }
private void GetValueFromTable() { KnowledgeDataModel knowledgeDataModel = new KnowledgeDataModel(); knowledgeDataModel = KnowledgeDataAction.GetSingleValue(new Guid(this.Session["DATUMCODE"].ToString())); this.DI = (DatumInfo)this.MPTabDatum.FindControl("DatumInfo"); this.DI.Viscera = knowledgeDataModel.Viscera; this.DI.boolVisable = Convert.ToBoolean(knowledgeDataModel.IsValid); this.DI.boolVisable1 = !Convert.ToBoolean(knowledgeDataModel.IsValid); this.DI.txtTitle = knowledgeDataModel.DatumName; this.DI.V_xm = com.jwsoft.pm.entpm.PageHelper.QueryUser(this, knowledgeDataModel.Author.Trim()); this.DI.ddlClass = knowledgeDataModel.TypeId.ToString(); }
protected void Page_Load(object sender, EventArgs e) { if (!base.IsPostBack) { if (base.Request["DatumCode"] == null) { this.JS.Text = "alert('参数错误!');window.close();"; return; } this.dc = base.Request["DatumCode"].ToString(); KnowledgeDataModel singleValue = KnowledgeDataAction.GetSingleValue(new Guid(this.dc)); this.CalDate.Text = singleValue.AffirmDateTime.ToShortDateString(); this.TxtRemark.Text = singleValue.AffirmInfo.ToString(); } }