コード例 #1
0
        public void GrantFor(string authtype)
        {
            string str = "";

            if (base.CurrentUser.IsLogin)
            {
                object obj2 = new SmoothEnterprise.Database.DataSet().ExecuteScalar("SELECT gid FROM dguser WHERE id='" + base.CurrentUser.ID + "'");
                if (obj2 == null)
                {
                    str = "";
                }
                str = (obj2 == null) ? "" : obj2.ToString();
            }
            string str2 = authtype;

            if (str2 != null)
            {
                if (!(str2 == "50"))
                {
                    if (!(str2 == "70"))
                    {
                        if (str2 == "90")
                        {
                            this.QUERY_gid.ItemAllDisplayed  = true;
                            this.QUERY_gid.ItemNoneDisplayed = true;
                        }
                        return;
                    }
                }
                else
                {
                    if (str != "")
                    {
                        this.QUERY_gid.ExtendWhere = "id='" + str + "'";
                        this._authwhere            = " A.gid IN(SELECT id FROM dggroup WHERE id='{" + str + "}' OR pids LIKE '%{" + str + "}%')";
                        return;
                    }
                    this.QUERY_gid.ItemNoneDisplayed = true;
                    this.QUERY_gid.ExtendWhere       = "1=0";
                    this._authwhere = " A.id='" + base.CurrentUser.ID + "'";
                    return;
                }
                if (str != "")
                {
                    this.QUERY_gid.ItemAllDisplayed = true;
                    this.QUERY_gid.RootId           = str;
                    this._authwhere = " A.gid IN(SELECT id FROM dggroup WHERE id='{" + str + "}' OR pids LIKE '%{" + str + "}%')";
                }
                else
                {
                    this.QUERY_gid.ItemNoneDisplayed = true;
                    this.QUERY_gid.ExtendWhere       = "1=0";
                    this._authwhere = " A.id='" + base.CurrentUser.ID + "'";
                }
            }
        }
コード例 #2
0
        //檔案上傳

        protected void DdDept_SelectedIndexChanged(object sender, EventArgs e)
        {
            DDgid.Items.Clear();
            SmoothEnterprise.Database.DataSet ds = new SmoothEnterprise.Database.DataSet(SmoothEnterprise.Database.DataSetType.OpenRead);
            ds.Open(" select *  from dggroup where comid='" + DdDept.SelectedValue + "'");
            while (!ds.EOF)
            {
                DDgid.Items.Add(new ListItem(ds["name"].ToString(), ds["id"].ToString()));
                ds.MoveNext();
            }
        }
コード例 #3
0
        protected void Page_Load(object sender, EventArgs e)
        {
            //this.tabtitle_Account.Attributes["tabtitle"] = base.GetLocalResourceObject("tabtitle_Account").ToString();
            //this.tabtitle_Information.Attributes["tabtitle"] = base.GetLocalResourceObject("tabtitle_Information").ToString();


            this.FIELD_photo.Attributes.Add("onchange", "value==''?" + this.PREVIEW_photo.ClientID + ".src='/lib/img/img-noimage.gif':" + this.PREVIEW_photo.ClientID + ".src=value;");
            DataSet set = new DataSet(DataSetType.OpenRead);

            if (!base.IsPostBack)
            {
                this.FIELD_utype.Value = UType.SmoothEnterprise.ToString();
            }
            set.Open("select * from dgrole ");
            this.FIELD_role.Items.Clear();
            for (int i = 0; i < set.Rows.Count; i++)
            {
                this.FIELD_role.Items.Add(set.Rows[i]["name"].ToString(), set.Rows[i]["id"].ToString(), set.Rows[i]["isdefault"].ToString() == "Y");
            }
            this.FIELD_utype_SelectedIndexChanged(sender, e);
            this.FIELD_pwd.Attributes.Add("onChange", this.FIELD_pwd_confirm.ClientID + ".value='';");

            if (!this.IsPostBack)
            {
                SmoothEnterprise.Database.DataSet ds = new SmoothEnterprise.Database.DataSet(SmoothEnterprise.Database.DataSetType.OpenRead);
                string whereis = "";
                string comid   = "";
                ds.Open("select comid from dguser where id='" + this.CurrentUser.ID + "'");
                if (ds["comid"].ToString() != "")
                {
                    comid = ds["comid"].ToString().ToUpper().Trim();
                }
                ds.Close();

                if (comid != "MAT")
                {
                    whereis = " where comid='" + comid + "'";
                    DdDept.SelectedValue = comid;
                    DdDept.Enabled       = false;
                }



                ds.Open(" select *  from dggroup  " + whereis);
                while (!ds.EOF)
                {
                    DDgid.Items.Add(new ListItem(ds["name"].ToString(), ds["id"].ToString()));

                    ds.MoveNext();
                }
            }
        }
コード例 #4
0
        public int GetReminderCount()
        {
            int num = 0;

            try
            {
                SmoothEnterprise.Database.DataSet set = new SmoothEnterprise.Database.DataSet();
                num = (int)set.ExecuteScalar(" SELECT COUNT(logonid) FROM dguser WHERE ustatus='" + UStatus.Pending.ToString() + "' ");
            }
            catch
            {
            }
            return(num);
        }
