public void ProcessRequest(HttpContext context)
{
if (context.Request.Form["aid"] != null)
{
string aid = context.Request.Form["aid"].ToString().Trim();
string afileID = context.Request.Form["afileID"].ToString().Trim();
if (encode.sqlInjection(aid) || encode.sqlInjection(afileID))
{
throw new Exception("illegal paramater value");
}
Veryfly_DB myVery = new Veryfly_DB();
DataTable dt = myVery.checkimagetext(aid, afileID);
List <TooL> eList = new List <TooL>();
TooL e = new TooL();
if (dt.Rows[0]["sender_imagetext"].ToString().Trim() == context.Request.Form["vaild"].ToString().Trim())
{
DataView dv = dt.DefaultView;
dv.RowFilter = "main_stat<>'N'";
if (dv.Count == 0)
{
e.err_msg = "This data has been deleted,download fail.";
e.afile_encryptfileName = "";
e.afile_origiFileName = "";
e.afile_id = "";
e.sender_id = "";
e.afile_exten = "";
e.sender_notifyflag = "";
}
else
{
e.err_msg = "";
e.afile_encryptfileName = dv[0]["afile_encryptfileName"].ToString().Trim();
e.afile_origiFileName = dv[0]["afile_origiFileName"].ToString().Trim();
e.afile_id = dv[0]["afile_id"].ToString().Trim();
e.sender_id = dv[0]["sender_id"].ToString().Trim();
e.afile_exten = dv[0]["afile_exten"].ToString().Trim();
e.sender_notifyflag = dv[0]["sender_notifyflag"].ToString().Trim();
}
}
else
{
e.err_msg = "Verification fails, make sure you type the Verification code is correct.";
e.afile_encryptfileName = "";
e.afile_origiFileName = "";
e.afile_id = "";
e.sender_id = "";
e.afile_exten = "";
e.sender_notifyflag = "";
}
eList.Add(e);
System.Web.Script.Serialization.JavaScriptSerializer objSerializer = new System.Web.Script.Serialization.JavaScriptSerializer();
string ans = objSerializer.Serialize(eList); //new
context.Response.ContentType = "application/json";
context.Response.Write(ans);
}
}
public void ProcessRequest(HttpContext context)
{
if (context.Request.Form["aid"] != null)
{
string aid = context.Request.Form["aid"].ToString().Trim();
string afileID = context.Request.Form["afileID"].ToString().Trim();
if (encode.sqlInjection(aid) || encode.sqlInjection(afileID))
{
throw new Exception("參數包含不合法字元");
}
Veryfly_DB myVery = new Veryfly_DB();
DataTable dt = myVery.checkimagetext(aid, afileID);
List <TooL> eList = new List <TooL>();
TooL e = new TooL();
if (dt.Rows[0]["sender_imagetext"].ToString().Trim() == context.Request.Form["vaild"].ToString().Trim())
{
DataView dv = dt.DefaultView;
dv.RowFilter = "main_stat<>'N'";
if (dv.Count == 0)
{
e.err_msg = "此筆資料寄件者已刪除，檔案下載失敗";
e.afile_encryptfileName = "";
e.afile_origiFileName = "";
e.afile_id = "";
e.sender_id = "";
e.afile_exten = "";
e.sender_notifyflag = "";
}
else
{
e.err_msg = "";
e.afile_encryptfileName = dv[0]["afile_encryptfileName"].ToString().Trim();
e.afile_origiFileName = dv[0]["afile_origiFileName"].ToString().Trim();
e.afile_id = dv[0]["afile_id"].ToString().Trim();
e.sender_id = dv[0]["sender_id"].ToString().Trim();
e.afile_exten = dv[0]["afile_exten"].ToString().Trim();
e.sender_notifyflag = dv[0]["sender_notifyflag"].ToString().Trim();
}
}
else
{
e.err_msg = "驗證失敗，請確認輸入之驗證碼是否正確";
e.afile_encryptfileName = "";
e.afile_origiFileName = "";
e.afile_id = "";
e.sender_id = "";
e.afile_exten = "";
e.sender_notifyflag = "";
}
eList.Add(e);
System.Web.Script.Serialization.JavaScriptSerializer objSerializer = new System.Web.Script.Serialization.JavaScriptSerializer();
string ans = objSerializer.Serialize(eList); //new
context.Response.ContentType = "application/json";
context.Response.Write(ans);
}
}
public void ProcessRequest(HttpContext context)
{
try
{
string afile_id = context.Request.Form["afile_id"];
string afile_parentid = context.Request.Form["afile_parentid"];
string afile_comorsec = context.Request.Form["afile_comorsec"];
Veryfly_DB myVery = new Veryfly_DB();
DataTable dt = myVery.downloadfileList(afile_id, afile_parentid, afile_comorsec);
if (dt.Rows.Count > 0)
{
List <TooL> eList = new List <TooL>();
TooL e = new TooL();
e.afile_id = dt.Rows[0]["afile_id"].ToString();
e.afile_parentid = dt.Rows[0]["afile_parentid"].ToString().Trim();
e.afile_comorsec = dt.Rows[0]["afile_comorsec"].ToString().Trim();
e.afile_encrypt = dt.Rows[0]["afile_encrypt"].ToString().Trim();
e.afile_origiFileName = dt.Rows[0]["afile_origiFileName"].ToString().Trim();
e.afile_encryptfileName = dt.Rows[0]["afile_encryptfileName"].ToString().Trim();
e.afile_size = dt.Rows[0]["afile_size"].ToString().Trim();
e.afile_exten = dt.Rows[0]["afile_exten"].ToString().Trim();
e.ShowFileName = dt.Rows[0]["ShowFileName"].ToString().Trim();
e.main_stat = dt.Rows[0]["main_stat"].ToString().Trim();
eList.Add(e);
System.Web.Script.Serialization.JavaScriptSerializer objSerializer = new System.Web.Script.Serialization.JavaScriptSerializer();
string ans = objSerializer.Serialize(eList); //new
context.Response.ContentType = "application/json";
context.Response.Write(ans);
}
else
{
context.Response.Write("false");
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
public void ProcessRequest(HttpContext context)
{
string keyword = context.Request.Form["key_word"];
try
{
DataTable dt = myGen.SearchAllEmpno(keyword.ToUpper());
if (dt.Rows.Count > 0)
{
List <TooL> eList = new List <TooL>();
for (int i = 0; i < dt.Rows.Count; i++)
{
TooL e = new TooL();
e.com_cname = dt.Rows[i]["com_cname"].ToString().Trim();
e.com_mailadd = dt.Rows[i]["com_mailadd"].ToString().Trim();
e.org_abbr_chnm1 = dt.Rows[i]["org_abbr_chnm1"].ToString().Trim();
e.com_deptcd = dt.Rows[i]["com_deptcd"].ToString().Trim();
e.dep_deptname = dt.Rows[i]["dep_abbrnm"].ToString().Trim();
e.com_empno = dt.Rows[i]["com_empno"].ToString().Trim();
eList.Add(e);
}
System.Web.Script.Serialization.JavaScriptSerializer objSerializer = new System.Web.Script.Serialization.JavaScriptSerializer();
string ans = objSerializer.Serialize(eList); //new
context.Response.ContentType = "application/json";
context.Response.Write(ans);
}
else
{
context.Response.Write("empty");
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
public void ProcessRequest(HttpContext context)
{
try
{
string tbxOutComp = string.IsNullOrEmpty(context.Request.Form["tbxOutComp"]) ? "" : context.Request.Form["tbxOutComp"].ToString().Trim();
if (tbxOutComp.Trim() == "")
{
context.Response.Write("請輸入Email");
return;
}
else
{
List <TooL> eList = new List <TooL>();
string[] split = tbxOutComp.Split(new Char[] { ';', ',' });
//20130813新增，檢查email格式部分 by 凱呈
MailAddress[] addrs = new MailAddress[split.Length];
//foreach (string str in split)
for (int i = 0; i < split.Length; i++)
{
//if (!Common.IsVaildEmail(str))
//{
// context.Response.Write("Email格式錯誤");
// return;
//}
try
{
addrs[i] = new MailAddress(split[i]);
}
catch (Exception)
{
context.Response.Write("Email格式錯誤");
return;
}
DataTable dt = Common.AccordEmailIsitFromITRI(addrs[i].Address, "");
if (dt.Rows.Count > 0)
{
//表示輸入的人是院內員工
TooL e = new TooL();
e.account = dt.Rows[0]["com_empno"].ToString();
e.email = dt.Rows[0]["com_mailadd"].ToString();
eList.Add(e);
}
else
{
TooL e = new TooL();
e.account = addrs[i].Address;
e.email = addrs[i].Address;
eList.Add(e);
}
}
System.Web.Script.Serialization.JavaScriptSerializer objSerializer = new System.Web.Script.Serialization.JavaScriptSerializer();
string ans = objSerializer.Serialize(eList); //new
context.Response.ContentType = "application/json";
context.Response.Write(ans);
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
public void ProcessRequest(HttpContext context)
{
string orgcd = string.IsNullOrEmpty(context.Request.Form["orgcd"]) ? "" : context.Request.Form["orgcd"].ToString().Trim();
string deptcd = string.IsNullOrEmpty(context.Request.Form["deptcd3"]) ? "" : context.Request.Form["deptcd3"].ToString().Trim();
GenJson_DB myGen = new GenJson_DB();
DataTable dt = myGen.GenJsonDB(orgcd, deptcd);
List <TooL> eList = new List <TooL>();
/*
* json格式
* title 要顯示出來的文字
* isFolder 資料夾的圖片要不要出來 TRUE 出來
* noLink 可以讓該選項的文字不可以點 true
* hideCheckbox true可以把ROOT的CHECKBOX隱藏
*/
try
{
if (orgcd != "") //不等於空值,就代表是點擊單位之後下一偕
{
if (deptcd != "") //單位跟部門都有值,跑到人的選單
{
for (int i = 0; i < dt.Rows.Count; i++)
{
TooL e = new TooL();
e.key = dt.Rows[i]["com_orgcd"].ToString();
e.empno = dt.Rows[i]["com_empno"].ToString();
e.title = dt.Rows[i]["com_cname"].ToString().Trim() + "< " + dt.Rows[i]["com_mailadd"].ToString() + " > ";
e.noLink = false;
e.hideCheckbox = false;
e.isFolder = false;
e.isLazy = false;
e.deptcd3 = "";
e.mailadd = dt.Rows[i]["com_mailadd"].ToString();
eList.Add(e);
}
}
else
{
for (int i = 0; i < dt.Rows.Count; i++)
{
TooL e = new TooL();
e.key = dt.Rows[i]["dep_orgcd"].ToString();
e.title = dt.Rows[i]["dep_deptcd"].ToString() + " " + dt.Rows[i]["dep_abbrnm"].ToString();
e.noLink = false;
e.hideCheckbox = true;
e.isFolder = true;
e.isLazy = true;
e.deptcd3 = dt.Rows[i]["dep_deptcd"].ToString();
eList.Add(e);
}
}
}
else//預設一進入之後撈出所有的單位清單(不包括00)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
TooL e = new TooL();
e.key = dt.Rows[i]["org_orgcd"].ToString();
e.title = dt.Rows[i]["org_abbr_chnm1"].ToString();
e.noLink = false;
e.hideCheckbox = true;
e.isFolder = true;
e.isLazy = true;
e.deptcd3 = "";
eList.Add(e);
}
}
System.Web.Script.Serialization.JavaScriptSerializer objSerializer = new System.Web.Script.Serialization.JavaScriptSerializer();
string ans = objSerializer.Serialize(eList); //new
context.Response.ContentType = "application/json";
context.Response.Write(ans);
}
catch (Exception err)
{
throw new Exception(MessageUtil.DB_SelectFail + err.HelpLink);
}
}
public void ProcessRequest(HttpContext context)
{
try
{
string FromYear = context.Request.Form["FromYear"].ToString().Trim();
string FromMonth = context.Request.Form["FromMonth"].ToString().Trim();
string ToYear = context.Request.Form["ToYear"].ToString().Trim();
string ToMonth = context.Request.Form["ToMonth"].ToString().Trim();
string languageType = context.Request.Form["languageType"] == null ? "" : context.Request.Form["languageType"].ToString().Trim();
string main_infno = sAccount.GetAccInfo().Account.ToString().Trim();
string main_isempno = sAccount.GetAccInfo().Com_Isempno.ToString();
string ans = string.Empty;
List <TooL> eList = new List <TooL>();
getHistory_DB myget = new getHistory_DB();
DataTable dt = myget.getHistoryList(main_infno, main_isempno, FromYear, FromMonth, ToYear, ToMonth);
string createdate = string.Empty;
TooL e = new TooL();
List <Children> eChild = new List <Children>();
if (dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
if (dt.Rows[i]["main_createdate"].ToString().Trim() == createdate)
{
Children ex = new Children();
ex.key = dt.Rows[i]["sender_mail"].ToString().Trim();
ex.title = dt.Rows[i]["sender_mail"].ToString().Trim();
ex.isempno = dt.Rows[i]["sender_isempno"].ToString().Trim();
eChild.Add(ex);
if (i == dt.Rows.Count - 1)//最後一筆
{
e.children = eChild;
eList.Add(e);
}
}
else
{
if (i > 0)
{
e.children = eChild;
eList.Add(e);
e = new TooL();
eChild = new List <Children>();
e.key = "replaceStr";
if (languageType.ToString().Trim() != "")
{
e.title = Convert.ToDateTime(dt.Rows[i]["main_createdate"].ToString().Trim()).GetDateTimeFormats('r')[0].ToString();
}
else
{
e.title = Convert.ToDateTime(dt.Rows[i]["main_createdate"].ToString().Trim()).GetDateTimeFormats('f')[0].ToString();
}
e.isFolder = true;
e.isLazy = true;
e.noLink = false;
Children ex = new Children();
ex.key = dt.Rows[i]["sender_mail"].ToString().Trim();
ex.title = dt.Rows[i]["sender_mail"].ToString().Trim();
ex.isempno = dt.Rows[i]["sender_isempno"].ToString().Trim();
eChild.Add(ex);
if (i == dt.Rows.Count - 1)//最後一筆
{
e.children = eChild;
eList.Add(e);
}
}
else
{
e.key = "replaceStr";
if (languageType.ToString().Trim() != "")
{
e.title = Convert.ToDateTime(dt.Rows[i]["main_createdate"].ToString().Trim()).GetDateTimeFormats('r')[0].ToString();
}
else
{
e.title = Convert.ToDateTime(dt.Rows[i]["main_createdate"].ToString().Trim()).GetDateTimeFormats('f')[0].ToString();
}
e.isFolder = true;
e.isLazy = true;
e.noLink = false;
//因為不等於 所以是新的GROUP
Children ex = new Children();
ex.key = dt.Rows[i]["sender_mail"].ToString().Trim();
ex.title = dt.Rows[i]["sender_mail"].ToString().Trim();
ex.isempno = dt.Rows[i]["sender_isempno"].ToString().Trim();
eChild.Add(ex);
if (dt.Rows.Count == 1)
{
e.children = eChild;
eList.Add(e);
}
}
}
createdate = dt.Rows[i]["main_createdate"].ToString().Trim();
}
System.Web.Script.Serialization.JavaScriptSerializer objSerializer = new System.Web.Script.Serialization.JavaScriptSerializer();
ans = objSerializer.Serialize(eList); //new
}
else
{
if (languageType.ToString().Trim() != "")
{
ans = "[ { \"title\": \"No Records\", \"isFolder\": false, \"key\": \"replaceStr\", \"noLink\": true, \"hideCheckbox\": true} ]";
}
else
{
ans = "[ { \"title\": \"查無紀錄\", \"isFolder\": false, \"key\": \"replaceStr\", \"noLink\": true, \"hideCheckbox\": true} ]";
}
}
context.Response.ContentType = "application/json";
context.Response.Write(ans);
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
