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 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 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 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);
}
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 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 int addNewAccount(string account, string name, string access_code, out THC_Library.Error error)
{
error = null;
int iExcuteCount = -1;
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);
IList <SqlParameter> paraList = new System.Collections.Generic.List <SqlParameter>();
string strSQL = "insert into activity_user (AU001,AU002,AU003) values (@AU001,@AU002,@AU003)";
paraList.Add(new SqlParameter("@AU001", account));
paraList.Add(new SqlParameter("@AU002", name));
paraList.Add(new SqlParameter("@AU003", strPwd));
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 DataTable enterVerify(string account, string access_code, out THC_Library.Error error)
{
error = null;
DataTable resultTable = null;
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);
IList <SqlParameter> paraList = new System.Collections.Generic.List <SqlParameter>();
string strSQL = "select AU001,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);
if (dataReader.Read())
{
string PWD = dataReader["AU003"].ToString();
dataReader.Close();
if (PWD != strPwd)
{
throw new Exception("請輸入正確的密碼");
}
}
else
{
dataReader.Close();
throw new Exception("請輸入正確的帳號");
}
strSQL = "update activity_user set AU004=@AU004 where AU001=@AU001";
paraList.Clear();
paraList.Add(new SqlParameter("@AU004", DateTime.Now));
paraList.Add(new SqlParameter("@AU001", account));
dbCtl.ExecuteCommad(strSQL, paraList);
if (account == "root.admin")
{
strSQL = "select AU001,AU002,AU004 from activity_user where AU001!='root.admin'";
paraList.Clear();
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 localFaceBookAccount(string mail, string name, string gender, out Error error)
{
error = null;
bool bHasAccount = false;
SqlParameter sqlParam;
IDataReader dataReader;
IList <SqlParameter> paraList = new System.Collections.Generic.List <SqlParameter>();
string strSQL = "select CM002 from consumer_member where CM003=@CM003";
DataBaseControl dbCtl = new DataBaseControl();
try
{
sqlParam = new SqlParameter("@CM003", mail);
paraList.Add(sqlParam);
dbCtl.Open();
dataReader = dbCtl.GetReader(strSQL, paraList);
if (dataReader.Read())
{
bHasAccount = true;
}
dataReader.Close();
if (bHasAccount)
{
}
else
{
//以FB註冊會員資料
strSQL = "insert into consumer_member (CM002,CM003,CM010) values " +
"(@CM002,@CM007,@CM010,@CM011);";
sqlParam = new SqlParameter("@CM002", mail);
paraList.Add(sqlParam);
sqlParam = new SqlParameter("@CM003", mail);
paraList.Add(sqlParam);
sqlParam = new SqlParameter("@CM010", SqlDbType.Char);
if (gender == null)
{
sqlParam.Value = "0";
}
else
{
sqlParam.Value = gender;
}
paraList.Add(sqlParam);
dbCtl.Open();
dbCtl.ExecuteCommad(strSQL, paraList);
}
}
catch (SqlException sqlEx)
{
error = new Error();
if (sqlEx.Number == 2601)
{
error.Number = 101;
error.ErrorMessage = "帳號已註冊";
}
else
{
error.Number = 100;
error.ErrorMessage = sqlEx.ToString(); //"系統錯誤";
}
}
catch (Exception ex)
{
error = new Error();
error.Number = 100;
error.ErrorMessage = ex.ToString();// "系統錯誤";
}
finally
{
dbCtl.Close();
}
}
public void updateRewardData(string act, string code, string ml, string tk, out THC_Library.Error error)
{
error = null;
SqlParameter sqlParam;
IDataReader dataReader;
IList <SqlParameter> paraList = new System.Collections.Generic.List <SqlParameter>();
DateTime datNow = DateTime.Now;
DataBaseControl dbCtl = new DataBaseControl();
string strSQL;
try
{
dbCtl.Open();
bool bLoginChecked = false;
strSQL = "select * from consumer_member where CM002=@CM002 and CM016=@CM016";
paraList.Clear();
paraList.Add(new SqlParameter("@CM002", ml));
paraList.Add(new SqlParameter("@CM016", tk));
dataReader = dbCtl.GetReader(strSQL, paraList);
if (dataReader.Read())
{
bLoginChecked = true;
}
dataReader.Close();
if (!bLoginChecked)
{
THC_Library.CodeRenderException codeException =
new THC_Library.CodeRenderException(THC_Library.CodeRenderException.LOGIN_INVALID, "無效登入");
throw codeException;
}
strSQL = "insert into event_user_records (EUR002,EUR003,EUR004,EUR005,EUR006) values " +
"(@EUR002,@EUR003,@EUR004,@EUR005,@EUR006);SELECT CAST(scope_identity() AS int);";
dbCtl.BeginTransaction();
paraList.Clear();
sqlParam = new SqlParameter("@EUR002", SqlDbType.Int);
sqlParam.Value = "";// eventKey;
paraList.Add(sqlParam);
sqlParam = new SqlParameter("@EUR003", SqlDbType.VarChar);
sqlParam.Value = code;
paraList.Add(sqlParam);
sqlParam = new SqlParameter("@EUR004", SqlDbType.DateTime);
sqlParam.Value = datNow;
paraList.Add(sqlParam);
sqlParam = new SqlParameter("@EUR005", SqlDbType.VarChar);
sqlParam.Value = "";
paraList.Add(sqlParam);
sqlParam = new SqlParameter("@EUR006", SqlDbType.VarChar);
sqlParam.Value = "";
paraList.Add(sqlParam);
object newId = dbCtl.ExecuteScalar(strSQL, paraList);
int iIdentityKey;
int.TryParse(newId.ToString(), out iIdentityKey);
////中獎
strSQL = "update qr_record set QRC012=QRC012+1, QRC013=@QRC013,QRC014=@QRC014,QRC016=@QRC016 where QRC015=@QRC015;";
paraList.Clear();
sqlParam = new SqlParameter("@QRC013", SqlDbType.DateTime);
sqlParam.Value = datNow;
paraList.Add(sqlParam);
sqlParam = new SqlParameter("@QRC014", SqlDbType.Int);
sqlParam.Value = newId;
paraList.Add(sqlParam);
sqlParam = new SqlParameter("@QRC016", SqlDbType.VarChar);
sqlParam.Value = ml;
paraList.Add(sqlParam);
sqlParam = new SqlParameter("@QRC015", SqlDbType.VarChar);
sqlParam.Value = code;
paraList.Add(sqlParam);
dbCtl.ExecuteCommad(strSQL, paraList);
dbCtl.CommintTransaction();
}
catch (Exception ex)
{
dbCtl.RollBackTransaction();
error = new THC_Library.Error();
error.Number = 300;
error.ErrorMessage = "";
}
finally
{
dbCtl.Close();
}
//dbCtl.BeginTransaction();
//string strSQL = "insert into event_user_records (EUR002,EUR003,EUR004,EUR005,EUR006) values " +
// "(@EUR002,@EUR003,@EUR004,@EUR005,@EUR006);SELECT CAST(scope_identity() AS int);";
//paraList.Clear();
//sqlParam = new SqlParameter("@EUR002", SqlDbType.Int);
//sqlParam.Value = eventKey;
//paraList.Add(sqlParam);
//sqlParam = new SqlParameter("@EUR003", SqlDbType.VarChar);
//sqlParam.Value = code;
//paraList.Add(sqlParam);
//sqlParam = new SqlParameter("@EUR004", SqlDbType.DateTime);
//sqlParam.Value = datNow;
//paraList.Add(sqlParam);
//sqlParam = new SqlParameter("@EUR005", SqlDbType.VarChar);
//sqlParam.Value = "";
//paraList.Add(sqlParam);
//sqlParam = new SqlParameter("@EUR006", SqlDbType.VarChar);
//sqlParam.Value = "";
//paraList.Add(sqlParam);
//object newId = dbCtl.ExecuteScalar(strSQL, paraList);
//int.TryParse(newId.ToString(), out iIdentityKey);
////中獎
//strSQL = "update qr_record set QRC012=QRC012+1, QRC013=@QRC013,QRC014=@QRC014,QRC016=@QRC016 where QRC015=@QRC015;";
//paraList.Clear();
//sqlParam = new SqlParameter("@QRC013", SqlDbType.DateTime);
//sqlParam.Value = datNow;
//paraList.Add(sqlParam);
//sqlParam = new SqlParameter("@QRC014", SqlDbType.Int);
//sqlParam.Value = newId;
//paraList.Add(sqlParam);
//sqlParam = new SqlParameter("@QRC016", SqlDbType.VarChar);
//sqlParam.Value = ml;
//paraList.Add(sqlParam);
//sqlParam = new SqlParameter("@QRC015", SqlDbType.VarChar);
//sqlParam.Value = code;
//paraList.Add(sqlParam);
//dbCtl.ExecuteCommad(strSQL, paraList);
}
public bool done(string ac, string code, string tk, string ml, string city, string lat, string lng,
string coupnumber, string logkey, out int event_key, out THC_Library.Error error)
{
error = null;
event_key = -1;
IDataReader dataReader;
SqlParameter sqlParam;
IList <SqlParameter> paraList = new System.Collections.Generic.List <SqlParameter>();
string strSQL = "select AE001,AE003 from activity_event where AE002=@AE002";
paraList.Add(new SqlParameter("@AE002", ac));
DataBaseControl dbCtl = new DataBaseControl();
DateTime datNow = DateTime.Now;
string eventName;
string mobil = "";
string gender = "";
string age = "";
bool bRightEvent = false;
try
{
dbCtl.Open();
dataReader = dbCtl.GetReader(strSQL, paraList);
if (dataReader.Read())
{
bRightEvent = true;
event_key = int.Parse(dataReader["AE001"].ToString());
eventName = dataReader["AE003"].ToString();
}
dataReader.Close();
if (!bRightEvent)
{
throw new THC_Library.CodeRenderException(THC_Library.CodeRenderException.INVAILD_ACTIVITY, "無效的活動");
}
//確認登入
bool bLoginChecked = false;
string jsonString = THC_Library.APPCURL.GetAccountInfo(ml, tk);
dynamic jsonResult = Newtonsoft.Json.JsonConvert.DeserializeObject(jsonString);
if (jsonResult.Number == 0)
{
//AccountInfo
bLoginChecked = true;
mobil = jsonResult.Mobil;
gender = jsonResult.Gender;
age = jsonResult.Age;
//addr = jsonResult.Address;
//iid = jsonResult.IId;
}
else
{
//Result
bLoginChecked = false;
}
if (!bLoginChecked)
{
THC_Library.CodeRenderException codeException =
new THC_Library.CodeRenderException(THC_Library.CodeRenderException.LOGIN_INVALID, "無效登入");
throw codeException;
}
//QRC009 char(1) 獎項型態
//QRC010 tinyint 獎項層級
//QRC011 nvarchar(20) 獎項名稱
//QRC012 int 掃描次數
//AEP003 char(1) 獎項型態
//AEP004 tinyint 獎項層級
//AEP005 nvarchar(20) 獎項名稱
//strSQL = "select QRC009,QRC011,QRC012,QRC013 from qr_record where QRC008=@QRC008 and QRC015=@QRC015";
strSQL = "select QRC008,QRC012,QRC013,AEP003,AEP004,AEP005,AEP011,AEP013,AEP014 " +
"from qr_record left join activity_rewards on QRC018=AEP001 " +
"where QRC008=@QRC008 and QRC015=@QRC015";
paraList.Clear();
paraList.Add(new SqlParameter("@QRC008", coupnumber));
paraList.Add(new SqlParameter("@QRC015", code));
dataReader = dbCtl.GetReader(strSQL, paraList);
string rwardType = "";
string rwardName = "";
string rwardImg = "";
string rwardEC = "";
string winDesc = "";
string SMSContent = "";
if (dataReader.Read())
{
rwardEC = dataReader["QRC008"].ToString();
rwardType = dataReader["AEP003"].ToString();
rwardImg = dataReader["AEP011"].ToString();
rwardName = dataReader["AEP005"].ToString();
SMSContent = dataReader["AEP013"].ToString();
winDesc = dataReader["AEP014"].ToString();
int iScanCounter = int.Parse(dataReader["QRC012"].ToString());
if (iScanCounter > 0)
{
DateTime lastTime;
DateTime.TryParse(dataReader["QRC013"].ToString(), out lastTime);
dataReader.Close();
THC_Library.CodeRenderException codeException =
new THC_Library.CodeRenderException(THC_Library.CodeRenderException.REPEAT_SCAN, lastTime.ToString("yyyy/MM/dd HH:mm"));
codeException.AdditionalMessage = lastTime.ToString("yyyy/MM/dd HH:mm");
throw codeException;
}
}
else
{
dataReader.Close();
THC_Library.CodeRenderException codeException =
new THC_Library.CodeRenderException(THC_Library.CodeRenderException.INVAILD_CODE, "無效的發碼");
throw codeException;
}
dataReader.Close();
//取得地區溫度與天氣代碼
Int16 iTemp = 15;
int iWeather = 3200;
if (city.Length > 0)
{
strSQL = "select WH002,WH003 from weather where WH001 like @WH001 + '%'";
paraList.Clear();
sqlParam = new SqlParameter("@WH001", SqlDbType.NVarChar);
sqlParam.Value = city;
paraList.Add(sqlParam);
dataReader = dbCtl.GetReader(strSQL, paraList);
if (dataReader.Read())
{
if (!Int16.TryParse(dataReader["WH002"].ToString(), out iTemp))
{
iTemp = 15;
}
if (!int.TryParse(dataReader["WH003"].ToString(), out iWeather))
{
iWeather = 3200;
}
}
dataReader.Close();
}
else
{
strSQL = "select WH002,WH003 from weather where WH001='平均'";
paraList.Clear();
dataReader = dbCtl.GetReader(strSQL, paraList);
if (dataReader.Read())
{
if (!Int16.TryParse(dataReader["WH002"].ToString(), out iTemp))
{
iTemp = 15;
}
}
dataReader.Close();
}
dbCtl.BeginTransaction();
strSQL = "insert into event_user_records (EUR002,EUR003,EUR004,EUR005,EUR006,EUR007,EUR008,EUR009,EUR010,EUR011,EUR012) values " +
"(@EUR002,@EUR003,@EUR004,@EUR005,@EUR006,@EUR007,@EUR008,@EUR009,@EUR010,@EUR011,@EUR012);" +
"SELECT CAST(scope_identity() AS int);";
paraList.Clear();
sqlParam = new SqlParameter("@EUR002", SqlDbType.Int);
sqlParam.Value = event_key;
paraList.Add(sqlParam);
sqlParam = new SqlParameter("@EUR003", SqlDbType.VarChar);
sqlParam.Value = code;
paraList.Add(sqlParam);
sqlParam = new SqlParameter("@EUR004", SqlDbType.DateTime);
sqlParam.Value = datNow;
paraList.Add(sqlParam);
sqlParam = new SqlParameter("@EUR005", SqlDbType.VarChar);
sqlParam.Value = ml; //帳號
paraList.Add(sqlParam);
sqlParam = new SqlParameter("@EUR006", SqlDbType.Char);
sqlParam.Value = age; //年紀
paraList.Add(sqlParam);
sqlParam = new SqlParameter("@EUR007", SqlDbType.Char);
sqlParam.Value = gender; //性別
paraList.Add(sqlParam);
sqlParam = new SqlParameter("@EUR008", SqlDbType.NVarChar);
sqlParam.Value = city; //地區
paraList.Add(sqlParam);
sqlParam = new SqlParameter("@EUR009", SqlDbType.SmallInt);
sqlParam.Value = iTemp; //溫度
paraList.Add(sqlParam);
sqlParam = new SqlParameter("@EUR010", SqlDbType.Int);
sqlParam.Value = iWeather; //天氣
paraList.Add(sqlParam);
sqlParam = new SqlParameter("@EUR011", SqlDbType.Float);
sqlParam.Value = lat; //緯度
paraList.Add(sqlParam);
sqlParam = new SqlParameter("@EUR012", SqlDbType.Float);
sqlParam.Value = lng; //經度
paraList.Add(sqlParam);
object newId = dbCtl.ExecuteScalar(strSQL, paraList);
//中獎
strSQL = "update qr_record set QRC012=QRC012+1, QRC013=@QRC013,QRC014=@QRC014,QRC016=@QRC016 where QRC015=@QRC015;";
paraList.Clear();
sqlParam = new SqlParameter("@QRC013", SqlDbType.DateTime);
sqlParam.Value = datNow;
paraList.Add(sqlParam);
sqlParam = new SqlParameter("@QRC014", SqlDbType.Int);
sqlParam.Value = newId;
paraList.Add(sqlParam);
sqlParam = new SqlParameter("@QRC016", SqlDbType.VarChar);
sqlParam.Value = ml;
paraList.Add(sqlParam);
sqlParam = new SqlParameter("@QRC015", SqlDbType.VarChar);
sqlParam.Value = code;
paraList.Add(sqlParam);
dbCtl.ExecuteCommad(strSQL, paraList);
dbCtl.CommintTransaction();
if (rwardType == "0")
{
//虛擬獎品 簡訊發送
char line = Convert.ToChar(6);
SMSContent = SMSContent.Replace("%s%", coupnumber);
SMSContent = SMSContent.Replace(System.Environment.NewLine, Convert.ToChar(6).ToString());
bool bSMS_OK = THC_Library.SMSHelper.SendTo(ml, mobil, SMSContent);
}
jsonString = THC_Library.APPCURL.ScanRecord(event_key.ToString(), code,
datNow.ToString(), ml, age, gender, city, iTemp.ToString(), iWeather.ToString(),
lat, lng, rwardName, rwardEC, rwardType, winDesc, tk);
jsonResult = Newtonsoft.Json.JsonConvert.DeserializeObject(jsonString);
//if (jsonResult.Number != 0)
//{
//}
}
catch (THC_Library.CodeRenderException codeex)
{
error = new THC_Library.Error();
error.Number = codeex.Number;
error.ErrorMessage = codeex.AdditionalMessage;
}
catch (Exception ex)
{
//dbCtl.RollBackTransaction();
error = new THC_Library.Error();
error.Number = THC_Library.THCException.SYSTEM_ERROR;
error.ErrorMessage = ex.ToString(); //"系統發生異常錯誤，請紀錄您的中獎序號，並與客服人員聯絡，我們會盡訊處理這問題。";
}
finally
{
dbCtl.Close();
}
return(true);
}
public bool go(string ac, string code, string tk, string ml, string city, string lat, string lng, out int event_no,
out string gender, out string age, out string mobil, out string iid, out string addr,
out THC_Library.Reward.RewardConvertor rwd, out int logkey, out THC_Library.Error error)
{
error = null;
rwd = null;
event_no = -1;
gender = "";
age = "";
mobil = "";
iid = "";
addr = "";
logkey = -1;
DateTime datNow = DateTime.Now;
DateTime datNowDate = new DateTime(datNow.Year, datNow.Month, datNow.Day);
//int iIdentityKey;
//int eventKey = -1;
string eventName = "";
DateTime startTime = DateTime.MaxValue;
DateTime endTime = DateTime.MinValue;
SqlParameter sqlParam;
IDataReader dataReader;
IList <SqlParameter> paraList = new System.Collections.Generic.List <SqlParameter>();
DataBaseControl dbCtl = new DataBaseControl();
//paraList.Add(new SqlParameter("@EQCH002", event_key));
string strSQL = "select * from activity_event where AE002=@AE002";
paraList.Add(new SqlParameter("@AE002", ac));
bool bRightEvent = false;
bool bKeyExist = false;
bool bWin = false;
try
{
dbCtl.Open();
dataReader = dbCtl.GetReader(strSQL, paraList);
if (dataReader.Read())
{
bRightEvent = true;
event_no = int.Parse(dataReader["AE001"].ToString());
eventName = dataReader["AE003"].ToString();
startTime = Convert.ToDateTime(dataReader["AE005"]);
endTime = Convert.ToDateTime(dataReader["AE006"]);
}
dataReader.Close();
if (!bRightEvent)
{
throw new THC_Library.CodeRenderException(THC_Library.CodeRenderException.INVAILD_ACTIVITY, "無效的活動");
}
else
{
if (startTime.Subtract(datNowDate).TotalDays > 0)
{
//未開始
THC_Library.CodeRenderException codeException =
new THC_Library.CodeRenderException(THC_Library.CodeRenderException.ACTIVITY_NOT_START, "活動尚未開始");
codeException.AdditionalMessage = string.Format("{0} 活動期間 {1} - {2}", eventName, startTime, endTime);
throw codeException;
}
if (endTime.Subtract(datNowDate).TotalDays < 0)
{
//結束
THC_Library.CodeRenderException codeException = new THC_Library.CodeRenderException(THC_Library.CodeRenderException.ACTIVITY_FINISHED, "活動已結束");
codeException.AdditionalMessage = string.Format("{0} 活動期間 {1} - {2}", eventName, startTime, endTime);
throw codeException;
}
}
//確認登入
bool bLoginChecked = false;
string jsonString = THC_Library.APPCURL.GetAccountInfo(ml, tk);
dynamic jsonResult = Newtonsoft.Json.JsonConvert.DeserializeObject(jsonString);
if (jsonResult.Number == 0)
{
//AccountInfo
bLoginChecked = true;
mobil = jsonResult.Mobil;
addr = jsonResult.Address;
iid = jsonResult.IId;
gender = jsonResult.Gender;
age = jsonResult.Age;
}
else
{
//Result
bLoginChecked = false;
}
if (!bLoginChecked)
{
THC_Library.CodeRenderException codeException =
new THC_Library.CodeRenderException(THC_Library.CodeRenderException.LOGIN_INVALID, "無效登入");
throw codeException;
}
//
//strSQL = "select * from qr_record where QRC015=@QRC015";
strSQL = "select qr_record.*,AEP003,AEP005,AEP007,AEP011,AEP012 " +
"from qr_record left join activity_rewards on QRC018=AEP001 where QRC015=@QRC015";
paraList.Clear();
paraList.Add(new SqlParameter("@QRC015", code));
dataReader = dbCtl.GetReader(strSQL, paraList);
object EC = "";
string rwdType = "";
if (dataReader.Read())
{
rwdType = dataReader["AEP003"].ToString();
int iScanCounter = int.Parse(dataReader["QRC012"].ToString());
if (iScanCounter == 0)
{
//未掃描過
//中獎與否
EC = dataReader["QRC008"];
if (EC != DBNull.Value && EC.ToString().Length > 0)
{
bWin = true;
THC_Library.Reward.RewardConvertor rwdConvertor;
if (dataReader["AEP003"].ToString() == "0")
{
//虛擬
rwdConvertor = new THC_Library.Reward.Edenred();
THC_Library.Reward.Edenred edenred = rwdConvertor as THC_Library.Reward.Edenred;
edenred.RewardName = dataReader["AEP005"].ToString(); //dataReader["QRC011"].ToString();
edenred.RewardType = THC_Library.Reward.RewardType.ElectricCoupon;
edenred.CouponNumber = EC.ToString();
if (dataReader["QRC018"] != DBNull.Value)
{
edenred.ValidPeriod = dataReader["AEP012"].ToString();
edenred.RewardImage = dataReader["AEP011"].ToString();
//string strJSon = dataReader["QRC017"].ToString();
//if (strJSon.Length > 0)
//{
// dynamic jsonReward = Newtonsoft.Json.JsonConvert.DeserializeObject(strJSon);
// edenred.ValidPeriod = jsonReward.v_date;
// edenred.RewardImage = jsonReward.img;
//}
}
}
else
{
//實體
rwdConvertor = new THC_Library.Reward.Phyicalenred();
THC_Library.Reward.Phyicalenred phyenred = rwdConvertor as THC_Library.Reward.Phyicalenred;
phyenred.RewardName = dataReader["AEP005"].ToString();
phyenred.RewardType = THC_Library.Reward.RewardType.PhyicalReward;
phyenred.CouponNumber = EC.ToString();
if (dataReader["QRC018"] != DBNull.Value)
{
phyenred.Description = dataReader["AEP007"].ToString();
phyenred.RewardImage = dataReader["AEP011"].ToString();
//string strJSon = dataReader["QRC017"].ToString();
//if (strJSon.Length > 0)
//{
// dynamic jsonReward = Newtonsoft.Json.JsonConvert.DeserializeObject(strJSon);
// phyenred.Description = jsonReward.desc;
// phyenred.RewardImage = jsonReward.img;
//}
}
}
rwd = rwdConvertor;
}
bKeyExist = true;
}
else
{
//重覆掃描
DateTime lastTime;
DateTime.TryParse(dataReader["QRC013"].ToString(), out lastTime);
dataReader.Close();
THC_Library.CodeRenderException codeException =
new THC_Library.CodeRenderException(THC_Library.CodeRenderException.REPEAT_SCAN, lastTime.ToString("yyyy/MM/dd HH:mm"));
codeException.AdditionalMessage = lastTime.ToString("yyyy/MM/dd HH:mm"); //string.Format("上次掃描時間 <br/>{0}", lastTime.ToString("MM/dd HH:mm:ss"));
throw codeException;
}
}
dataReader.Close();
if (!bKeyExist)
{
//掃描的 code 不再發行裡面
throw new THC_Library.CodeRenderException(THC_Library.CodeRenderException.INVAILD_CODE, "無效的發碼");
}
if (!bWin)
{
//取得地區溫度與天氣代碼
Int16 iTemp = 15;
int iWeather = 3200;
if (city.Length > 0)
{
strSQL = "select WH002,WH003 from weather where WH001 like @WH001 + '%'";
paraList.Clear();
sqlParam = new SqlParameter("@WH001", SqlDbType.NVarChar);
sqlParam.Value = city;
paraList.Add(sqlParam);
dataReader = dbCtl.GetReader(strSQL, paraList);
if (dataReader.Read())
{
if (!Int16.TryParse(dataReader["WH002"].ToString(), out iTemp))
{
iTemp = 15;
}
if (!int.TryParse(dataReader["WH003"].ToString(), out iWeather))
{
iWeather = 3200;
}
}
dataReader.Close();
}
else
{
strSQL = "select WH002,WH003 from weather where WH001='平均'";
paraList.Clear();
dataReader = dbCtl.GetReader(strSQL, paraList);
if (dataReader.Read())
{
if (!Int16.TryParse(dataReader["WH002"].ToString(), out iTemp))
{
iTemp = 15;
}
}
dataReader.Close();
}
dbCtl.BeginTransaction();
//未中獎 log 紀錄
strSQL = "insert into event_user_records (EUR002,EUR003,EUR004,EUR005,EUR006,EUR007,EUR008,EUR009,EUR010,EUR011,EUR012) values " +
"(@EUR002,@EUR003,@EUR004,@EUR005,@EUR006,@EUR007,@EUR008,@EUR009,@EUR010,@EUR011,@EUR012);";
paraList.Clear();
sqlParam = new SqlParameter("@EUR002", SqlDbType.Int);
sqlParam.Value = event_no;
paraList.Add(sqlParam);
sqlParam = new SqlParameter("@EUR003", SqlDbType.VarChar);
sqlParam.Value = code;
paraList.Add(sqlParam);
sqlParam = new SqlParameter("@EUR004", SqlDbType.DateTime);
sqlParam.Value = datNow;
paraList.Add(sqlParam);
sqlParam = new SqlParameter("@EUR005", SqlDbType.VarChar);
sqlParam.Value = ml; //帳號
paraList.Add(sqlParam);
sqlParam = new SqlParameter("@EUR006", SqlDbType.Char);
sqlParam.Value = age; //年紀
paraList.Add(sqlParam);
sqlParam = new SqlParameter("@EUR007", SqlDbType.Char);
sqlParam.Value = gender; //性別
paraList.Add(sqlParam);
sqlParam = new SqlParameter("@EUR008", SqlDbType.NVarChar);
sqlParam.Value = city; //地區
paraList.Add(sqlParam);
sqlParam = new SqlParameter("@EUR009", SqlDbType.SmallInt);
sqlParam.Value = iTemp; //溫度
paraList.Add(sqlParam);
sqlParam = new SqlParameter("@EUR010", SqlDbType.Int);
sqlParam.Value = iWeather; //天氣
paraList.Add(sqlParam);
sqlParam = new SqlParameter("@EUR011", SqlDbType.Float);
sqlParam.Value = lat; //緯度
paraList.Add(sqlParam);
sqlParam = new SqlParameter("@EUR012", SqlDbType.Float);
sqlParam.Value = lng; //經度
paraList.Add(sqlParam);
dbCtl.ExecuteScalar(strSQL, paraList);
//未中獎
strSQL = "update qr_record set QRC012=QRC012+1, QRC013=@QRC013 where QRC015=@QRC015;";
paraList.Clear();
sqlParam = new SqlParameter("@QRC013", SqlDbType.DateTime);
sqlParam.Value = datNow;
paraList.Add(sqlParam);
sqlParam = new SqlParameter("@QRC015", SqlDbType.VarChar);
sqlParam.Value = code;
paraList.Add(sqlParam);
dbCtl.ExecuteCommad(strSQL, paraList);
dbCtl.CommintTransaction();
jsonString = THC_Library.APPCURL.ScanRecord(event_no.ToString(), code,
datNow.ToString(), ml, age, gender, city, iTemp.ToString(), iWeather.ToString(),
lat, lng, rwdType, tk);
jsonResult = Newtonsoft.Json.JsonConvert.DeserializeObject(jsonString);
}
}
catch (THC_Library.CodeRenderException codeex)
{
dbCtl.RollBackTransaction();
error = new THC_Library.Error();
error.Number = codeex.Number;
error.ErrorMessage = codeex.AdditionalMessage;
}
catch (Exception ex)
{
dbCtl.RollBackTransaction();
error = new THC_Library.Error();
error.Number = THC_Library.THCException.SYSTEM_ERROR;
error.ErrorMessage = "系統發生異常錯誤，請稍後再上線使用。";//ex.Message;
}
finally
{
dbCtl.Close();
}
return(bWin);
}
public void runTimeSetting(HttpPostedFileBase file, out THC_Library.Error error)
{
error = null;
System.IO.StreamReader streamReader =
new System.IO.StreamReader(file.InputStream, System.Text.Encoding.Default);
IList <SqlParameter> paraList = new System.Collections.Generic.List <SqlParameter>();
SqlParameter sqlParam;
string strSQL;
string activityId = "", activityName = "";
DataBaseControl dbCtl = new DataBaseControl();
try
{
dbCtl.Open();
string activitySection = streamReader.ReadLine();
if (activitySection.StartsWith("activity:"))
{
//AE001,AE002,AE003,VM003 as AE004,AE006 as AE005,AE007 as AE006,AE009 as AE007,AE013 as AE008,
//AE014 as AE009,AE015 as AE010,AE016 as AE011,AE018 as AE012,AE019 as AE013
activitySection = activitySection.Replace("activity:", "");
dynamic activityJson = Newtonsoft.Json.JsonConvert.DeserializeObject(activitySection);
sqlParam = new SqlParameter("@AE001", SqlDbType.Int);
sqlParam.Value = activityJson[0].AE001;
paraList.Add(sqlParam);
sqlParam = new SqlParameter("@AE002", SqlDbType.NVarChar);
sqlParam.Value = activityJson[0].AE002;
paraList.Add(sqlParam);
sqlParam = new SqlParameter("@AE003", SqlDbType.NVarChar);
sqlParam.Value = activityJson[0].AE003;
paraList.Add(sqlParam);
sqlParam = new SqlParameter("@AE004", SqlDbType.NVarChar);
sqlParam.Value = activityJson[0].AE004;
paraList.Add(sqlParam);
sqlParam = new SqlParameter("@AE005", SqlDbType.VarChar);
sqlParam.Value = activityJson[0].AE005;
paraList.Add(sqlParam);
sqlParam = new SqlParameter("@AE006", SqlDbType.VarChar);
sqlParam.Value = activityJson[0].AE006;
paraList.Add(sqlParam);
sqlParam = new SqlParameter("@AE007", SqlDbType.Int);
sqlParam.Value = activityJson[0].AE007;
paraList.Add(sqlParam);
sqlParam = new SqlParameter("@AE008", SqlDbType.NVarChar);
sqlParam.Value = activityJson[0].AE008;
paraList.Add(sqlParam);
sqlParam = new SqlParameter("@AE009", SqlDbType.VarChar);
sqlParam.Value = activityJson[0].AE009;
paraList.Add(sqlParam);
sqlParam = new SqlParameter("@AE010", SqlDbType.Char);
sqlParam.Value = activityJson[0].AE010;
paraList.Add(sqlParam);
sqlParam = new SqlParameter("@AE011", SqlDbType.NVarChar);
sqlParam.Value = activityJson[0].AE011;
paraList.Add(sqlParam);
sqlParam = new SqlParameter("@AE012", SqlDbType.SmallInt);
sqlParam.Value = activityJson[0].AE012;
paraList.Add(sqlParam);
sqlParam = new SqlParameter("@AE013", SqlDbType.VarChar);
sqlParam.Value = activityJson[0].AE013;
paraList.Add(sqlParam);
strSQL = "insert into activity_event (AE001,AE002,AE003,AE004,AE005,AE006,AE007," +
"AE008,AE009,AE010,AE011,AE012,AE013) values (@AE001,@AE002,@AE003,@AE004,@AE005,@AE006,@AE007," +
"@AE008,@AE009,@AE010,@AE011,@AE012,@AE013)";
dbCtl.ExecuteCommad(strSQL, paraList);
activityId = activityJson[0].AE002.ToString();
activityName = activityJson[0].AE003.ToString();
}
else
{
throw new THC_Library.THCException(9000, "轉檔內容無活動設定資料");
}
string rewardSection = streamReader.ReadLine();
if (rewardSection.StartsWith("reward:"))
{
//AE001,AE002,AE003,VM003 as AE004,AE006 as AE005,AE007 as AE006,AE009 as AE007,AE013 as AE008,
//AE014 as AE009,AE015 as AE010,AE016 as AE011,AE018 as AE012,AE019 as AE013
rewardSection = rewardSection.Replace("reward:", "");
dynamic rewardJson = Newtonsoft.Json.JsonConvert.DeserializeObject(rewardSection);
foreach (dynamic reward in rewardJson)
{
paraList.Clear();
sqlParam = new SqlParameter("@AEP001", SqlDbType.Int);
sqlParam.Value = reward.AEP001;
paraList.Add(sqlParam);
sqlParam = new SqlParameter("@AEP002", SqlDbType.Int);
sqlParam.Value = reward.AEP002;
paraList.Add(sqlParam);
sqlParam = new SqlParameter("@AEP003", SqlDbType.Char);
sqlParam.Value = reward.AEP003;
paraList.Add(sqlParam);
sqlParam = new SqlParameter("@AEP004", SqlDbType.TinyInt);
sqlParam.Value = reward.AEP004;
paraList.Add(sqlParam);
sqlParam = new SqlParameter("@AEP005", SqlDbType.NVarChar);
sqlParam.Value = reward.AEP005;
paraList.Add(sqlParam);
sqlParam = new SqlParameter("@AEP006", SqlDbType.Int);
sqlParam.Value = reward.AEP006;
paraList.Add(sqlParam);
sqlParam = new SqlParameter("@AEP007", SqlDbType.NVarChar);
sqlParam.Value = reward.AEP007;
paraList.Add(sqlParam);
sqlParam = new SqlParameter("@AEP008", SqlDbType.DateTime);
sqlParam.Value = reward.AEP008;
paraList.Add(sqlParam);
sqlParam = new SqlParameter("@AEP009", SqlDbType.Int);
sqlParam.Value = reward.AEP009;
paraList.Add(sqlParam);
sqlParam = new SqlParameter("@AEP010", SqlDbType.Int);
if (reward.AEP010 == null)
{
sqlParam.Value = DBNull.Value;
}
else
{
sqlParam.Value = reward.AEP010;
}
paraList.Add(sqlParam);
sqlParam = new SqlParameter("@AEP011", SqlDbType.VarChar);
sqlParam.Value = reward.AEP011;
paraList.Add(sqlParam);
sqlParam = new SqlParameter("@AEP012", SqlDbType.VarChar);
sqlParam.Value = reward.AEP012;
paraList.Add(sqlParam);
sqlParam = new SqlParameter("@AEP013", SqlDbType.Text);
sqlParam.Value = reward.AEP013;
paraList.Add(sqlParam);
sqlParam = new SqlParameter("@AEP014", SqlDbType.VarChar);
sqlParam.Value = reward.AEP014;
paraList.Add(sqlParam);
strSQL = "insert into activity_rewards (AEP001,AEP002,AEP003,AEP004,AEP005,AEP006,AEP007," +
"AEP008,AEP009,AEP010,AEP011,AEP012,AEP013,AEP014) values (@AEP001,@AEP002,@AEP003,@AEP004,@AEP005,@AEP006,@AEP007," +
"@AEP008,@AEP009,@AEP010,@AEP011,@AEP012,@AEP013,@AEP014)";
dbCtl.ExecuteCommad(strSQL, paraList);
}
}
else
{
throw new THC_Library.THCException(9000, "轉檔內容無獎項設定資料");
}
string codeSection = streamReader.ReadLine();
dynamic codeJson = Newtonsoft.Json.JsonConvert.DeserializeObject(codeSection);
strSQL = "insert into qr_record (QRC001,QRC002,QRC003,QRC004,QRC005,QRC006,QRC007," +
"QRC008,QRC015,QRC018) values (@QRC001,@QRC002,@QRC003," +
"@QRC004,@QRC005,@QRC006,@QRC007,@QRC008,@QRC015,@QRC018)";
foreach (dynamic code in codeJson)
{
paraList.Clear();
sqlParam = new SqlParameter("@QRC001", SqlDbType.Int);
sqlParam.Value = code.EQC001;
paraList.Add(sqlParam);
sqlParam = new SqlParameter("@QRC002", SqlDbType.NVarChar);
sqlParam.Value = activityId;
paraList.Add(sqlParam);
sqlParam = new SqlParameter("@QRC003", SqlDbType.NVarChar);
sqlParam.Value = activityName;
paraList.Add(sqlParam);
sqlParam = new SqlParameter("@QRC004", SqlDbType.Int);
sqlParam.Value = code.EQC002;
paraList.Add(sqlParam);
sqlParam = new SqlParameter("@QRC005", SqlDbType.VarChar);
sqlParam.Value = code.EQC003;
paraList.Add(sqlParam);
sqlParam = new SqlParameter("@QRC006", SqlDbType.Char);
sqlParam.Value = code.EQC004;
paraList.Add(sqlParam);
sqlParam = new SqlParameter("@QRC007", SqlDbType.Char);
sqlParam.Value = code.EQC005;
paraList.Add(sqlParam);
sqlParam = new SqlParameter("@QRC008", SqlDbType.VarChar);
if (code.EC.ToString().Length > 0)
{
sqlParam.Value = code.EC;
}
else
{
sqlParam.Value = DBNull.Value;
}
paraList.Add(sqlParam);
sqlParam = new SqlParameter("@QRC015", SqlDbType.VarChar);
sqlParam.Value = string.Format("{0}{1}{2}",
code.EQC003, code.EQC004, code.EQC005);
paraList.Add(sqlParam);
sqlParam = new SqlParameter("@QRC018", SqlDbType.Int);
if (code.EQC007 == null)
{
sqlParam.Value = DBNull.Value;
}
else
{
sqlParam.Value = code.EQC007;
}
paraList.Add(sqlParam);
dbCtl.ExecuteCommad(strSQL, paraList);
/*
* {
* "img": "0DFszj05.jpg",
* "v_date" : "2017/11/30"
* }
*/
}
// EQC001,EQC002,EQC003,EQC004,EQC005,EQC007,EC,AEP003,AEP004,AEP005,AEP011,AEP012,AEP013
/*
* QRC001 Int PK 1.0
* QRC002 nvarchar(20) 事件代碼 專案編號 1.0
* QRC003 nvarchar(20) 事件名稱 1.0
* QRC004 int 序號 1.0
* QRC005 varchar(10) QR CODE 亂碼 1.0
* QRC006 Char(1) 序號補碼 1.0
* QRC007 Char(1) QR補碼 1.0
* QRC008 varchar(50) EC 1.0
* QRC009 char(1) 獎項型態 0 虛擬 1 實體 1.0
* QRC010 tinyint 獎項層級 0立即中獎/ 1掃描參加遊戲在立即中獎/2非立即中獎 1.0
* QRC011 nvarchar(20) 獎項名稱 1.0
#QRC012 int 掃描次數 Default 0 1.0
#QRC013 datetime 掃描時間 null 1.0
#QRC014 int 記錄檔PK null 1.0
* QRC015 varchar(10) 實際碼 QRC005+ QRC006+ QRC007 1.0
#QRC016 varchar(100) 得獎mail帳號 null 1.0
* QRC017 Nvarchar(250) 獎項資料 json 格式 Null 包含圖示、有效時間等資料 1.0
* QRC018 text 簡訊內容 17/09/09
*
*/
}
catch (THC_Library.THCException THCEx)
{
error = new THC_Library.Error();
error.Number = THCEx.Number;
error.ErrorMessage = THCEx.Message;
}
catch (Exception ex)
{
error = new THC_Library.Error();
error.ErrorMessage = ex.ToString();
}
finally
{
streamReader.Close();
}
}
public int updateRewardInfoWithFile(string reward_key, string name, string memo, string vender, string img,
string win_desc, string vdate, string sms, string filepath, HttpPostedFileBase file, out THC_Library.Error error)
{
error = null;
int iAffrect = 0;
IList <SqlParameter> paraList = new System.Collections.Generic.List <SqlParameter>();
string strSQL = "";
if (file == null)
{
strSQL = "update activity_rewards set AEP005=@AEP005,AEP007=@AEP007,AEP009=@AEP009,AEP012=@AEP012,AEP013=@AEP013," +
"AEP014=@AEP014 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("@AEP012", vdate));
paraList.Add(new SqlParameter("@AEP013", sms));
paraList.Add(new SqlParameter("@AEP014", win_desc));
paraList.Add(new SqlParameter("@AEP001", reward_key));
}
else
{
strSQL = "update activity_rewards set AEP005=@AEP005,AEP007=@AEP007,AEP009=@AEP009,AEP011=@AEP011,AEP012=@AEP012,AEP013=@AEP013," +
"AEP014=@AEP014 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", file.FileName));
paraList.Add(new SqlParameter("@AEP012", vdate));
paraList.Add(new SqlParameter("@AEP013", sms));
paraList.Add(new SqlParameter("@AEP014", win_desc));
paraList.Add(new SqlParameter("@AEP001", reward_key));
}
DataBaseControl dbCtl = new DataBaseControl();
try
{
//var fileName = System.IO.Path.GetFileName(rwdFile.FileName);
//var fileExtension = System.IO.Path.GetExtension(rwdFile.FileName);
if (file != null)
{
var path = System.IO.Path.Combine(filepath, file.FileName);
file.SaveAs(path);
}
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);
}