Esempio n. 1
0
        private void ResolveSubTree(DataRow dataRow, FineUIPro.TreeNode treeNode)
        {
            DataRow[] rows = dataRow.GetChildRows("TreeRelation");
            if (rows.Length > 0)
            {
                // 如果是目录,则默认展开
                treeNode.Expanded = true;
                foreach (DataRow row in rows)
                {
                    FineUIPro.TreeNode node = new FineUIPro.TreeNode();
                    node.NodeID = row["dptId"].ToString();
                    node.Text   = row["dptName"].ToString();

                    node.EnableCheckBox   = true;
                    node.EnableCheckEvent = true;
                    treeNode.Nodes.Add(node);
                    ResolveSubTree(row, node);
                }
            }
        }
Esempio n. 2
0
        protected StringBuilder GetTreeNode(FineUIPro.TreeNode nodes, StringBuilder strTree, bool first)
        {
            if (first)
            {
                strTree.Append(nodes.NodeID.Trim() + ",");
            }
            for (int i = 0; i < nodes.Nodes.Count; i++)
            {
                if (nodes.Nodes[i].Leaf)
                {
                    strTree.Append(nodes.Nodes[i].NodeID.Trim() + ",");
                }
                else
                {
                    GetTreeNode(nodes.Nodes[i], strTree, true);
                }
            }

            return(strTree);
        }
        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);
            }
        }
Esempio n. 4
0
        private void ResolveSubTree(DataRow dataRow, FineUIPro.TreeNode treeNode)
        {
            DataRow[] rows = dataRow.GetChildRows("TreeRelation");
            if (rows.Length > 0)
            {
                // 如果是目录,则默认展开
                treeNode.Expanded = true;
                foreach (DataRow row in rows)
                {
                    FineUIPro.TreeNode node = new FineUIPro.TreeNode();
                    node.Text = row["nodetext"].ToString();
                    string strnodeid = row["nodeid"].ToString();
                    node.NodeID           = strnodeid;
                    node.NavigateUrl      = strnodeid.Replace("_", "/") + ".aspx";
                    node.EnableCheckEvent = true;
                    treeNode.Nodes.Add(node);

                    ResolveSubTree(row, node);
                }
            }
        }
        protected void BindTree()
        {
            TreeDpt.Nodes.Clear();
            BLL.tDepartMent BLL = new BLL.tDepartMent();
            DataSet         ds  = BLL.GetAllList();

            ds.Relations.Add("TreeRelation", ds.Tables[0].Columns["dptId"], ds.Tables[0].Columns["dptFatherId"], false);

            foreach (DataRow row in ds.Tables[0].Rows)
            {
                if (row.IsNull("dptFatherId"))
                {
                    FineUIPro.TreeNode node = new FineUIPro.TreeNode();
                    node.NodeID           = row["dptId"].ToString();
                    node.Text             = row["dptName"].ToString();
                    node.EnableClickEvent = true;
                    TreeDpt.Nodes.Add(node);
                    ResolveSubTree(row, node);
                }
            }
        }
