private void initinfo(string strID) { pd_kidclass_main ul = new pd_kidclass_main(); System.Data.DataTable dt = ul.getEditdata(strID); if (dt != null && dt.Rows.Count > 0) { DataRow r = dt.Rows[0]; editID.Text = strID; editmainname.Text = r["mainname"].ToString().Trim(); editorder.Text = r["orderint"].ToString().Trim(); editcode.Text = r["maincode"].ToString().Trim(); } else { pd_kidclass_secondary ul1 = new pd_kidclass_secondary(); DataTable dt1 = ul1.getEditdata(strID); DataRow r = dt1.Rows[0]; editID.Text = strID; editmainname.Text = r["classname"].ToString().Trim(); editorder.Text = r["orderint"].ToString().Trim(); editcode.Text = r["darycode"].ToString().Trim(); } }
private void displaydetailinfo(string NodeID) { pd_kidclass_main um = new pd_kidclass_main(); System.Data.DataTable dt = um.getEditdata(NodeID); string strhtml = "空白详细信息"; firsttree.UncheckAllNodes(); if (dt != null && dt.Rows.Count > 0) { strhtml = "<div style=\"line-height:27px;\">"; foreach (System.Data.DataRow r in dt.Rows) { strhtml += "类别名:" + r["mainname"] + "<br/>序号:" + r["orderint"].ToString().Trim() + "<br/>编码:" + r["maincode"].ToString().Trim() + "<br/>创建时间:" + r["adddate"].ToString().Trim() + ""; pd_kidclass_mainmpic mainpic = new pd_kidclass_mainmpic(); DataTable picdt = mainpic.getEditdata(r["ID"].ToString()); if (picdt != null && picdt.Rows.Count > 0) { strhtml += "<br/>主类别特性指标:"; foreach (DataRow r1 in picdt.Rows) { strhtml += r1["mpci"] + ","; } } } strhtml += "</div>"; } else { pd_kidclass_secondary second = new pd_kidclass_secondary(); System.Data.DataTable dt1 = second.getEditdata(NodeID); if (dt1 != null && dt1.Rows.Count > 0) { strhtml = "<div style=\"line-height:27px;\">"; foreach (System.Data.DataRow r in dt1.Rows) { strhtml += "类别名:" + r["classname"] + "<br/>序号:" + r["orderint"].ToString().Trim() + "<br/>编码:" + r["darycode"].ToString().Trim() + "<br/>创建时间:" + r["adddate"].ToString().Trim() + ""; pd_kidclass_secondrec mainpic = new pd_kidclass_secondrec(); DataTable picdt = mainpic.getEditdata(r["ID"].ToString()); if (picdt != null && picdt.Rows.Count > 0) { strhtml += "<br/>特性指标:"; foreach (DataRow r1 in picdt.Rows) { strhtml += r1["mpci"] + ","; } } } strhtml += "</div>"; } } detailinfo.Text = strhtml; }
protected void btnMpci_Click(object sender, EventArgs e) { FineUIPro.TreeNode treenode = firsttree.SelectedNode; editclassID.Text = treenode.NodeID; pd_kidclass_main ul = new pd_kidclass_main(); DataTable dt = ul.getEditdata(treenode.NodeID); if (dt != null && dt.Rows.Count > 0) { mainmpicWindow.Hidden = false; mainmpicweditID.Text = treenode.NodeID; setPageContent(1); } else { secondrecWin.Hidden = false; secondrecWineditID.Text = treenode.NodeID; setPageContent1(1); } }
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(); }