コード例 #5
0
        private void CreateXML(string requid)
        {
            DateTime currentDate  = DateTime.Now;
            long     elapsedTicks = currentDate.Ticks;


            SmoothEnterprise.Database.DataSet ds  = new SmoothEnterprise.Database.DataSet(SmoothEnterprise.Database.DataSetType.OpenRead);
            SmoothEnterprise.Database.DataSet rs1 = new SmoothEnterprise.Database.DataSet(SmoothEnterprise.Database.DataSetType.OpenRead);
            rs1.Open("select *  from dguser where id='" + requid + "'");
            string filename;
            int    DTotal = 0;

            while (!rs1.EOF)
            {
                XmlDocument xdoc = new XmlDocument();
                xdoc.AppendChild(xdoc.CreateXmlDeclaration("1.0", "UTF-8", "yes"));
                // 建立根節點物件並加入 XmlDocument 中 (第 0 層)
                XmlElement rootElement = xdoc.CreateElement("NewDataSet");
                xdoc.AppendChild(rootElement);

                XmlElement eleChild1 = xdoc.CreateElement("NewDataSet");

                /*
                 *
                 *            ,utype,,,,
                 * ,,,,,,effectdate,expiredate,dsn,gid
                 * ,ucategory,userpath,authcode,sid,optname1,optvalue1,optsyscontrol1
                 * ,optname2,optvalue2,optsyscontrol2,optname3,optvalue3,optsyscontrol3,inituid
                 * ,initdate,modifydate,modifyuid,comid,empid,levid,erpid*/
                XmlElement eleGrandChilds = xdoc.CreateElement("FileType");
                eleGrandChilds.InnerText = "ADD";
                rootElement.AppendChild(eleGrandChilds);

                XmlElement eleGrandChild1 = xdoc.CreateElement("id");
                eleGrandChild1.InnerText = rs1["id"].ToString().Trim();
                rootElement.AppendChild(eleGrandChild1);

                XmlElement eleGrandChild2 = xdoc.CreateElement("utype");
                eleGrandChild2.InnerText = rs1["utype"].ToString().Trim();
                rootElement.AppendChild(eleGrandChild2);

                XmlElement eleGrandChild3 = xdoc.CreateElement("logonid");
                eleGrandChild3.InnerText = rs1["logonid"].ToString().Trim();
                rootElement.AppendChild(eleGrandChild3);

                XmlElement eleGrandChild4 = xdoc.CreateElement("name");
                eleGrandChild4.InnerText = rs1["name"].ToString().Trim();
                rootElement.AppendChild(eleGrandChild4);

                XmlElement eleGrandChild5 = xdoc.CreateElement("userdomain");
                eleGrandChild5.InnerText = rs1["userdomain"].ToString().Trim();
                rootElement.AppendChild(eleGrandChild5);


                XmlElement eleGrandChild6 = xdoc.CreateElement("pwd");
                eleGrandChild6.InnerText = rs1["pwd"].ToString().Trim();
                rootElement.AppendChild(eleGrandChild6);


                XmlElement eleGrandChild7 = xdoc.CreateElement("pwdhintid");
                eleGrandChild7.InnerText = rs1["pwdhintid"].ToString().Trim();
                rootElement.AppendChild(eleGrandChild7);

                XmlElement eleGrandChild8 = xdoc.CreateElement("pwdhint");
                eleGrandChild8.InnerText = rs1["pwdhint"].ToString().Trim();
                rootElement.AppendChild(eleGrandChild8);

                XmlElement eleGrandChild9 = xdoc.CreateElement("pwdanswer");
                eleGrandChild9.InnerText = rs1["pwdanswer"].ToString().Trim();
                rootElement.AppendChild(eleGrandChild9);

                XmlElement eleGrandChild10 = xdoc.CreateElement("email");
                eleGrandChild10.InnerText = rs1["email"].ToString().Trim();
                rootElement.AppendChild(eleGrandChild10);

                XmlElement eleGrandChild11 = xdoc.CreateElement("remark");
                eleGrandChild11.InnerText = rs1["remark"].ToString().Trim();
                rootElement.AppendChild(eleGrandChild11);

                XmlElement eleGrandChild12 = xdoc.CreateElement("ustatus");
                eleGrandChild12.InnerText = rs1["ustatus"].ToString().Trim();
                rootElement.AppendChild(eleGrandChild12);



                XmlElement eleGrandChild13 = xdoc.CreateElement("effectdate");
                eleGrandChild13.InnerText = rs1["effectdate"].ToString().Trim();
                rootElement.AppendChild(eleGrandChild13);

                XmlElement eleGrandChild14 = xdoc.CreateElement("expiredate");
                eleGrandChild14.InnerText = rs1["expiredate"].ToString().Trim();
                rootElement.AppendChild(eleGrandChild14);

                XmlElement eleGrandChild15 = xdoc.CreateElement("dsn");
                eleGrandChild15.InnerText = rs1["dsn"].ToString().Trim();
                rootElement.AppendChild(eleGrandChild15);

                XmlElement eleGrandChild16 = xdoc.CreateElement("gid");
                eleGrandChild16.InnerText = rs1["gid"].ToString().Trim();
                rootElement.AppendChild(eleGrandChild16);

                XmlElement eleGrandChild17 = xdoc.CreateElement("ucategory");
                eleGrandChild17.InnerText = rs1["ucategory"].ToString().Trim();
                rootElement.AppendChild(eleGrandChild17);

                XmlElement eleGrandChild18 = xdoc.CreateElement("userpath");
                eleGrandChild18.InnerText = rs1["userpath"].ToString().Trim();
                rootElement.AppendChild(eleGrandChild18);

                /*
                 *               ,utype,,,,
                 * ,,,,,,,,,
                 * ,,,,,,,
                 * ,optname2,optvalue2,optsyscontrol2,optname3,optvalue3,optsyscontrol3,inituid
                 * ,initdate,modifydate,modifyuid,comid,empid,levid,erpid*/


                XmlElement eleGrandChild19 = xdoc.CreateElement("authcode");
                eleGrandChild19.InnerText = rs1["authcode"].ToString().Trim();
                rootElement.AppendChild(eleGrandChild19);

                XmlElement eleGrandChild20 = xdoc.CreateElement("sid");
                eleGrandChild20.InnerText = rs1["sid"].ToString().Trim();
                rootElement.AppendChild(eleGrandChild20);

                XmlElement eleGrandChild21 = xdoc.CreateElement("optname1");
                eleGrandChild21.InnerText = rs1["optname1"].ToString().Trim();
                rootElement.AppendChild(eleGrandChild21);

                XmlElement eleGrandChild22 = xdoc.CreateElement("optvalue1");
                eleGrandChild22.InnerText = rs1["optvalue1"].ToString().Trim();
                rootElement.AppendChild(eleGrandChild22);

                XmlElement eleGrandChild23 = xdoc.CreateElement("optsyscontrol1");
                eleGrandChild23.InnerText = rs1["optsyscontrol1"].ToString().Trim();
                rootElement.AppendChild(eleGrandChild23);

                XmlElement eleGrandChild231 = xdoc.CreateElement("comid");
                eleGrandChild231.InnerText = rs1["comid"].ToString().Trim();
                rootElement.AppendChild(eleGrandChild231);


                XmlElement eleGrandChild24 = xdoc.CreateElement("empid");
                eleGrandChild24.InnerText = rs1["empid"].ToString().Trim();
                rootElement.AppendChild(eleGrandChild24);


                XmlElement eleGrandChild25 = xdoc.CreateElement("levid");
                eleGrandChild25.InnerText = rs1["levid"].ToString().Trim();
                rootElement.AppendChild(eleGrandChild25);


                XmlElement eleGrandChild26 = xdoc.CreateElement("erpid");
                eleGrandChild26.InnerText = rs1["erpid"].ToString().Trim();
                rootElement.AppendChild(eleGrandChild26);
                //lsit  使用者有那些群

                ds.Open("select rid,uid,modifyuid  from dgroleuser where uid='" + requid + "'");
                //先暫時產生一筆
                while (!ds.EOF)
                {
                    XmlElement eleGrandChild27 = xdoc.CreateElement("rid");
                    eleGrandChild27.InnerText = ds["rid"].ToString().Trim();
                    rootElement.AppendChild(eleGrandChild27);

                    XmlElement eleGrandChild28 = xdoc.CreateElement("ruid");
                    eleGrandChild28.InnerText = ds["uid"].ToString().Trim();
                    rootElement.AppendChild(eleGrandChild28);


                    XmlElement eleGrandChild29 = xdoc.CreateElement("rmodifyuid");
                    eleGrandChild29.InnerText = ds["modifyuid"].ToString().Trim();
                    rootElement.AppendChild(eleGrandChild29);



                    //DTotal++;
                    ds.MoveNext();
                }
                ds.Close();


                //   XmlElement eleGrandChild28 = xdoc.CreateElement("DTotal");
                //   eleGrandChild28.InnerText = DTotal.ToString();
                //   rootElement.AppendChild(eleGrandChild28);



                filename = rs1["comid"].ToString().Trim() + "dguser" + elapsedTicks.ToString();//rs1["empid"].ToString();

                // 將建立的 XML 節點儲存為檔案

                xdoc.Save(@"C:\\Admin\\" + filename);
                xdoc.Clone();


                Upload("C:\\Admin\\" + filename, "ftp://" + ftpip + "//" + filename, "mis", "666666");
                rs1.MoveNext();
            }
            rs1.Close();
        }
