//CAD图纸
protected void filemxcad_FileSelected(object sender, EventArgs e)
{
FineUIPro.TreeNode treenode = firsttree.SelectedNode;
if (treenode != null && treenode.Attributes["nodemenu"].ToString().Trim() == "2")
{
pd_machinekit pm = new pd_machinekit();
string strpid = treenode.NodeID.ToString().Trim();
if (pm.isExistdata("pd_machinekit", "ID", strpid, "ID").Trim() == "")
{
Alert.Show("请先保存零件基本信息");
return;
}
try
{
if (filemxcad.HasFile)
{
string fileName = filemxcad.ShortFileName;
if (!commonLib.ValidateCADType(fileName))
{
Alert.Show("无效的文件类型！");
return;
}
fileName = fileName.Replace(":", "_").Replace(" ", "_").Replace("\\", "_").Replace("/", "_");
int lastDotIndex = fileName.LastIndexOf(".");
string strfiletype = fileName.Substring(lastDotIndex + 1).ToLower();
string strpname = fileName.Substring(0, lastDotIndex);
fileName = DateTime.Now.Ticks.ToString() + fileName.Substring(lastDotIndex).Trim();
filemxcad.SaveAs(Server.MapPath("~/resources/cad/" + fileName));
// 清空文件上传组件
filemxcad.Reset();
Dictionary <string, string> dic = initCADdic(strpid, strpname, fileName, strfiletype);
try
{
pd_cad pc = new pd_cad();
string strfilename = pc.isExistdata("pd_cad", "pid", strpid, "filename");
if (strfilename.Trim() != "")
{
strfilename = Server.MapPath("~/resources/cad/") + strfilename;
if (File.Exists(strfilename))
{
File.Delete(strfilename);
}
pc.update(dic, "pd_cad", "pid", strpid);
}
else
{
dic.Add("ID", Guid.NewGuid().ToString());
dic.Add("pid", strpid);
pc.add(dic, "pd_cad");
}
PageContext.RegisterStartupScript("openwebcad('http://" + Request.Url.Authority.Trim() + "/resources/cad/" + fileName + "')");
}
catch
{
}
}
}
catch
{
}
}
}
//图片
protected void filePhoto_FileSelected(object sender, EventArgs e)
{
FineUIPro.TreeNode treenode = firsttree.SelectedNode;
if (treenode != null && treenode.Attributes["nodemenu"].ToString().Trim() == "2")
{
pd_machinekit pm = new pd_machinekit();
string strpid = treenode.NodeID.ToString().Trim();
if (pm.isExistdata("pd_machinekit", "ID", strpid, "ID").Trim() == "")
{
Alert.Show("请先保存零件基本信息");
return;
}
try
{
if (filePhoto.HasFile)
{
string fileName = filePhoto.ShortFileName;
if (!commonLib.ValidateImgType(fileName))
{
Alert.Show("无效的文件类型！");
return;
}
fileName = fileName.Replace(":", "_").Replace(" ", "_").Replace("\\", "_").Replace("/", "_");
int lastDotIndex = fileName.LastIndexOf(".");
string strfiletype = fileName.Substring(lastDotIndex + 1).ToLower();
string strpname = fileName.Substring(0, lastDotIndex);
fileName = DateTime.Now.Ticks.ToString() + fileName.Substring(lastDotIndex).Trim();
filePhoto.SaveAs(Server.MapPath("~/resources/photo/" + fileName));
imgPhoto.ImageUrl = "~/resources/photo/" + fileName;
// 清空文件上传组件
filePhoto.Reset();
Dictionary <string, string> dic = initPhotodic(strpid, strpname, fileName, strfiletype);
try
{
pd_photo pp = new pd_photo();
string strfilename = pp.isExistdata("pd_photo", "pid", strpid, "filename");
if (strfilename.Trim() != "")
{
strfilename = Server.MapPath("~/resources/photo/") + strfilename;
if (File.Exists(strfilename))
{
File.Delete(strfilename);
}
pp.update(dic, "pd_photo", "pid", strpid);
}
else
{
dic.Add("ID", Guid.NewGuid().ToString());
dic.Add("pid", strpid);
pp.add(dic, "pd_photo");
}
}
catch
{
}
}
}
catch
{
}
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
FineUIPro.TreeNode treenode = firsttree.SelectedNode;
if (treenode != null && treenode.Attributes["nodemenu"].ToString().Trim() == "2")
{
string strID = treenode.NodeID.ToString().Trim();
string strmtypeid = treenode.ParentNode.NodeID.Trim();
Dictionary <string, string> dic = initDatadic();
dic.Add("mtypeid", strmtypeid);
pd_machinekit pm = new pd_machinekit();
int intresult = 0;
if (pm.isExistdata("pd_machinekit", "ID", strID, "ID").Trim() == "")
{
if (pm.isExistdata("mname", dic["mname"].ToString().Trim(), strID, false).Trim() == "" &&
pm.isExistdata("mcode", dic["mcode"].ToString().Trim(), strID, false).Trim() == "")
{
dic.Add("ID", strID);
intresult = pm.add(dic, "pd_machinekit");
}
else
{
Alert.Show("零件名称或零件编码已经存在");
return;
}
}
else
{
if (pm.isExistdata("mname", dic["mname"].ToString().Trim(), strID, true).Trim() == "" &&
pm.isExistdata("mcode", dic["mcode"].ToString().Trim(), strID, true).Trim() == "")
{
pd_compongall_compose pcc = new pd_compongall_compose();
pd_product_compose ppc = new pd_product_compose();
if (pcc.isExistdata("pd_compongall_compose", "ID", strID, "ID").Trim() != "" &&
ppc.isExistdata("pd_product_compose", "ID", strID, "ID").Trim() != "")
{
Alert.Show("当前零件不能修改名称编码");
return;
}
intresult = pm.update(dic, "pd_machinekit", "cast(ID as varchar(36))", strID);
}
else
{
Alert.Show("零件名称或零件编码已经存在");
return;
}
}
inittree();
Alert alert = new Alert();
if (intresult == 1)
{
alert.Icon = Icon.Information;
alert.Message = "数据保存成功";
}
else
{
alert.MessageBoxIcon = MessageBoxIcon.Error;
alert.Message = "数据保存失败";
}
alert.Show();
}
}
