private void bind(string pk)
{
CheckClassInfo checkClassInfo = CheckClassAction.GetCheckClassInfo(pk);
this.TextBox_name.Text = checkClassInfo.ItemInspectSortName;
this.TextBox_remark.Text = checkClassInfo.Remark;
}
protected void Button_save_Click(object sender, EventArgs e)
{
if (this.TextBox_remark.Text.Trim().Length > 150)
{
return;
}
if (string.IsNullOrEmpty(this.TextBox_name.Text.Trim()))
{
this.TextBox_name.Focus();
this.JavaScriptControl1.Text = "alert('系统提示：\\n检查类别名称不能为空!')";
return;
}
CheckClassInfo checkClassInfo = new CheckClassInfo();
if (base.Request["pk"] != null)
{
checkClassInfo.SortID = int.Parse(base.Request["pk"].ToString());
}
checkClassInfo.ItemInspectSortName = this.TextBox_name.Text.Trim();
checkClassInfo.Remark = this.TextBox_remark.Text.Trim();
bool flag = this.IsExistItemInspectSortName(checkClassInfo.ItemInspectSortName);
bool flag2;
if (string.IsNullOrEmpty(base.Request["pk"]))
{
if (flag)
{
this.TextBox_name.Focus();
this.JavaScriptControl1.Text = "top.ui.alert('n检查类别名已经存在，请重新输入!')";
return;
}
flag2 = CheckClassAction.CheckClassInfoOp(checkClassInfo, "Insert");
}
else
{
if (flag)
{
CheckClassInfo checkClassInfo2 = CheckClassAction.GetCheckClassInfo(base.Request["pk"]);
if (!checkClassInfo2.ItemInspectSortName.Equals(checkClassInfo.ItemInspectSortName))
{
base.RegisterScript("top.ui.alert('检查类别名已经存在，请重新输入!')");
return;
}
}
flag2 = CheckClassAction.CheckClassInfoOp(checkClassInfo, "Update");
}
if (flag2)
{
base.RegisterScript("top.ui.tabSuccess({ parentName: '_checkclasslist' });");
return;
}
base.RegisterScript("top.ui.alert('保存失败')");
}
public static CheckClassInfo GetCheckClassInfo(string SortID)
{
CheckClassInfo info = new CheckClassInfo();
DataTable table = publicDbOpClass.DataTableQuary("select * from Prj_ItemInspectSort where SortID=" + SortID);
if (table.Rows[0]["SortID"].ToString() != "")
{
info.SortID = int.Parse(table.Rows[0]["SortID"].ToString());
}
info.ItemInspectSortName = table.Rows[0]["ItemInspectSortName"].ToString();
info.Remark = table.Rows[0]["Remark"].ToString();
return(info);
}
public static bool CheckClassInfoOp(CheckClassInfo objinfo, string OpType)
{
string sqlString = "";
if (OpType == "Insert")
{
sqlString = "Insert into Prj_ItemInspectSort(ItemInspectSortName,Remark) values('" + objinfo.ItemInspectSortName + "','" + objinfo.Remark + "')";
}
else if (OpType == "Update")
{
sqlString = string.Concat(new object[] { "update Prj_ItemInspectSort set ItemInspectSortName='", objinfo.ItemInspectSortName, "',Remark='", objinfo.Remark, "' where SortID='", objinfo.SortID, "'" });
}
return(publicDbOpClass.NonQuerySqlString(sqlString));
}
