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