Esempio n. 6
0
        protected void cadLookup_Click(object sender, EventArgs e)
        {
            FineUIPro.TreeNode treenode = firsttree.SelectedNode;

            if (treenode.Attributes["nodemenu"].ToString().Trim() == "2")
            {
                pd_cad pc          = new pd_cad();
                string strfilename = pc.isExistdata("pd_cad", "pid", treenode.NodeID, "filename");

                //GrapkTabStrip.ActiveTabIndex = 2;

                if (strfilename.Trim() != "")
                {
                    PageContext.RegisterStartupScript("openwebcad('http://" + Request.Url.Authority.Trim() + "/resources/cad/" + strfilename + "')");
                }
                else
                {
                    PageContext.RegisterStartupScript("clearcad()");
                }
            }
        }
        private void ResolveSubTree(DataRow dataRow, FineUIPro.TreeNode treeNode)
        {
            string Id = Request.QueryString["Id"];

            DataRow[] rows = dataRow.GetChildRows("TreeRelation");
            if (rows.Length > 0)
            {
                // 如果是目录,则默认展开
                treeNode.Expanded = true;
                foreach (DataRow row in rows)
                {
                    FineUIPro.TreeNode node = new FineUIPro.TreeNode();
                    node.NodeID = row["dptId"].ToString();
                    node.Text   = ("[" + GetIsSave(int.Parse(Id), int.Parse(node.NodeID)) + "]");
                    node.Text  += row["dptName"].ToString();

                    node.EnableClickEvent = true;
                    treeNode.Nodes.Add(node);
                    ResolveSubTree(row, node);
                }
            }
        }
        protected void BindTree()
        {
            TreeDpt.Nodes.Clear();
            BLL.tMenu BLL = new BLL.tMenu();
            DataSet   ds  = BLL.GetAllList();

            ds.Relations.Add("TreeRelation", ds.Tables[0].Columns["mCode"], ds.Tables[0].Columns["mFaherId"], false);

            foreach (DataRow row in ds.Tables[0].Rows)
            {
                if (row.IsNull("mFaherId"))
                {
                    FineUIPro.TreeNode node = new FineUIPro.TreeNode();
                    node.NodeID           = row["mCode"].ToString();
                    node.Text             = row["mName"].ToString();
                    node.Icon             = (Icon)Enum.Parse(typeof(Icon), row["mIcon"].ToString(), true);
                    node.EnableClickEvent = true;
                    TreeDpt.Nodes.Add(node);
                    ResolveSubTree(row, node);
                }
            }
        }
Esempio n. 9
0
        private void inittree()
        {
            // 模拟从数据库返回数据表
            systemMenu sm    = new systemMenu();
            DataTable  table = sm.getBindTreeDataAsdt();

            DataSet ds = new DataSet();

            ds.Tables.Add(table);
            ds.Relations.Add("TreeRelation", ds.Tables[0].Columns["id"], ds.Tables[0].Columns["pid"]);

            foreach (DataRow row in ds.Tables[0].Rows)
            {
                if (row.IsNull("pid"))
                {
                    FineUIPro.TreeNode node = new FineUIPro.TreeNode();
                    node.Text             = row["nodetext"].ToString();
                    node.NodeID           = row["id"].ToString();
                    node.EnableCheckEvent = true;
                    firsttree.Nodes.Add(node);
                    ResolveSubTree(row, node);
                }
            }
        }
