//檔案上傳
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();
}
}
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();
}
}
}
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();
}
//建立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();
}
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='';");
}