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");
}
