protected void btnSave_Click(object sender, EventArgs e)
{
string strID = editID.Text.ToString().Trim();
int intresult = 0;
if (strID == "systemmenu")
{
Dictionary <string, string> dic = initDatadicmain(mainname.Text.Trim(), orderint.Text.Trim(), code.Text.Trim());
pd_kidclass_main ul = new pd_kidclass_main();
dic.Add("ID", Guid.NewGuid().ToString());
string strmainname = dic["mainname"].ToString().Trim();
string strmaincode = dic["maincode"].ToString().Trim();
if (ul.isExistdata("pd_kidclass_main", "mainname", strmainname, "mainname").Trim() != "")
{
Alert.Show(strmainname + " 类别名称已经存在!");
return;
}
else if (ul.isExistdata("pd_kidclass_main", "maincode", strmaincode, "maincode").Trim() != "")
{
Alert.Show(strmaincode + " 编码已经存在!");
return;
}
else
{
intresult = ul.add(dic, "pd_kidclass_main");
string strmpic = mpci.Text.Trim();
if (strmpic != null && strmpic != "")
{
foreach (var str in strmpic.Split(','))
{
Dictionary <string, string> dic1 = initDatadicmainmpic(str, dic["ID"].ToString().Trim(), "");
dic1.Add("ID", Guid.NewGuid().ToString());
ul.add(dic1, "pd_kidclass_mainmpic");
}
}
}
}
else
{
Dictionary <string, string> dic = initDatadicsecond(mainname.Text.Trim(), strID, orderint.Text.Trim(), code.Text.Trim());
pd_kidclass_secondary ul = new pd_kidclass_secondary();
dic.Add("ID", Guid.NewGuid().ToString());
string strmainname = dic["classname"].ToString().Trim();
string strdarycode = dic["darycode"].ToString().Trim();
DataTable dt = ul.getEditdatabyID(strID, strmainname);
if (dt != null && dt.Rows.Count > 0)
{
Alert.Show(strmainname + " 类别名称已经存在!");
return;
}
else if (ul.isExistdata("pd_kidclass_secondary", "darycode", strdarycode, "darycode").Trim() != "")
{
Alert.Show(strdarycode + " 编码已经存在!");
return;
}
else
{
intresult = ul.add(dic, "pd_kidclass_secondary");
if (dartmpci.SelectedValueArray.Length > 0)
{
string select = String.Join(", ", dartmpci.SelectedValueArray);
pd_kidclass_secondrec secrec = new pd_kidclass_secondrec();
pd_kidclass_mainmpic pic = new pd_kidclass_mainmpic();
foreach (var sel in select.Split(','))
{
string mpciID = pic.getCodedata(strID, sel.Trim());
Dictionary <string, string> dic1 = initDatadicsesecondrec(dic["ID"], mpciID);
dic1.Add("ID", Guid.NewGuid().ToString());
secrec.add(dic1, "pd_kidclass_secondrec");
}
}
}
}
Alert alert = new Alert();
if (intresult == 1)
{
alert.Icon = Icon.Information;
alert.Message = "数据保存成功";
PageContext.RegisterStartupScript("preview();");
}
alert.Show();
}
protected void btnSave1_Click(object sender, EventArgs e)
{
Alert alert = new Alert();
string strID = editclassID.Text.ToString().Trim();
pd_kidclass_main ul = new pd_kidclass_main();
int intresult = 0;
if (ul.isExistdata("pd_kidclass_main", "ID", strID, "ID").Trim() != "")
{
DataTable dt = ul.getEditdata(strID, editmainname.Text.Trim());
if (dt != null && dt.Rows.Count > 0)
{
alert.Icon = Icon.Information;
alert.Message = "名称已存在";
return;
}
else if (ul.isExistdata("pd_kidclass_main", "maincode", editcode.Text.Trim(), "maincode").Trim() != "")
{
alert.Icon = Icon.Information;
alert.Message = "编码已存在";
return;
}
else
{
Dictionary <string, string> dic = initDatadicmain(editmainname.Text.Trim(), editorder.Text.Trim(), editcode.Text.Trim());
string strmainname = dic["mainname"].ToString().Trim();
intresult = ul.update(dic, "pd_kidclass_main", "ID", strID);
}
}
else
{
pd_kidclass_secondary ul1 = new pd_kidclass_secondary();
DataTable dt = ul1.getEditdatabyname(strID, editmainname.Text.Trim());
if (dt != null && dt.Rows.Count > 0)
{
alert.Icon = Icon.Information;
alert.Message = "名称已存在";
return;
}
else if (ul.isExistdata("pd_kidclass_secondary", "darycode", editcode.Text.Trim(), "darycode").Trim() != "")
{
alert.Icon = Icon.Information;
alert.Message = "编码已存在";
return;
}
else
{
Dictionary <string, string> dic = initDatadicsecondedit(editmainname.Text.Trim(), editorder.Text.Trim(), editcode.Text.Trim());
string strmainname = dic["classname"].ToString().Trim();
intresult = ul.update(dic, "pd_kidclass_secondary", "ID", strID);
}
}
if (intresult == 1)
{
alert.Icon = Icon.Information;
alert.Message = "数据保存成功";
}
alert.Show();
}
protected void btnDelete_Click(object sender, EventArgs e)
{
Alert alert = new Alert();
FineUIPro.TreeNode treenode = firsttree.SelectedNode;
editclassID.Text = treenode.NodeID;
int intresult = 0;
string strID = treenode.NodeID;
Dictionary <string, string> dic = new Dictionary <string, string>();
dic.Add("ID", " cast(ID as varchar(36))='" + strID + "' ");
pd_kidclass_main ul = new pd_kidclass_main();
DataTable dt = ul.getEditdata(strID);
if (dt != null && dt.Rows.Count > 0)
{
intresult = ul.deletebycondition("pd_kidclass_main", dic);
pd_kidclass_mainmpic ulpic = new pd_kidclass_mainmpic();
Dictionary <string, string> dic1 = new Dictionary <string, string>();
dic1.Add("mainID", " cast(mainID as varchar(36))='" + strID + "' ");
ulpic.deletebycondition("pd_kidclass_mainmpic", dic1);
if (intresult > 0)
{
alert.Icon = Icon.Information;
alert.Message = "成功移除数据";
PageContext.RegisterStartupScript("preview();");
}
alert.Show();
}
else
{
if (ul.isExistdata("pd_machinekit", "mtypeid", strID, "mtypeid").Trim() != "")
{
Alert.Show("该类别存在下级零件不能删除!");
return;
}
else
{
pd_kidclass_secondary ul1 = new pd_kidclass_secondary();
intresult = ul1.deletebycondition("pd_kidclass_secondary", dic);
pd_kidclass_secondrec ulpic = new pd_kidclass_secondrec();
Dictionary <string, string> dic1 = new Dictionary <string, string>();
dic1.Add("subID", " cast(subID as varchar(36))='" + strID + "' ");
ulpic.deletebycondition("pd_kidclass_secondrec", dic1);
if (intresult > 0)
{
alert.Icon = Icon.Information;
alert.Message = "成功移除数据";
PageContext.RegisterStartupScript("preview();");
}
alert.Show();
}
}
if (intresult > 0)
{
alert.Icon = Icon.Information;
alert.Message = "成功移除数据";
PageContext.RegisterStartupScript("preview();");
}
alert.Show();
}
