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);
}