コード例 #6
0
        protected void BUTTON_save_Click(object sender, EventArgs e)
        {
            if (base.IsValid)
            {
                try
                {
                    Regex regex;
                    if (WebConfigurationManager.AppSettings["PasswordCondition"] != null)
                    {
                        regex = new Regex(WebConfigurationManager.AppSettings["PasswordCondition"]);
                    }
                    else
                    {
                        regex = new Regex("");
                    }
                    if (regex.IsMatch(this.FIELD_pwd.Text))
                    {
                        //DataSet set = new DataSet(DataSetType.OpenUpdate);

                        SmoothEnterprise.Database.DataSet set = new SmoothEnterprise.Database.DataSet(SmoothEnterprise.Database.DataSetType.OpenUpdate);

                        set.Open("select * from dguser where 1=0");
                        set.Add();
                        string g = Guid.NewGuid().ToString();
                        set["id"] = new Guid(g);
                        if (this.FIELD_utype.Value != "")
                        {
                            set["utype"] = new Guid(this.FIELD_utype.Value);
                        }
                        if (this.FIELD_logonid.Text != "")
                        {
                            set["logonid"] = this.FIELD_logonid.Text;
                        }
                        if (this.FIELD_name.Text != "")
                        {
                            set["name"] = this.FIELD_name.Text;
                        }
                        if (this.FIELD_name1.Text != "")
                        {
                            set["name1"] = this.FIELD_name1.Text;
                        }
                        if (this.FIELD_photo.FileBytes.Length > 0)
                        {
                            set["icon"] = new Thumbneil(this.FIELD_photo.FileBytes, 0, 30).OutputBytes();
                        }
                        if (this.FIELD_pwd.Text != "")
                        {
                            set["pwd"] = Encryption.Encode(this.FIELD_pwd.Text);
                        }
                        if (this.FIELD_email.Text != "")
                        {
                            set["email"] = this.FIELD_email.Text;
                        }
                        if (this.FIELD_gender.SelectedValue.ToString() != "")
                        {
                            set["gender"] = this.FIELD_gender.SelectedValue;
                        }
                        if (this.FIELD_remark.Text != "")
                        {
                            set["remark"] = this.FIELD_remark.Text;
                        }
                        if (this.FIELD_ucategory.Value != "")
                        {
                            set["ucategory"] = new Guid(this.FIELD_ucategory.Value);
                        }
                        if (this.FIELD_ustatus.Value != "")
                        {
                            set["ustatus"] = new Guid(this.FIELD_ustatus.Value);
                        }
                        if (this.FIELD_userdomain.Text != "")
                        {
                            set["userdomain"] = this.FIELD_userdomain.Text;
                        }
                        if (this.FIELD_effectdate.Text != "")
                        {
                            set["effectdate"] = System.Convert.ToDateTime(this.FIELD_effectdate.Text);
                        }
                        if (this.FIELD_expiredate.Text != "")
                        {
                            set["expiredate"] = System.Convert.ToDateTime(this.FIELD_expiredate.Text);
                        }
                        //if (this.FIELD_gid.Value != "")
                        //{
                        // set["gid"] = new Guid(this.FIELD_gid.Value);
                        set["gid"] = new Guid(DDgid.SelectedValue);
                        //}
                        if (base.CurrentUser.IsLogin)
                        {
                            set["inituid"] = new Guid(base.CurrentUser.ID);
                        }
                        set["initdate"] = DateTime.Now;
                        if (base.CurrentUser.IsLogin)
                        {
                            set["modifyuid"] = new Guid(base.CurrentUser.ID);
                        }
                        set["modifydate"] = DateTime.Now;

                        //herzog Add
                        set["comid"] = DdDept.SelectedValue;
                        set["empid"] = empid.Text;

                        set.Update();
                        if (this.FIELD_photo.FileBytes.Length > 0)
                        {
                            set.Open("select * from dgimage where 1=0");
                            set.Add();
                            set["name"]  = this.FIELD_name.Text;
                            set["image"] = this.FIELD_photo.FileBytes;
                            set["sid"]   = new Guid(g);
                            if (base.CurrentUser.IsLogin)
                            {
                                set["inituid"]   = new Guid(base.CurrentUser.ID);
                                set["modifyuid"] = new Guid(base.CurrentUser.ID);
                            }
                            set["initdate"]   = DateTime.Now;
                            set["modifydate"] = DateTime.Now;
                            set.Update();
                        }
                        set.Open("select * from dgroleuser where 1=0");
                        for (int i = 0; i < this.FIELD_role.SelectedItems.Length; i++)
                        {
                            set.Add();
                            set["uid"] = new Guid(g);
                            set["rid"] = new Guid(this.FIELD_role.SelectedItems[i].Value);
                            if (base.CurrentUser.IsLogin)
                            {
                                set["modifyuid"] = new Guid(base.CurrentUser.ID);
                            }
                            set["modifydate"] = DateTime.Now;
                            set.Update();
                        }
                        set.Close();


                        SmoothEnterprise.Database.DataSet fs = new SmoothEnterprise.Database.DataSet(SmoothEnterprise.Database.DataSetType.OpenRead);
                        fs.Open("select id from dguser where logonid='" + this.FIELD_logonid.Text + "'");

                        if (!fs.EOF)
                        {
                            CreateXML(fs["id"].ToString());
                        }
                        fs.Close();



                        if (sender == this.BUTTON_savenext)
                        {
                            base.Response.Redirect("UserCompanyAdd.aspx");
                        }
                        else
                        {
                            base.Response.Redirect("UserCompany.aspx");
                        }
                    }
                    else
                    {
                        this.FIELD_pwd.Text         = "";
                        this.FIELD_pwd_confirm.Text = "";
                        base.AddError(this, "BUTTON_save_Click", "", base.GetLocalResourceObject("PasswordConditionMessageResource1").ToString());
                    }
                }
                catch (Exception exception)
                {
                    base.AddError(this, "", "", exception.Message);
                }
            }
        }
