protected void btnAdd_Click(object sender, EventArgs e) { PTMultiClasses data = this.GetData(); if (this.OperateType == "add") { int num = this.mcAction.Add(data); if (num > 0) { this.JS.Text = "returnValue=true;window.close();"; } else { this.JS.Text = "没有相关数据可添加!"; } } if (this.OperateType == "upd") { int num = this.mcAction.Update(data); if (num > 0) { this.JS.Text = "returnValue=true;window.close();"; return; } this.JS.Text = "没有相关数据可更新!"; } }
public PTMultiClasses GetModel(string ClassCode) { StringBuilder builder = new StringBuilder(); builder.Append("select * "); builder.Append(" ClassID,ClassTypeCode,CorpCode,ClassCode,ParentClassCode,ClassName,Remark,IsValid "); builder.Append(" from PT_MultiClasses "); builder.Append(" where ClassCode='" + ClassCode + "'"); PTMultiClasses classes = new PTMultiClasses(); DataSet set = publicDbOpClass.DataSetQuary(builder.ToString()); if (set.Tables[0].Rows.Count <= 0) { return(null); } if (set.Tables[0].Rows[0]["ClassID"].ToString() != "") { classes.ClassID = int.Parse(set.Tables[0].Rows[0]["ClassID"].ToString()); } classes.ClassTypeCode = set.Tables[0].Rows[0]["ClassTypeCode"].ToString(); classes.CorpCode = set.Tables[0].Rows[0]["CorpCode"].ToString(); classes.ClassCode = set.Tables[0].Rows[0]["ClassCode"].ToString(); classes.ParentClassCode = set.Tables[0].Rows[0]["ParentClassCode"].ToString(); classes.ClassName = set.Tables[0].Rows[0]["ClassName"].ToString(); classes.Remark = set.Tables[0].Rows[0]["Remark"].ToString(); classes.IsValid = set.Tables[0].Rows[0]["IsValid"].ToString(); return(classes); }
public int Update(PTMultiClasses model) { StringBuilder builder = new StringBuilder(); builder.Append("update PT_MultiClasses set "); builder.Append("ClassName='" + model.ClassName + "',"); builder.Append("Remark='" + model.Remark + "'"); builder.Append("where ClassCode='" + model.ClassCode + "'"); builder.Append("and ClassTypeCode='" + model.ClassTypeCode + "'"); return(publicDbOpClass.ExecSqlString(builder.ToString())); }
public int Add(PTMultiClasses model) { StringBuilder builder = new StringBuilder(); builder.Append("insert into PT_MultiClasses("); builder.Append("ClassTypeCode,CorpCode,ClassCode,ParentClassCode,ClassName,Remark,IsValid"); builder.Append(")"); builder.Append(" values ("); builder.Append("'" + model.ClassTypeCode + "',"); builder.Append("'" + model.CorpCode + "',"); builder.Append("'" + this.GetNewClassCode(model) + "',"); builder.Append("'" + model.ClassCode + "',"); builder.Append("'" + model.ClassName + "',"); builder.Append("'" + model.Remark + "',"); builder.Append("'" + model.IsValid + "'"); builder.Append(")"); return(publicDbOpClass.ExecSqlString(builder.ToString())); }
private PTMultiClasses GetData() { PTMultiClasses pTMultiClasses = new PTMultiClasses(); pTMultiClasses.ClassTypeCode = this.ClassTypeCode; pTMultiClasses.ClassCode = this.ClassCode; pTMultiClasses.ParentClassCode = ""; pTMultiClasses.ClassName = this.txtClassName.Text.Trim(); pTMultiClasses.Remark = this.txtRemark.Text.Trim(); pTMultiClasses.IsValid = "1"; string corpCode = "%"; DataTable dataTable = DocumentAction.QueryCorpCode(this.Session["yhdm"].ToString()); if (dataTable.Rows.Count > 0) { corpCode = dataTable.Rows[0]["corpCode"].ToString(); } pTMultiClasses.CorpCode = corpCode; return(pTMultiClasses); }
private string GetNewClassCode(PTMultiClasses model) { string str = ""; StringBuilder builder = new StringBuilder(); builder.Append(" select max(ClassCode) from PT_MultiClasses "); builder.Append(" where "); builder.Append(" ClassTypeCode='" + model.ClassTypeCode + "' "); builder.Append(" and "); builder.Append(" ParentClassCode='" + model.ClassCode + "' "); object obj2 = publicDbOpClass.ExecuteScalar(builder.ToString()); if (obj2 != DBNull.Value) { str = Convert.ToString((int)(int.Parse((string)obj2) + 1)); while (str.Length < ((string)obj2).Length) { str = "0" + str; } return(str); } return(model.ClassCode + "001"); }