protected void menuDelete_Click(object sender, EventArgs e)
{
FineUIPro.TreeNode treenode = firsttree.SelectedNode;
string strID = treenode.NodeID.Trim();
if (strID != "")
{
cd_thermal ct = new cd_thermal();
string strtid = ct.isExistdata("cd_thermal", "pid", strID, "ID").Trim();
if (strtid != "")
{
List <Dictionary <string, string> > listdic = new List <Dictionary <string, string> >();
List <string> listTablename = new List <string>();
Dictionary <string, string> dic = new Dictionary <string, string>();
dic.Add("cd_thermal", "cast(pid as varchar(36))='" + strID + "' ");
listdic.Add(dic);
listTablename.Add("cd_thermal");
dic = new Dictionary <string, string>();
dic.Add("cd_thermal_batch", "cast(tid as varchar(36))='" + strtid + "' ");
listdic.Add(dic);
listTablename.Add("cd_thermal_batch");
dic = new Dictionary <string, string>();
dic.Add("cd_thermal_indicator", "cast(tid as varchar(36))='" + strtid + "' ");
listdic.Add(dic);
listTablename.Add("cd_thermal_indicator");
dic = new Dictionary <string, string>();
dic.Add("pd_3d", "cast(pid as varchar(36))='" + strtid + "' ");
listdic.Add(dic);
listTablename.Add("pd_3d");
dic = new Dictionary <string, string>();
dic.Add("pd_blueprint", "cast(pid as varchar(36))='" + strtid + "' ");
listdic.Add(dic);
listTablename.Add("pd_blueprint");
dic = new Dictionary <string, string>();
dic.Add("pd_photo", "cast(pid as varchar(36))='" + strtid + "' ");
listdic.Add(dic);
listTablename.Add("pd_photo");
dic = new Dictionary <string, string>();
dic.Add("pd_cad", "cast(pid as varchar(36))='" + strtid + "' ");
listdic.Add(dic);
listTablename.Add("pd_cad");
int intresult = 0;
pd_machinekit pm = new pd_machinekit();
intresult = pm.deleteMutri(listdic, listTablename);
Alert alert = new Alert();
if (intresult > 0)
{
alert.Icon = Icon.Information;
alert.Message = "数据删除成功";
}
else
{
alert.MessageBoxIcon = MessageBoxIcon.Error;
alert.Message = "数据删除失败";
}
alert.Show();
}
}
}
protected void menuDelete_Click(object sender, EventArgs e)
{
FineUIPro.TreeNode treenode = firsttree.SelectedNode;
string strID = treenode.NodeID.Trim();
//需检查零件在组件和产品表中是否存在
//未删除图片图纸
if (strID != "")
{
pd_compongall_compose pcc = new pd_compongall_compose();
pd_product_compose ppc = new pd_product_compose();
if (pcc.isExistdata("pd_compongall_compose", "composeID", strID, "ID").Trim() != "" &&
ppc.isExistdata("pd_product_compose", "ppid", strID, "ID").Trim() != "")
{
Alert.Show("当前零件不能删除");
return;
}
List <Dictionary <string, string> > listdic = new List <Dictionary <string, string> >();
List <string> listTablename = new List <string>();
Dictionary <string, string> dic = new Dictionary <string, string>();
dic.Add("pd_machinekit", "cast(ID as varchar(36))='" + strID + "' ");
listdic.Add(dic);
listTablename.Add("pd_machinekit");
dic = new Dictionary <string, string>();
dic.Add("pd_machinekit_feature", "cast(pid as varchar(36))='" + strID + "' ");
listdic.Add(dic);
listTablename.Add("pd_machinekit_feature");
dic = new Dictionary <string, string>();
dic.Add("pd_3d", "cast(pid as varchar(36))='" + strID + "' ");
listdic.Add(dic);
listTablename.Add("pd_3d");
dic = new Dictionary <string, string>();
dic.Add("pd_blueprint", "cast(pid as varchar(36))='" + strID + "' ");
listdic.Add(dic);
listTablename.Add("pd_blueprint");
dic = new Dictionary <string, string>();
dic.Add("pd_photo", "cast(pid as varchar(36))='" + strID + "' ");
listdic.Add(dic);
listTablename.Add("pd_photo");
dic = new Dictionary <string, string>();
dic.Add("pd_cad", "cast(pid as varchar(36))='" + strID + "' ");
listdic.Add(dic);
listTablename.Add("pd_cad");
int intresult = 0;
pd_machinekit pm = new pd_machinekit();
intresult = pm.deleteMutri(listdic, listTablename);
inittree();
Alert alert = new Alert();
if (intresult > 0)
{
alert.Icon = Icon.Information;
alert.Message = "数据删除成功";
}
else
{
alert.MessageBoxIcon = MessageBoxIcon.Error;
alert.Message = "数据删除失败";
}
alert.Show();
}
}