コード例 #7
0
        protected void BUTTON_save_Click(object sender, EventArgs e)
        {
            SmoothEnterprise.Database.DataSet rs = new SmoothEnterprise.Database.DataSet(SmoothEnterprise.Database.DataSetType.OpenUpdate);
            rs.Open("SELECT * FROM dguser WHERE id='" + this.FIELD_id.Text + "'");
            if (!rs.EOF)
            {
                rs["pwd"] = Encryption.Encode(this.FIELD_pwd.Text);

                if (this.FIELD_pwdhintid.Value != "")
                {
                    rs["pwdhintid"] = new Guid(this.FIELD_pwdhintid.Value);
                }
                else
                {
                    rs["pwdhintid"] = DBNull.Value;
                }
                if (this.FIELD_pwdanswer.Text != "")
                {
                    rs["pwdanswer"] = Utility.Encryptor(this.FIELD_pwdanswer.Text);
                }
                else
                {
                    rs["pwdanswer"] = DBNull.Value;
                }

                /* if (new Guid(this.FIELD_ustatus.Text) == UStatus.ChangePassword)
                 * {
                 *  rs["ustatus"] = UStatus.Enable;
                 * }*/
                if (base.CurrentUser.IsLogin)
                {
                    rs["modifyuid"] = new Guid(base.CurrentUser.ID);
                }
                rs["ustatus"]    = "57DADAB8-44CF-4BAA-A40C-324F9F4533A9";
                rs["modifydate"] = DateTime.Now;
                rs.Update();
            }
            rs.Close();

            base.Response.Redirect(((base.BackPageUrl == "") || (base.BackPageUrl.ToLower().IndexOf("security/login.aspx") >= 0)) ? "Logout.aspx" : base.BackPageUrl);


            /*if (base.IsValid)
             * {
             *  try
             *  {
             *      Regex regex;
             *      if (WebConfigurationManager.AppSettings["PasswordCondition"] != null)
             *      {
             *          regex = new Regex(WebConfigurationManager.AppSettings["PasswordCondition"]);
             *      }
             *      else
             *      {
             *          regex = new Regex("");
             *      }
             *      if (regex.IsMatch(this.FIELD_pwd.Text))
             *      {
             *          bool flag = false;
             *          DataSet set = new DataSet(DataSetType.OpenRead);
             *          int result = 0;
             *          try
             *          {
             *              int.TryParse(WebConfigurationManager.AppSettings["PasswordReuseCount"], out result);
             *          }
             *          catch
             *          {
             *              result = 0;
             *          }
             *          set.Open("select top " + result.ToString() + " logresult from dguserlog where ulogtype='" + ULogType.ChgPwd.ToString() + "' and logresult like '%ChangePassword:%' and uid='" + this.FIELD_id.Text + "' order by logondate desc");
             *          while (!set.EOF)
             *          {
             *              if (Encryption.Decode(set["logresult"].ToString().Replace("ChangePassword:"******"")).Split(new char[] { ',' })[1] == this.FIELD_pwd.Text)
             *              {
             *                  flag = true;
             *              }
             *              set.MoveNext();
             *          }
             *          if (!flag)
             *          {
             *              DataSet set2 = new DataSet(DataSetType.OpenUpdate);
             *              set2.Open("SELECT * FROM dguser WHERE id='" + this.FIELD_id.Text + "'; ");
             *              if (this.FIELD_pwd.Text != "")
             *              {
             *                  set2["pwd"] = Encryption.Encode(this.FIELD_pwd.Text);
             *              }
             *              if (this.FIELD_pwdhintid.Value != "")
             *              {
             *                  set2["pwdhintid"] = new Guid(this.FIELD_pwdhintid.Value);
             *              }
             *              else
             *              {
             *                  set2["pwdhintid"] = DBNull.Value;
             *              }
             *              if (this.FIELD_pwdanswer.Text != "")
             *              {
             *                  set2["pwdanswer"] = Utility.Encryptor(this.FIELD_pwdanswer.Text);
             *              }
             *              else
             *              {
             *                  set2["pwdanswer"] = DBNull.Value;
             *              }
             *              if (new Guid(this.FIELD_ustatus.Text) == UStatus.ChangePassword)
             *              {
             *                  set2["ustatus"] = UStatus.Enable;
             *              }
             *              if (base.CurrentUser.IsLogin)
             *              {
             *                  set2["modifyuid"] = new Guid(base.CurrentUser.ID);
             *              }
             *              set2["modifydate"] = DateTime.Now;
             *              set2.Update();
             *              set2.Close();
             *              Utility.UserLogAdd(base.Request, this.FIELD_id.Text, ULogType.ChgPwd.ToString(), "ChangePassword:"******"," + this.FIELD_pwd.Text));
             *              if (!(new Guid(this.FIELD_ustatus.Text) == UStatus.ChangePassword))
             *              {
             *                  this.BUTTON_cancel_Click(sender, e);
             *              }
             *          }
             *          else
             *          {
             *              this.FIELD_pwd.Text = "";
             *              this.FIELD_pwd_confirm.Text = "";
             *              base.AddError(this, "BUTTON_save_Click", "", base.GetLocalResourceObject("PasswordCannotuseMessageResource1").ToString().Replace("#reusecount#", result.ToString()));
             *          }
             *      }
             *      else
             *      {
             *          this.FIELD_pwd.Text = "";
             *          this.FIELD_pwd_confirm.Text = "";
             *          base.AddError(this, "BUTTON_save_Click", "", base.GetLocalResourceObject("PasswordConditionMessageResource1").ToString());
             *      }
             *  }
             *  catch (Exception exception)
             *  {
             *      base.AddError(this, "BUTTON_save_Click", "", exception.Message);
             *  }
             * }*/
        }
