public DataTable getEventRewards(string event_no, out THC_Library.Error error) { error = null; DataTable resultTable = null; IList <SqlParameter> paraList = new System.Collections.Generic.List <SqlParameter>(); string strSQL = "select AEP001,AEP002,AEP003,AEP004,AEP005,AEP006,AEP007,AEP009,AEP011,AEP012,AEP013 " + //(SUBSTRING(AEP013,0,20) + '.....') as AEP013 " + "from activity_rewards where AEP002=@AEP002"; paraList.Add(new SqlParameter("@AEP002", event_no)); DataBaseControl dbCtl = new DataBaseControl(); try { dbCtl.Open(); resultTable = dbCtl.GetDataTable(strSQL, paraList); } catch (Exception ex) { error = new THC_Library.Error(); error.Number = THC_Library.THCException.SYSTEM_ERROR; error.ErrorMessage = ex.Message; } finally { dbCtl.Close(); } return(resultTable); }
public JsonResult THC_AnsyActivity(string authkey) { THC_Library.Error error = null; string strTick = Request.Headers["QPID-TICK"]; string strData = Request.Headers["QPID-DATA"]; error = WebTHCAPP.Models.RequestChecker.CheckRequest(strTick, strData); Models.ResultBase result = new Models.ResultBase(); result.Number = 0; result.ErrorMessage = ""; if (error == null) { var reqActivity = Request.Form["activity"]; Models.Activity activity = new Models.Activity(); activity.asyncActivity(reqActivity, out error); } if (error != null) { result.Number = error.Number; result.ErrorMessage = error.ErrorMessage; } return(Json(result, "application/json", JsonRequestBehavior.AllowGet)); }
public DataTable getUserInfo(string account, out THC_Library.Error error) { error = null; DataTable resultTable = null; IList <SqlParameter> paraList = new System.Collections.Generic.List <SqlParameter>(); string strSQL = "select AU001,AU002,AU003,AU004 from activity_user where AU001=@AU001"; paraList.Add(new SqlParameter("@AU001", account)); DataBaseControl dbCtl = new DataBaseControl(); try { dbCtl.Open(); resultTable = dbCtl.GetDataTable(strSQL, paraList); } catch (Exception ex) { error = new THC_Library.Error(); error.Number = THC_Library.THCException.SYSTEM_ERROR; error.ErrorMessage = ex.Message; } finally { dbCtl.Close(); } return(resultTable); }
public void updateEvent(string event_no, string page, out THC_Library.Error error) { error = null; SqlParameter sqlParam; IList <SqlParameter> paraList = new System.Collections.Generic.List <SqlParameter>(); string strSQL = "update activity_event set AE013=@AE013 where AE002=@AE002"; DataBaseControl dbCtl = new DataBaseControl(); try { sqlParam = new SqlParameter("@AE013", SqlDbType.VarChar); sqlParam.Value = page; paraList.Add(sqlParam); sqlParam = new SqlParameter("@AE002", SqlDbType.NVarChar); sqlParam.Value = event_no; paraList.Add(sqlParam); dbCtl.Open(); dbCtl.ExecuteCommad(strSQL, paraList); } catch (Exception ex) { error = new THC_Library.Error(); error.Number = THC_Library.THCException.SYSTEM_ERROR; error.ErrorMessage = ex.Message; } finally { dbCtl.Close(); } }
public int deleteUser(string account, out THC_Library.Error error) { error = null; int iExcuteCount = -1; IList <SqlParameter> paraList = new System.Collections.Generic.List <SqlParameter>(); string strSQL = "delete from activity_user where AU001=@AU001"; paraList.Add(new SqlParameter("@AU001", account)); DataBaseControl dbCtl = new DataBaseControl(); try { dbCtl.Open(); iExcuteCount = dbCtl.ExecuteCommad(strSQL, paraList); } catch (Exception ex) { error = new THC_Library.Error(); error.Number = THC_Library.THCException.SYSTEM_ERROR; error.ErrorMessage = ex.Message; } finally { dbCtl.Close(); } return(iExcuteCount); }
public static THC_Library.Error CheckRequest(string tick, string data) { THC_Library.Error error = null; if (tick == null) { error = new THC_Library.Error(); error.Number = 401; error.ErrorMessage = "無效存取"; } if (data == null) { error = new THC_Library.Error(); error.Number = 402; error.ErrorMessage = "無效存取"; } tick = THC_Library.APPCURL.Encry(tick); if (data != tick) { error = new THC_Library.Error(); error.Number = 403; error.ErrorMessage = "無效存取"; } return(error); }
public DataTable getScanCount_InDay_7(string event_no, out THC_Library.Error error) { error = null; DataTable resultTable = null; DateTime datNow = DateTime.Now; IList <SqlParameter> paraList = new System.Collections.Generic.List <SqlParameter>(); string strSQL = "select count(EUR003) as VALUE, CAST(EUR004 AS DATE) as DATE from event_user_records " + "where EUR002=@EUR002 and DATEDIFF(day,EUR004,GETDATE()) < 7 " + "group by CAST(EUR004 AS DATE)"; paraList.Add(new SqlParameter("@EUR002", event_no)); DataBaseControl dbCtl = new DataBaseControl(); try { dbCtl.Open(); resultTable = dbCtl.GetDataTable(strSQL, paraList); } catch (Exception ex) { error = new THC_Library.Error(); error.Number = THC_Library.THCException.SYSTEM_ERROR; error.ErrorMessage = ex.Message; } finally { dbCtl.Close(); } return(resultTable); }
public DataTable getTimeTemptrue(string event_no, string days, out THC_Library.Error error) { error = null; DataTable resultTable = null; IList <SqlParameter> paraList = new System.Collections.Generic.List <SqlParameter>(); string strSQL = "select CAST(EUR004 AS DATE) as DATE,AVG(EUR009) as TEMP,count(*) as COUNT from event_user_records " + "where EUR002=@EUR002 and DATEDIFF(day,EUR004,GETDATE()) < " + days + " " + "group by CAST(EUR004 AS DATE)"; paraList.Add(new SqlParameter("@EUR002", event_no)); DataBaseControl dbCtl = new DataBaseControl(); try { dbCtl.Open(); resultTable = dbCtl.GetDataTable(strSQL, paraList); } catch (Exception ex) { error = new THC_Library.Error(); error.Number = THC_Library.THCException.SYSTEM_ERROR; error.ErrorMessage = ex.Message; } finally { dbCtl.Close(); } return(resultTable); }
public void clearLoginTime(string account, out THC_Library.Error error) { error = null; IList <SqlParameter> paraList = new System.Collections.Generic.List <SqlParameter>(); string strSQL = "update activity_user set AU004=NULL where AU001=@AU001"; paraList.Add(new SqlParameter("@AU001", account)); DataBaseControl dbCtl = new DataBaseControl(); try { dbCtl.Open(); dbCtl.ExecuteCommad(strSQL, paraList); } catch (Exception ex) { error = new THC_Library.Error(); error.Number = THC_Library.THCException.SYSTEM_ERROR; error.ErrorMessage = ex.Message; } finally { dbCtl.Close(); } }
public DataTable getScanGender(string event_no, out THC_Library.Error error) { error = null; DataTable resultTable = null; IList <SqlParameter> paraList = new System.Collections.Generic.List <SqlParameter>(); string strSQL = "select EUR007 as GENDER,count(EUR003) as VALUE from event_user_records " + "where EUR002=@EUR002 group by EUR007"; paraList.Add(new SqlParameter("@EUR002", event_no)); DataBaseControl dbCtl = new DataBaseControl(); try { dbCtl.Open(); resultTable = dbCtl.GetDataTable(strSQL, paraList); } catch (Exception ex) { error = new THC_Library.Error(); error.Number = THC_Library.THCException.SYSTEM_ERROR; error.ErrorMessage = ex.Message; } finally { dbCtl.Close(); } return(resultTable); }
public DataTable getWeather(out THC_Library.Error error) { error = null; DataTable resultTable = null; IList <SqlParameter> paraList = new System.Collections.Generic.List <SqlParameter>(); string strSQL = "select * from weather"; DataBaseControl dbCtl = new DataBaseControl(); try { dbCtl.Open(); resultTable = dbCtl.GetDataTable(strSQL, paraList); } catch (Exception ex) { error = new THC_Library.Error(); error.Number = THC_Library.THCException.SYSTEM_ERROR; error.ErrorMessage = ex.Message; } finally { dbCtl.Close(); } return(resultTable); }
public DataTable getMyEvent(string event_no, out THC_Library.Error error) { error = null; DataTable resultTable = null; IList <SqlParameter> paraList = new System.Collections.Generic.List <SqlParameter>(); string strSQL = "select * from activity_event where AE002=@AE002"; paraList.Add(new SqlParameter("@AE002", event_no)); DataBaseControl dbCtl = new DataBaseControl(); try { dbCtl.Open(); resultTable = dbCtl.GetDataTable(strSQL, paraList); } catch (Exception ex) { error = new THC_Library.Error(); error.Number = THC_Library.THCException.SYSTEM_ERROR; error.ErrorMessage = ex.Message; } finally { dbCtl.Close(); } return(resultTable); }
public void Send(string acc, string access_code, string mydomain, out THC_Library.Error error) { error = null; MailMessage mms = new MailMessage(); mms.From = new MailAddress("*****@*****.**"); mms.Subject = "THC宏全QPID密碼變更通知"; //信件內容 mms.Body = "請點選以下連結修改密碼<br/>" + string.Format("{0}WebTHCApp/Members/AccessRestPassword?acc={1}&access={2}", mydomain, acc, access_code); mms.IsBodyHtml = true; mms.BodyEncoding = System.Text.Encoding.UTF8; //mms.To.Add("*****@*****.**"); mms.To.Add(acc); using (SmtpClient client = new SmtpClient("smtp.gmail.com", 587)) { try { client.EnableSsl = true; client.UseDefaultCredentials = false; client.DeliveryMethod = SmtpDeliveryMethod.Network; client.Credentials = new System.Net.NetworkCredential("*****@*****.**", "Qpid_58176511"); //Qpid58176511 client.Send(mms); } catch (Exception ex) { error = new THC_Library.Error(); error.Number = 900; error.ErrorMessage = "發信服務系統錯誤"; } } }
public void AsyneEvent(string event_no, out THC_Library.Error error) { error = null; IList <SqlParameter> paraList = new System.Collections.Generic.List <SqlParameter>(); string strSQL = "select * from activity_event where AE002=@AE002"; paraList.Add(new SqlParameter("@AE002", event_no)); DataBaseControl dbCtl = new DataBaseControl(); try { dbCtl.Open(); DataTable eventTable = dbCtl.GetDataTable(strSQL, paraList); string eventJson = Newtonsoft.Json.JsonConvert.SerializeObject(eventTable); string jsonResult = THC_Library.APPCURL.AnscyActivity(eventJson); dynamic resultObj = Newtonsoft.Json.JsonConvert.DeserializeObject(jsonResult); if (resultObj.Number != 0) { throw new Exception(resultObj.ErrorMessage.ToString()); } } catch (Exception ex) { error = new THC_Library.Error(); error.Number = THC_Library.THCException.SYSTEM_ERROR; error.ErrorMessage = ex.Message; } finally { dbCtl.Close(); } }
public void changePassword(string account, string old, string new1, string new2, out THC_Library.Error error) { error = null; byte[] pwdBytes = System.Text.Encoding.Default.GetBytes(old); System.Security.Cryptography.MD5 md5 = System.Security.Cryptography.MD5.Create(); pwdBytes = md5.ComputeHash(pwdBytes); string strOldPwd = Convert.ToBase64String(pwdBytes); pwdBytes = System.Text.Encoding.Default.GetBytes(new1); md5 = System.Security.Cryptography.MD5.Create(); pwdBytes = md5.ComputeHash(pwdBytes); string strNewPwd = Convert.ToBase64String(pwdBytes); IList <SqlParameter> paraList = new System.Collections.Generic.List <SqlParameter>(); string strSQL = "select AU003 from activity_user where AU001=@AU001"; paraList.Add(new SqlParameter("@AU001", account)); DataBaseControl dbCtl = new DataBaseControl(); try { if (new1 != new2) { throw new Exception("新密碼不相符"); } dbCtl.Open(); IDataReader dataReader = dbCtl.GetReader(strSQL, paraList); dataReader.Read(); string strOld = dataReader["AU003"].ToString(); dataReader.Close(); if (strOldPwd != strOld) { throw new Exception("舊密碼輸入錯誤"); } strSQL = "update activity_user set AU003=@AU003 where AU001=@AU001"; paraList.Clear(); paraList.Add(new SqlParameter("@AU003", strNewPwd)); paraList.Add(new SqlParameter("@AU001", account)); dbCtl.ExecuteCommad(strSQL, paraList); } catch (Exception ex) { error = new THC_Library.Error(); error.Number = THC_Library.THCException.SYSTEM_ERROR; error.ErrorMessage = ex.Message; } finally { dbCtl.Close(); } }
public JsonResult THC_Member_02_1() { THC_Library.Error error = null; string strTick = Request.Headers["QPID-TICK"]; string strData = Request.Headers["QPID-DATA"]; error = WebTHCAPP.Models.RequestChecker.CheckRequest(strTick, strData); Models.ResultWithInfo result = new Models.ResultWithInfo(); if (error == null) { var reqMail = Request.Form["mail"]; var reqPwd = Request.Form["pwd"]; int state; string name, mobil, addr, iid, gender, age; Models.Member member = new Models.Member(); long lgTimestamp = member.verifyAccountWitInfo(reqMail, reqPwd, out state, out name, out mobil, out addr, out iid, out gender, out age, out error); if (lgTimestamp > -1) { result.Verify = 1; result.Ticket = lgTimestamp.ToString(); result.Acc = reqMail; result.Name = name; result.Mobil = mobil; result.Addr = addr; result.IId = iid; result.Gender = gender; result.Age = age; } else { result.Ticket = lgTimestamp.ToString(); result.Number = 10; result.Verify = 0; if (state == 1) { result.ErrorMessage = "帳號不存在"; } else if (state == 2) { result.ErrorMessage = "密碼錯誤"; } else { result.ErrorMessage = "登入錯誤"; } } } if (error != null) { result.Number = error.Number; result.ErrorMessage = error.ErrorMessage; } return(Json(result, "application/json", JsonRequestBehavior.AllowGet)); }
public int updateUser(string account, string name, string access_code, out THC_Library.Error error) { error = null; int iExcuteCount = -1; IList <SqlParameter> paraList = new System.Collections.Generic.List <SqlParameter>(); string strSQL = "select AU003 from activity_user where AU001=@AU001"; paraList.Add(new SqlParameter("@AU001", account)); DataBaseControl dbCtl = new DataBaseControl(); try { dbCtl.Open(); IDataReader dataReader = dbCtl.GetReader(strSQL, paraList); dataReader.Read(); string orgPassword = dataReader["AU003"].ToString(); dataReader.Close(); if (orgPassword == access_code) { strSQL = "update activity_user set AU002=@AU002 where AU001=@AU001"; paraList.Clear(); paraList.Add(new SqlParameter("@AU002", name)); paraList.Add(new SqlParameter("@AU001", account)); } else { byte[] pwdBytes = System.Text.Encoding.Default.GetBytes(access_code); System.Security.Cryptography.MD5 md5 = System.Security.Cryptography.MD5.Create(); pwdBytes = md5.ComputeHash(pwdBytes); string strPwd = Convert.ToBase64String(pwdBytes); strSQL = "update activity_user set AU002=@AU002,AU003=@AU003 where AU001=@AU001"; paraList.Clear(); paraList.Add(new SqlParameter("@AU002", name)); paraList.Add(new SqlParameter("@AU003", strPwd)); paraList.Add(new SqlParameter("@AU001", account)); } iExcuteCount = dbCtl.ExecuteCommad(strSQL, paraList); } catch (Exception ex) { error = new THC_Library.Error(); error.Number = THC_Library.THCException.SYSTEM_ERROR; error.ErrorMessage = ex.Message; } finally { dbCtl.Close(); } return(iExcuteCount); }
/// <summary> /// 參與率次數比例 /// </summary> public DataTable getScanRate(string event_no, string counter, out string total, out THC_Library.Error error) { error = null; total = ""; //select EUR005,count(EUR005) as cc from event_user_records //where EUR002=1033 //group by EUR005 //having count(EUR005) > 2 error = null; DataTable resultTable = null; IList <SqlParameter> paraList = new System.Collections.Generic.List <SqlParameter>(); string strSQL = "select EUR005 as acc,count(EUR005) as cc,CM007 as tel from event_user_records " + "left join consumer_member on EUR005=CM002 " + "where EUR002=@EUR002 group by EUR005,CM007 having count(EUR005) >= @counter " + "order by cc"; paraList.Add(new SqlParameter("@EUR002", event_no)); paraList.Add(new SqlParameter("@counter", counter)); DataBaseControl dbCtl = new DataBaseControl(); try { dbCtl.Open(); resultTable = dbCtl.GetDataTable(strSQL, paraList); strSQL = "select count(distinct EUR005) from event_user_records where EUR002=@EUR002"; paraList.Clear(); paraList.Add(new SqlParameter("@EUR002", event_no)); IDataReader dataReader = dbCtl.GetReader(strSQL, paraList); dataReader.Read(); total = dataReader[0].ToString(); dataReader.Close(); } catch (Exception ex) { error = new THC_Library.Error(); error.Number = THC_Library.THCException.SYSTEM_ERROR; error.ErrorMessage = ex.Message; } finally { dbCtl.Close(); } return(resultTable); return(null); }
public void ClearEvent(string event_no, out THC_Library.Error error) { error = null; IList <SqlParameter> paraList = new System.Collections.Generic.List <SqlParameter>(); string strSQL = "select AE001 from activity_event where AE002=@AE002"; paraList.Add(new SqlParameter("@AE002", event_no)); DataBaseControl dbCtl = new DataBaseControl(); try { dbCtl.Open(); IDataReader dataReader = dbCtl.GetReader(strSQL, paraList); dataReader.Read(); string eventKey = dataReader[0].ToString(); dataReader.Close(); paraList.Clear(); strSQL = "update qr_record set QRC012=0,QRC013=NULL,QRC014=NULL,QRC016=NULL " + "where QRC002=@QRC002;delete from event_user_records where EUR003=@EUR003"; paraList.Add(new SqlParameter("@QRC002", event_no)); paraList.Add(new SqlParameter("@EUR003", event_no)); dbCtl.BeginTransaction(); string jsonResult = THC_Library.APPCURL.ClearRecordLogActivity(eventKey); dynamic resultObj = Newtonsoft.Json.JsonConvert.DeserializeObject(jsonResult); if (resultObj.Number != 0) { throw new Exception(resultObj.ErrorMessage.ToString()); } dbCtl.ExecuteCommad(strSQL, paraList); dbCtl.CommintTransaction(); } catch (Exception ex) { dbCtl.RollBackTransaction(); error = new THC_Library.Error(); error.Number = THC_Library.THCException.SYSTEM_ERROR; error.ErrorMessage = ex.Message; } finally { dbCtl.Close(); } }
public JsonResult THC_Member_03() { THC_Library.Error error = null; string strTick = Request.Headers["QPID-TICK"]; string strData = Request.Headers["QPID-DATA"]; error = WebTHCAPP.Models.RequestChecker.CheckRequest(strTick, strData); Models.Result result = new Models.Result(); if (error == null) { string regActivity = Request.Form["ac"]; string regCode = Request.Form["code"]; string regMail = Request.Form["fb"]; string regName = Request.Form["name"]; string regGender = Request.Form["gender"]; string strAccount; Models.Member member = new Models.Member(); long lgTimestamp = member.verifyFaceBookAccount(regMail, regName, regGender, out strAccount, out error); if (lgTimestamp > -1) { result.Verify = 1; result.Ticket = lgTimestamp.ToString(); result.Acc = strAccount; //retJson = string.Format("[{{ \"VERIFY\" : 1 , \"TICKET\" : \"{0}\" , \"ACC\" : \"{1}\" }} ]", // lgTimestamp, strAccount); } else { result.Ticket = lgTimestamp.ToString(); result.Number = 10; result.Verify = 0; result.ErrorMessage = "登入錯誤"; //retJson = "[{ \"VERIFY\" : 0 , \"MESSAGE\" : \"登入錯誤\"} ]"; } } if (error != null) { result.Number = error.Number; result.ErrorMessage = error.ErrorMessage; } return(Json(result, "application/json", JsonRequestBehavior.AllowGet)); }
public void getScanRate(string event_no, out float scan, out float total, out float rate, out THC_Library.Error error) { error = null; scan = 0; total = 0; rate = 0; IDataReader dataReader; IList <SqlParameter> paraList = new System.Collections.Generic.List <SqlParameter>(); string strSQL = "select count(*) from qr_record where QRC002=@QRC002 and QRC013 is not NULL"; paraList.Add(new SqlParameter("@QRC002", event_no)); DataBaseControl dbCtl = new DataBaseControl(); try { dbCtl.Open(); dataReader = dbCtl.GetReader(strSQL, paraList); dataReader.Read(); scan = float.Parse(dataReader[0].ToString()); dataReader.Close(); paraList.Clear(); strSQL = "select AE007 from activity_event where AE002=@AE002"; paraList.Add(new SqlParameter("@AE002", event_no)); dataReader = dbCtl.GetReader(strSQL, paraList); dataReader.Read(); total = float.Parse(dataReader[0].ToString()); dataReader.Close(); rate = (float)Math.Round((double)(scan / total), 4); } catch (Exception ex) { error = new THC_Library.Error(); error.Number = THC_Library.THCException.SYSTEM_ERROR; error.ErrorMessage = ex.Message; } finally { dbCtl.Close(); } }
public JsonResult THC_Member_01() { THC_Library.Error error = null; long timeStamp = 0; int newKey = -1; string strTick = Request.Headers["QPID-TICK"]; string strData = Request.Headers["QPID-DATA"]; error = WebTHCAPP.Models.RequestChecker.CheckRequest(strTick, strData); Models.Result result = new Models.Result(); if (error == null) { var reqMail = Request.Form["mail"]; var reqPwd = Request.Form["pwd"]; var reqMobil = Request.Form["mobil"]; var strAccount = Request.Form["acc"]; var reqGender = Request.Form["gender"]; var reqAge = Request.Form["age"]; Models.Member member = new Models.Member(); newKey = member.newAccount(strAccount, reqMail, reqMobil, reqPwd, reqGender, reqAge, out timeStamp, out error); result.Addition = newKey.ToString(); result.Ticket = timeStamp.ToString(); result.Acc = strAccount; result.Number = 0; //retJson = string.Format("[{{ \"NewId\" : {0}, \"TICKET\" : \"{1}\" , \"ACC\" : \"{2}\" }} ]", // newKey, timeStamp, strAccount); } if (error != null) { result.Number = error.Number; result.ErrorMessage = error.ErrorMessage; //retJson = Newtonsoft.Json.JsonConvert.SerializeObject(error); } return(Json(result, "application/json", JsonRequestBehavior.AllowGet)); }
public DataTable getRewardEarnList(string event_no, out THC_Library.Error error) { //: "QRC001", bVisible: false }, //{ "title": "序號", "data": "QRC004", bVisible: true }, //{ "title": "獎項碼", "data": "QRC008", bVisible: true }, //{ "title": "獎項名稱", "data": "QRC011", bVisible: true }, //{ "title": "掃描時間", "data": "QRC013", bVisible: true }, //{ "title": "實際碼", "data": "QRC015", bVisible: true }, //{ "title": "得獎帳號", "data": "QRC016", bVisible: true } error = null; DataTable resultTable = null; IList <SqlParameter> paraList = new System.Collections.Generic.List <SqlParameter>(); string strSQL = "select QRC001,QRC004,QRC008,QRC011,QRC013,QRC015,QRC016 from qr_record " + "where QRC002=@QRC002 and QRC016 IS NOT NULL"; SqlParameter sqlParam = new SqlParameter("@QRC002", SqlDbType.NVarChar); sqlParam.Value = event_no; paraList.Add(sqlParam); DataBaseControl dbCtl = new DataBaseControl(); try { dbCtl.Open(); resultTable = dbCtl.GetDataTable(strSQL, paraList); } catch (Exception ex) { error = new THC_Library.Error(); error.Number = THC_Library.THCException.SYSTEM_ERROR; error.ErrorMessage = ex.Message; } finally { dbCtl.Close(); } return(resultTable); }
public JsonResult THC_Member_04() { THC_Library.Error error = null; string strTick = Request.Headers["QPID-TICK"]; string strData = Request.Headers["QPID-DATA"]; error = WebTHCAPP.Models.RequestChecker.CheckRequest(strTick, strData); Models.Result result = new Models.Result(); if (error == null) { var reqMail = Request.Form["ml"]; var reqTicket = Request.Form["tk"]; var reqMobil = Request.Form["m"]; var reqIId = Request.Form["iid"]; var reqAddr = Request.Form["addr"]; Models.Member member = new Models.Member(); int iRowCount = member.updateAccount(reqMail, reqTicket, reqMobil, reqIId, reqAddr, null, out error); if (iRowCount > 0) { result.Verify = 1; result.Addition = iRowCount.ToString(); } else { result.Number = 20; result.Verify = 0; result.ErrorMessage = "資料未更新錯誤"; } } if (error != null) { result.Number = error.Number; result.ErrorMessage = error.ErrorMessage; } return(Json(result, "application/json", JsonRequestBehavior.AllowGet)); }
public DataTable exportRewardEarn(string event_no, out THC_Library.Error error) { error = null; DataTable resultTable = null; IList <SqlParameter> paraList = new System.Collections.Generic.List <SqlParameter>(); string strSQL = "select QRC001,QRC004,QRC008,QRC011,QRC013,QRC015,QRC016 from qr_record " + "where QRC002=@QRC002 and QRC016 IS NOT NULL"; SqlParameter sqlParam = new SqlParameter("@QRC002", SqlDbType.NVarChar); sqlParam.Value = event_no; paraList.Add(sqlParam); DataBaseControl dbCtl = new DataBaseControl(); try { dbCtl.Open(); resultTable = dbCtl.GetDataTable(strSQL, paraList); //foreach (DataRow row in resultTable.Rows) //{ //} } catch (Exception ex) { error = new THC_Library.Error(); error.Number = THC_Library.THCException.SYSTEM_ERROR; error.ErrorMessage = ex.Message; } finally { dbCtl.Close(); } return(resultTable); }
//login from activity //[HttpPost] public ActionResult THC_Member_07(string acc, string evt, string tk) { THC_Library.Error error = null; //string strTick = Request.Headers["QPID-TICK"]; //string strData = Request.Headers["QPID-DATA"]; //error = WebTHCAPP.Models.RequestChecker.CheckRequest(strTick, strData); Models.Result result = new Models.Result(); if (string.IsNullOrEmpty(acc) || string.IsNullOrEmpty(evt) || string.IsNullOrEmpty(tk)) { return(View("../Error/NotAllow")); } Models.Member member = new Models.Member(); long newTicket = member.loginFromActivity(acc, tk, out error); if (error == null) { Models.AppSession appSession = new Models.AppSession(); appSession.Account = acc; appSession.EventNo = int.Parse(evt); appSession.Ticket = newTicket; Session["tk"] = appSession; ViewBag.ACC = acc; ViewBag.TICKET = newTicket; return(View("../App/index")); } else { //result.Number = error.Number; //result.Verify = 0; //result.ErrorMessage = error.ErrorMessage; ViewBag.NUMBER = error.Number; ViewBag.ERROR = error.ErrorMessage; return(View("../Error/SystemError")); } }
public JsonResult THC_Member_05() { THC_Library.Error error = null; string strTick = Request.Headers["QPID-TICK"]; string strData = Request.Headers["QPID-DATA"]; error = WebTHCAPP.Models.RequestChecker.CheckRequest(strTick, strData); Models.Result result = new Models.Result(); if (error == null) { var reqAcc = Request.Form["acc"]; var reqTicket = Request.Form["tk"]; Models.Member member = new Models.Member(); Models.AccountInfo accInfo = member.getAccountInfo(reqAcc, reqTicket, out error); if (accInfo != null) { return(Json(accInfo, "application/json", JsonRequestBehavior.AllowGet)); //retJson = string.Format("[{{ \"VERIFY\" : 1, \"COUNT\" : \"{0}\" }} ]", // iRowCount); } else { result.Number = 22; result.Verify = 0; result.ErrorMessage = "無效登入"; //retJson = "[{ \"VERIFY\" : 0 , \"MESSAGE\" : \"資料未更新錯誤\"} ]"; } } if (error != null) { result.Number = error.Number; result.ErrorMessage = error.ErrorMessage; } return(Json(result, "application/json", JsonRequestBehavior.AllowGet)); }
public ActionResult load2(string acc, string tk) { if (string.IsNullOrEmpty(acc) || string.IsNullOrEmpty(tk)) { return(View("")); } THC_Library.Error error = null; Models.Member member = new Models.Member(); long newTicket = member.loginFromActivity(acc, tk, out error); if (error != null) { ViewBag.TICKET = newTicket; return(View("index")); } else { return(View()); } }
public int updateRewardInfo(string reward_key, string name, string memo, string vender, string img, string vdate, string sms, out THC_Library.Error error) { error = null; int iAffrect = 0; IList <SqlParameter> paraList = new System.Collections.Generic.List <SqlParameter>(); string strSQL = "update activity_rewards set AEP005=@AEP005,AEP007=@AEP007,AEP009=@AEP009,AEP011=@AEP011,AEP012=@AEP012,AEP013=@AEP013 " + "where AEP001=@AEP001"; paraList.Add(new SqlParameter("@AEP005", name)); paraList.Add(new SqlParameter("@AEP007", memo)); paraList.Add(new SqlParameter("@AEP009", vender)); paraList.Add(new SqlParameter("@AEP011", img)); paraList.Add(new SqlParameter("@AEP012", vdate)); paraList.Add(new SqlParameter("@AEP013", sms)); paraList.Add(new SqlParameter("@AEP001", reward_key)); DataBaseControl dbCtl = new DataBaseControl(); try { dbCtl.Open(); iAffrect = dbCtl.ExecuteCommad(strSQL, paraList); } catch (Exception ex) { error = new THC_Library.Error(); error.Number = THC_Library.THCException.SYSTEM_ERROR; error.ErrorMessage = ex.Message; } finally { dbCtl.Close(); } return(iAffrect); }
public DataTable getTimeCountByArea(string event_no, string days, out THC_Library.Error error) { // select CAST(EUR004 AS DATE) as DATE,count(*),WH004 as COUNT //from event_user_records left join weather on EUR008=WH001 // where EUR002=1024 and DATEDIFF(day,EUR004,GETDATE()) < 21 // group by CAST(EUR004 AS DATE), WH004 error = null; DataTable resultTable = null; IList <SqlParameter> paraList = new System.Collections.Generic.List <SqlParameter>(); string strSQL = "select CAST(EUR004 AS DATE) as DATE,count(*) as COUNT,WH004 as AREA " + "from event_user_records left join weather on EUR008=WH001 " + "where EUR002=@EUR002 and DATEDIFF(day,EUR004,GETDATE()) < " + days + " " + " group by CAST(EUR004 AS DATE), WH004 order by DATE"; paraList.Add(new SqlParameter("@EUR002", event_no)); DataBaseControl dbCtl = new DataBaseControl(); try { dbCtl.Open(); resultTable = dbCtl.GetDataTable(strSQL, paraList); } catch (Exception ex) { error = new THC_Library.Error(); error.Number = THC_Library.THCException.SYSTEM_ERROR; error.ErrorMessage = ex.Message; } finally { dbCtl.Close(); } return(resultTable); }