Esempio n. 10
0
        private void ResolveSubTree(DataRow dataRow, FineUIPro.TreeNode treeNode)
        {
            DataRow[] rows = dataRow.GetChildRows("TreeRelation");
            if (rows.Length > 0)
            {
                // 如果是目录,则默认展开
                treeNode.Expanded = true;
                foreach (DataRow row in rows)
                {
                    FineUIPro.TreeNode node = new FineUIPro.TreeNode();
                    node.Text   = row["nodetext"].ToString();
                    node.NodeID = row["id"].ToString();
                    node.Attributes.Add("nodemenu", row["nodemenu"].ToString().Trim());
                    node.Attributes.Add("isclick", row["isclick"].ToString().Trim());

                    node.EnableClickEvent = true;


                    treeNode.Nodes.Add(node);

                    ResolveSubTree(row, node);
                }
            }
        }
        private void inittree()
        {
            firsttree.Nodes.Clear();
            // 模拟从数据库返回数据表
            pd_machinekit pm    = new pd_machinekit();
            DataTable     table = pm.getBindTreeDataAsdt();

            DataSet ds = new DataSet();

            ds.Tables.Add(table);
            ds.Relations.Add("TreeRelation", ds.Tables[0].Columns["id"], ds.Tables[0].Columns["pid"]);

            foreach (DataRow row in ds.Tables[0].Rows)
            {
                if (row.IsNull("pid"))
                {
                    FineUIPro.TreeNode node = new FineUIPro.TreeNode();
                    node.Text   = row["nodetext"].ToString();
                    node.NodeID = row["id"].ToString();

                    node.Attributes.Add("nodemenu", row["nodemenu"].ToString().Trim());

                    if (row["isclick"].ToString().Trim() == "2")
                    {
                        node.EnableClickEvent = true;
                    }

                    firsttree.Nodes.Add(node);
                    ResolveSubTree(row, node);
                }
            }

            getnodesum(firsttree.Nodes[0]);

            setrepeat();
        }
        protected void BindTree()
        {
            TreeDpt.Nodes.Clear();
            int dptId = GetIdentityUser().dptId;

            IDataParameter[] parameters = new IDataParameter[] { new SqlParameter("@dptId", dptId) };
            DataSet          ds         = DbHelperSQL.RunProcedure("GetChildrenDptTree", parameters, "dptTree");

            ds.Relations.Add("TreeRelation", ds.Tables[0].Columns["dptId"], ds.Tables[0].Columns["dptFatherId"], false);

            foreach (DataRow row in ds.Tables[0].Rows)
            {
                if (row["dptId"].ToString() == dptId.ToString())
                {
                    FineUIPro.TreeNode node = new FineUIPro.TreeNode();
                    node.NodeID           = row["dptId"].ToString();
                    node.Text             = row["dptName"].ToString();
                    node.EnableClickEvent = true;
                    TreeDpt.Nodes.Add(node);
                    ResolveSubTree(row, node);
                }
            }
            TreeDpt.SelectedNodeID = dptId.ToString();
        }
Esempio n. 13
0
        private void inittreeMenu()
        {
            // 模拟从数据库返回数据表
            userMenu  um    = new userMenu();
            DataTable table = um.gettreeMenudata(SessionUserName);

            DataSet ds = new DataSet();

            ds.Tables.Add(table);
            ds.Relations.Add("TreeRelation", ds.Tables[0].Columns["id"], ds.Tables[0].Columns["pid"]);

            foreach (DataRow row in ds.Tables[0].Rows)
            {
                if (row.IsNull("pid"))
                {
                    FineUIPro.TreeNode node = new FineUIPro.TreeNode();
                    node.Text             = row["nodetext"].ToString();
                    node.NodeID           = row["nodeid"].ToString();
                    node.EnableCheckEvent = true;
                    treeMenu.Nodes.Add(node);
                    ResolveSubTree(row, node);
                }
            }
        }