コード例 #8
0
        //建立XML 檔
        //輸入的參數為 link id

        private void CreateXML(string requid)
        {
            DateTime currentDate  = DateTime.Now;
            long     elapsedTicks = currentDate.Ticks;

            SmoothEnterprise.Database.DataSet ds  = new SmoothEnterprise.Database.DataSet(SmoothEnterprise.Database.DataSetType.OpenRead);
            SmoothEnterprise.Database.DataSet rs1 = new SmoothEnterprise.Database.DataSet(SmoothEnterprise.Database.DataSetType.OpenRead);
            rs1.Open("select *  from dguser where id='" + requid + "'");
            string filename;
            int    DTotal = 0;

            while (!rs1.EOF)
            {
                XmlDocument xdoc = new XmlDocument();
                xdoc.AppendChild(xdoc.CreateXmlDeclaration("1.0", "UTF-8", "yes"));
                // 建立根節點物件並加入 XmlDocument 中 (第 0 層)
                XmlElement rootElement = xdoc.CreateElement("NewDataSet");
                xdoc.AppendChild(rootElement);

                XmlElement eleChild1 = xdoc.CreateElement("NewDataSet");


                XmlElement eleGrandChilds = xdoc.CreateElement("FileType");
                eleGrandChilds.InnerText = "Update";
                rootElement.AppendChild(eleGrandChilds);

                XmlElement eleGrandChild1 = xdoc.CreateElement("id");
                eleGrandChild1.InnerText = rs1["id"].ToString().Trim();
                rootElement.AppendChild(eleGrandChild1);

                XmlElement eleGrandChild2 = xdoc.CreateElement("utype");
                if (LocComid.SelectedValue != "NA")
                {
                    eleGrandChild2.InnerText = "64CA1E7D-B15F-43CB-A33A-D29DB9020892";
                }
                else
                {
                    eleGrandChild2.InnerText = rs1["utype"].ToString().Trim();
                }
                rootElement.AppendChild(eleGrandChild2);

                XmlElement eleGrandChild3 = xdoc.CreateElement("logonid");
                eleGrandChild3.InnerText = rs1["logonid"].ToString().Trim();
                rootElement.AppendChild(eleGrandChild3);

                XmlElement eleGrandChild4 = xdoc.CreateElement("name");
                eleGrandChild4.InnerText = rs1["name"].ToString().Trim();
                rootElement.AppendChild(eleGrandChild4);

                XmlElement eleGrandChild5 = xdoc.CreateElement("userdomain");
                eleGrandChild5.InnerText = rs1["userdomain"].ToString().Trim();
                rootElement.AppendChild(eleGrandChild5);


                XmlElement eleGrandChild6 = xdoc.CreateElement("pwd");
                if (LocComid.SelectedValue != "NA")
                {
                    eleGrandChild6.InnerText = rs1["pwd"].ToString().Trim();
                }
                else
                {
                    eleGrandChild6.InnerText = "";
                }
                rootElement.AppendChild(eleGrandChild6);


                XmlElement eleGrandChild7 = xdoc.CreateElement("pwdhintid");
                eleGrandChild7.InnerText = rs1["pwdhintid"].ToString().Trim();
                rootElement.AppendChild(eleGrandChild7);

                XmlElement eleGrandChild8 = xdoc.CreateElement("pwdhint");
                eleGrandChild8.InnerText = rs1["pwdhint"].ToString().Trim();
                rootElement.AppendChild(eleGrandChild8);

                XmlElement eleGrandChild9 = xdoc.CreateElement("pwdanswer");
                eleGrandChild9.InnerText = rs1["pwdanswer"].ToString().Trim();
                rootElement.AppendChild(eleGrandChild9);

                XmlElement eleGrandChild10 = xdoc.CreateElement("email");
                eleGrandChild10.InnerText = rs1["email"].ToString().Trim();
                rootElement.AppendChild(eleGrandChild10);

                XmlElement eleGrandChild11 = xdoc.CreateElement("remark");
                eleGrandChild11.InnerText = rs1["remark"].ToString().Trim();
                rootElement.AppendChild(eleGrandChild11);

                XmlElement eleGrandChild12 = xdoc.CreateElement("ustatus");
                if (LocComid.SelectedValue != "NA")
                {
                    eleGrandChild12.InnerText = "76CBA823-E891-45D3-8B6C-4724E6C69D5B";
                }
                else
                {
                    eleGrandChild12.InnerText = rs1["ustatus"].ToString().Trim();
                }


                rootElement.AppendChild(eleGrandChild12);



                XmlElement eleGrandChild13 = xdoc.CreateElement("effectdate");
                eleGrandChild13.InnerText = rs1["effectdate"].ToString().Trim();
                rootElement.AppendChild(eleGrandChild13);

                XmlElement eleGrandChild14 = xdoc.CreateElement("expiredate");
                eleGrandChild14.InnerText = rs1["expiredate"].ToString().Trim();
                rootElement.AppendChild(eleGrandChild14);

                XmlElement eleGrandChild15 = xdoc.CreateElement("dsn");
                eleGrandChild15.InnerText = rs1["dsn"].ToString().Trim();
                rootElement.AppendChild(eleGrandChild15);

                XmlElement eleGrandChild16 = xdoc.CreateElement("gid");
                if (LocComid.SelectedValue != "NA")
                {
                    eleGrandChild16.InnerText = "";//因為子廠可能不會有這個人的群組
                }
                else
                {
                    eleGrandChild16.InnerText = rs1["gid"].ToString().Trim();
                }


                rootElement.AppendChild(eleGrandChild16);

                XmlElement eleGrandChild17 = xdoc.CreateElement("ucategory");
                eleGrandChild17.InnerText = rs1["ucategory"].ToString().Trim();
                rootElement.AppendChild(eleGrandChild17);

                XmlElement eleGrandChild18 = xdoc.CreateElement("userpath");
                eleGrandChild18.InnerText = rs1["userpath"].ToString().Trim();
                rootElement.AppendChild(eleGrandChild18);

                /*
                 *               ,utype,,,,
                 * ,,,,,,,,,
                 * ,,,,,,,
                 * ,optname2,optvalue2,optsyscontrol2,optname3,optvalue3,optsyscontrol3,inituid
                 * ,initdate,modifydate,modifyuid,comid,empid,levid,erpid*/


                XmlElement eleGrandChild19 = xdoc.CreateElement("authcode");
                eleGrandChild19.InnerText = rs1["authcode"].ToString().Trim();
                rootElement.AppendChild(eleGrandChild19);

                XmlElement eleGrandChild20 = xdoc.CreateElement("sid");
                eleGrandChild20.InnerText = rs1["sid"].ToString().Trim();
                rootElement.AppendChild(eleGrandChild20);

                XmlElement eleGrandChild21 = xdoc.CreateElement("optname1");
                eleGrandChild21.InnerText = rs1["optname1"].ToString().Trim();
                rootElement.AppendChild(eleGrandChild21);

                XmlElement eleGrandChild22 = xdoc.CreateElement("optvalue1");
                eleGrandChild22.InnerText = rs1["optvalue1"].ToString().Trim();
                rootElement.AppendChild(eleGrandChild22);

                XmlElement eleGrandChild23 = xdoc.CreateElement("optsyscontrol1");
                eleGrandChild23.InnerText = rs1["optsyscontrol1"].ToString().Trim();
                rootElement.AppendChild(eleGrandChild23);

                XmlElement eleGrandChild231 = xdoc.CreateElement("comid");
                eleGrandChild231.InnerText = rs1["comid"].ToString().Trim();
                rootElement.AppendChild(eleGrandChild231);


                XmlElement eleGrandChild24 = xdoc.CreateElement("empid");
                eleGrandChild24.InnerText = rs1["empid"].ToString().Trim();
                rootElement.AppendChild(eleGrandChild24);


                XmlElement eleGrandChild25 = xdoc.CreateElement("levid");
                eleGrandChild25.InnerText = rs1["levid"].ToString().Trim();
                rootElement.AppendChild(eleGrandChild25);


                XmlElement eleGrandChild26 = xdoc.CreateElement("erpid");
                eleGrandChild26.InnerText = rs1["erpid"].ToString().Trim();
                rootElement.AppendChild(eleGrandChild26);
                //lsit  使用者有那些群組

                ds.Open("select rid,uid,modifyuid  from dgroleuser where uid='" + requid + "'");
                //先暫時產生一筆
                if (!ds.EOF)
                {
                    XmlElement eleGrandChild27 = xdoc.CreateElement("rid");
                    eleGrandChild27.InnerText = "6D25693F-6B5D-4A5F-8716-D641A335B925"; // ds["rid"].ToString().Trim();
                    rootElement.AppendChild(eleGrandChild27);

                    XmlElement eleGrandChild28 = xdoc.CreateElement("ruid");
                    eleGrandChild28.InnerText = ds["uid"].ToString().Trim();
                    rootElement.AppendChild(eleGrandChild28);


                    XmlElement eleGrandChild29 = xdoc.CreateElement("rmodifyuid");
                    eleGrandChild29.InnerText = ds["modifyuid"].ToString().Trim();
                    rootElement.AppendChild(eleGrandChild29);



                    //DTotal++;
                    //ds.MoveNext();
                }
                ds.Close();


                //   XmlElement eleGrandChild28 = xdoc.CreateElement("DTotal");
                //   eleGrandChild28.InnerText = DTotal.ToString();
                //   rootElement.AppendChild(eleGrandChild28);

                if (LocComid.SelectedValue != "NA")
                {
                    filename = LocComid.SelectedValue + "dguser" + elapsedTicks.ToString();  // rs1["empid"].ToString();
                }
                else
                {
                    filename = rs1["comid"].ToString().Trim() + "dguser" + elapsedTicks.ToString();  // rs1["empid"].ToString();
                }



                // 將建立的 XML 節點儲存為檔案

                xdoc.Save(@"C:\\Admin\\" + filename);
                xdoc.Clone();


                Upload("C:\\Admin\\" + filename, "ftp://" + ftpip + "//" + filename, username, password);
                rs1.MoveNext();
            }
            rs1.Close();
        }
コード例 #9
0
        protected void Page_Load(object sender, EventArgs e)
        {
            // this.tabtitle_Account.Attributes["tabtitle"] = base.GetLocalResourceObject("tabtitle_Account").ToString();
            // this.tabtitle_Information.Attributes["tabtitle"] = base.GetLocalResourceObject("tabtitle_Information").ToString();
            this.FIELD_photo.Attributes.Add("onchange", "value==''?" + this.PREVIEW_photo.ClientID + ".src='/lib/img/img-noimage.gif':" + this.PREVIEW_photo.ClientID + ".src=value;");
            DataSet set = new DataSet(DataSetType.OpenRead);

            try
            {
                set.Open("select A.*,B.uid from dgrole A LEFT OUTER JOIN dgroleuser B ON A.id=B.rid and B.uid='" + base.Request.QueryString["id"] + "' ");
                this.FIELD_role.Items.Clear();
                for (int i = 0; i < set.Rows.Count; i++)
                {
                    this.FIELD_role.Items.Add(set.Rows[i]["name"].ToString(), set.Rows[i]["id"].ToString(), set.Rows[i]["uid"].ToString() != "");
                }
                if (!base.IsPostBack)
                {
                    set.Open("select * from dguser where id='" + base.Request.QueryString["id"] + "'");
                    if (!set.EOF)
                    {
                        this.FIELD_utype.Value          = set["utype"].ToString();
                        this.FIELD_logonid.Text         = set["logonid"].ToString();
                        this.FIELD_name.Text            = set["name"].ToString();
                        this.FIELD_name1.Text           = set["name1"].ToString();
                        this.PREVIEW_photo.Src          = "UserImage.aspx?id=" + set["id"].ToString() + "&photo=1";
                        this.FIELD_pwd.Text             = set["pwd"].ToString();
                        this.FIELD_opwd.Text            = set["pwd"].ToString();
                        this.FIELD_pwd_confirm.Text     = set["pwd"].ToString();
                        this.FIELD_email.Text           = set["email"].ToString();
                        this.FIELD_gender.SelectedIndex = this.FIELD_gender.Items.IndexOf(this.FIELD_gender.Items.FindByValue(set["gender"].ToString()));
                        this.FIELD_remark.Text          = set["remark"].ToString();
                        this.FIELD_ucategory.Value      = set["ucategory"].ToString();
                        this.FIELD_ustatus.Value        = set["ustatus"].ToString();
                        this.FIELD_userdomain.Text      = set["userdomain"].ToString();
                        if (set["effectdate"].ToString() != "")
                        {
                            this.FIELD_effectdate.Text = DateTime.Parse(set["effectdate"].ToString()).ToShortDateString();
                        }
                        if (set["expiredate"].ToString() != "")
                        {
                            this.FIELD_expiredate.Text = DateTime.Parse(set["expiredate"].ToString()).ToShortDateString();
                        }
                        // this.FIELD_gid.Value = set["gid"].ToString();


                        SmoothEnterprise.Database.DataSet ds = new SmoothEnterprise.Database.DataSet(SmoothEnterprise.Database.DataSetType.OpenRead);
                        string whereis = "";
                        string comid   = "";
                        ds.Open("select comid from dguser where id='" + this.CurrentUser.ID + "'");
                        if (ds["comid"].ToString() != "")
                        {
                            comid = ds["comid"].ToString().ToUpper().Trim();
                        }
                        ds.Close();

                        if (comid != "MAT")
                        {
                            whereis = " where comid='" + comid + "'";
                            DdDept.SelectedValue = comid;
                            DdDept.Enabled       = false;
                            LocComid.Enabled     = false;
                        }



                        ds.Open(" select *  from dggroup  " + whereis);
                        while (!ds.EOF)
                        {
                            DDgid.Items.Add(new ListItem(ds["name"].ToString(), ds["id"].ToString()));

                            ds.MoveNext();
                        }

                        ds.Close();



                        DDgid.SelectedValue  = set["gid"].ToString();
                        DdDept.SelectedValue = set["comid"].ToString().Trim();
                        empid.Text           = set["empid"].ToString();
                    }
                    else
                    {
                        base.Response.Redirect("User.aspx");
                    }
                }
            }
            catch
            {
                base.Response.Redirect("User.aspx");
            }
            this.FIELD_utype_SelectedIndexChanged(sender, e);
            this.FIELD_pwd.Attributes.Add("onChange", this.FIELD_pwd_confirm.ClientID + ".value='';");
        }