Esempio n. 14
0
        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();
            }
        }
        //图片
        protected void filePhoto_FileSelected(object sender, EventArgs e)
        {
            FineUIPro.TreeNode treenode = firsttree.SelectedNode;

            if (treenode != null && treenode.Attributes["nodemenu"].ToString().Trim() == "2")
            {
                cd_thermal ct     = new cd_thermal();
                string     strtid = ct.isExistdata("cd_thermal", "pid", treenode.NodeID.ToString().Trim(), "ID").Trim();

                if (strtid == "")
                {
                    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(strtid, strpname, fileName, strfiletype);

                        try
                        {
                            pd_photo pp          = new pd_photo();
                            string   strfilename = pp.isExistdata("pd_photo", "pid", strtid, "filename");

                            if (strfilename.Trim() != "")
                            {
                                strfilename = Server.MapPath("~/resources/photo/") + strfilename;

                                if (File.Exists(strfilename))
                                {
                                    File.Delete(strfilename);
                                }

                                pp.update(dic, "pd_photo", "pid", strtid);
                            }
                            else
                            {
                                dic.Add("ID", Guid.NewGuid().ToString());
                                dic.Add("pid", strtid);
                                pp.add(dic, "pd_photo");
                            }
                        }
                        catch
                        {
                        }
                    }
                }
                catch
                {
                }
            }
        }
        //CAD图纸
        protected void filemxcad_FileSelected(object sender, EventArgs e)
        {
            FineUIPro.TreeNode treenode = firsttree.SelectedNode;

            if (treenode != null && treenode.Attributes["nodemenu"].ToString().Trim() == "2")
            {
                cd_thermal ct     = new cd_thermal();
                string     strtid = ct.isExistdata("cd_thermal", "pid", treenode.NodeID.ToString().Trim(), "ID").Trim();

                if (strtid == "")
                {
                    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(strtid, strpname, fileName, strfiletype);

                        try
                        {
                            pd_cad pc          = new pd_cad();
                            string strfilename = pc.isExistdata("pd_cad", "pid", strtid, "filename");

                            if (strfilename.Trim() != "")
                            {
                                strfilename = Server.MapPath("~/resources/cad/") + strfilename;

                                if (File.Exists(strfilename))
                                {
                                    File.Delete(strfilename);
                                }

                                pc.update(dic, "pd_cad", "pid", strtid);
                            }
                            else
                            {
                                dic.Add("ID", Guid.NewGuid().ToString());
                                dic.Add("pid", strtid);
                                pc.add(dic, "pd_cad");
                            }


                            PageContext.RegisterStartupScript("openwebcad('http://" + Request.Url.Authority.Trim() + "/resources/cad/" + fileName + "')");
                        }
                        catch
                        {
                        }
                    }
                }
                catch
                {
                }
            }
        }
        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();
                }
            }
        }
Esempio n. 18
0
        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();
        }
Esempio n. 19
0
        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();
            }
        }
Esempio n. 20
0
        protected void btnSavefeature_Click(object sender, EventArgs e)
        {
            FineUIPro.TreeNode treenode = firsttree.SelectedNode;

            if (treenode != null && treenode.Attributes["nodemenu"].ToString().Trim() == "2")
            {
                Dictionary <int, Dictionary <string, object> > modifiedDict = mainGrid.GetModifiedDict();

                pd_machinekit_feature pmf = new pd_machinekit_feature();

                List <Dictionary <string, string> > listdic = new List <Dictionary <string, string> >();

                string strpid = treenode.NodeID;

                for (int i = 0; i < mainGrid.Rows.Count; i++)
                {
                    Dictionary <string, string> dic = new Dictionary <string, string>();
                    dic.Add("ID", Guid.NewGuid().ToString().Trim());
                    dic.Add("pid", strpid);
                    dic.Add("featureid", mainGrid.DataKeys[i][0].ToString().Trim());
                    dic.Add("featurevalue", mainGrid.DataKeys[i][2].ToString().Trim());
                    dic.Add("operater", SessionUserName);

                    foreach (int rowindex in modifiedDict.Keys)
                    {
                        if (i == rowindex)
                        {
                            Dictionary <string, object> row = modifiedDict[rowindex];

                            dic["featurevalue"] = row["featurevalue"].ToString().Trim();
                            break;
                        }
                    }

                    listdic.Add(dic);
                }

                int      intresult = 0;
                string[] sqltext   = new string[listdic.Count + 1];

                sqltext[0] = createSql.DeleteDatasql("pd_machinekit_feature", "pid", strpid);
                string[] tempsql = createSql.getinsrtsqlarray("pd_machinekit_feature", listdic);
                for (int i = 0; i < tempsql.Length; i++)
                {
                    sqltext[i + 1] = tempsql[i];
                }

                intresult = pmf.ExecMutri(sqltext);

                Alert alert = new Alert();

                if (intresult > 0)
                {
                    alert.Icon    = Icon.Information;
                    alert.Message = "数据保存成功";
                }
                else
                {
                    alert.MessageBoxIcon = MessageBoxIcon.Error;
                    alert.Message        = "数据保存失败";
                }

                alert.Show();
            }
        }