protected void btnWhiteList_Click(object sender, EventArgs e)
{
string roleID = tbWhiteListContent.Text.Trim();
if (string.IsNullOrEmpty(roleID))
{
Response.Write("<Script Language=JavaScript>alert('" + App_GlobalResources.Language.Tip_WriteRoleID + "');</Script>");
return;
}
string sql = string.Format("SELECT [F_UserID] FROM [T_RoleCreate] WHERE [F_RoleID]={0}", roleID);
ds = DBHelperGameCoreDB.Query(sql);
if (ds == null || ds.Tables[0].Rows.Count == 0)
{
Response.Write("<Script Language=JavaScript>alert('" + App_GlobalResources.Language.Tip_NoUserInfo + "');</Script>");
return;
}
sql = string.Format("SELECT [F_UserID],[F_UserName] FROM [T_User] WHERE [F_UserID]={0}", ds.Tables[0].Rows[0][0]);
ds = DBHelperUserCoreDB.Query(sql);
if (ds == null || ds.Tables[0].Rows.Count == 0)
{
Response.Write("<Script Language=JavaScript>alert('" + App_GlobalResources.Language.Tip_UserInfoError + "');</Script>");
return;
}
string userID = ds.Tables[0].Rows[0][0].ToString();
string userName = ds.Tables[0].Rows[0][1].ToString();
sql = string.Format("SELECT id,uuid FROM test_users WHERE uuid=N'{0}'", userName);
ds = dbHelperMySQL.QueryForMysql(sql);
if (ds != null && ds.Tables[0].Rows.Count > 0)
{
Response.Write("<Script Language=JavaScript>alert('" + App_GlobalResources.Language.Tip_WhiteListIsExist + "');</Script>");
return;
}
sql = string.Format("INSERT INTO test_users (`uuid`, `created_at`, `updated_at`) VALUES ('{0}', NOW(), NOW())", userName);
int res = dbHelperMySQL.ExecuteMySql(sql);
if (res > 0)
{
Response.Write("<Script Language=JavaScript>alert('" + App_GlobalResources.Language.Tip_Success + "');</Script>");
}
else
{
Response.Write("<Script Language=JavaScript>alert('" + App_GlobalResources.Language.Tip_Failure + "');</Script>");
}
}
/// <summary>
/// 确定
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnConfirm_Click(object sender, EventArgs e)
{
int taskID = Convert.ToInt32(DateTime.Now.ToString("yyMMddHHmm"));
string sendBattleZone = string.Empty;
#region 获取礼包配置基本信息
#region 战区
string strBigZone = "0";//大区默认值
string strBattleZone = string.Empty;
for (int i = 0; i < ckbBattleZone.Items.Count; i++)//获取选中的战区
{
if (ckbBattleZone.Items[i].Selected)
{
strBattleZone += ckbBattleZone.Items[i].Value + ";";
}
}
if (strBattleZone.Length > 0)//判断是否选择战区
{
strBattleZone = strBattleZone.Substring(0, strBattleZone.Length - 1);
}
if (string.IsNullOrEmpty(strBattleZone))
{
Response.Write("<Script Language=JavaScript>alert('" + App_GlobalResources.Language.Tip_SelectBattleZone + "');</Script>");
return;
}
string[] arrayBattleZone = strBattleZone.Split(';');
#endregion
string strProductID = ProductID.Text.Trim();
if (string.IsNullOrEmpty(strProductID))
{
Response.Write("<Script Language=JavaScript>alert('请填写ProductID！');</Script>");
return;
}
string strType = F_Type.SelectedValue;
string strSubType = F_SubType.SelectedValue;
string strOldKRWCostMoney = string.IsNullOrEmpty(F_OldKRWCostMoney.Text.Trim()) ? "0" : F_OldKRWCostMoney.Text.Trim();
string strOldUSDCostMoney = string.IsNullOrEmpty(F_OldUSDCostMoney.Text.Trim()) ? "0" : F_OldUSDCostMoney.Text.Trim();
string strCurKRWCostMoney = string.IsNullOrEmpty(F_CurKRWCostMoney.Text.Trim()) ? "0" : F_CurKRWCostMoney.Text.Trim();
string strCurUSDCostMoney = string.IsNullOrEmpty(F_CurUSDCostMoney.Text.Trim()) ? "0" : F_CurUSDCostMoney.Text.Trim();
string strGetMoney = string.IsNullOrEmpty(F_GetMoney.Text.Trim()) ? "0" : F_GetMoney.Text.Trim();
string strPara1 = string.IsNullOrEmpty(F_Para1.Text.Trim()) ? "0" : F_Para1.Text.Trim();
string strPara2 = string.IsNullOrEmpty(F_Para2.Text.Trim()) ? "0" : F_Para2.Text.Trim();
string strPara3 = string.IsNullOrEmpty(F_Para3.Text.Trim()) ? "0" : F_Para3.Text.Trim();
string strExp = string.IsNullOrEmpty(F_Exp.Text.Trim()) ? "0" : F_Exp.Text.Trim();
string strBeginGiveBindGoldTime = string.IsNullOrEmpty(F_BeginGiveBindGoldTime.Text.Trim()) ? DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") : F_BeginGiveBindGoldTime.Text.Trim();
string strEndGiveBindGoldTime = string.IsNullOrEmpty(F_EndGiveBindGoldTime.Text.Trim()) ? DateTime.Now.AddDays(1).ToString("yyyy-MM-dd HH:mm:ss") : F_EndGiveBindGoldTime.Text.Trim();
string strFirstGiveBindGold = string.IsNullOrEmpty(F_FirstGiveBindGold.Text.Trim()) ? "0" : F_FirstGiveBindGold.Text.Trim();
string strGiveBindGold = string.IsNullOrEmpty(F_GiveBindGold.Text.Trim()) ? "0" : F_GiveBindGold.Text.Trim();
string strTitle = this.tbTitle.Text.Trim();
if (string.IsNullOrEmpty(strTitle))
{
Response.Write("<Script Language=JavaScript>alert('请填写邮件标题！');</Script>");
return;
}
string strSendUser = this.tbSnedUser.Text.Trim();
if (string.IsNullOrEmpty(strSendUser))
{
Response.Write("<Script Language=JavaScript>alert('请填写发件人！');</Script>");
return;
}
string strMailContent = this.tbMailContent.Text.Trim();
if (string.IsNullOrEmpty(strMailContent))
{
Response.Write("<Script Language=JavaScript>alert('请填写邮件内容！');</Script>");
return;
}
#endregion
try
{
#region 写入gameshop_package
for (int m = 0; m < arrayBattleZone.Count(); m++)
{
List <SqlParameter> param = new List <SqlParameter>();
param.Add(new SqlParameter("@bigZone", SqlDbType.Int)
{
Value = strBigZone
});
param.Add(new SqlParameter("@ZoneID", SqlDbType.Int)
{
Value = Convert.ToInt32(arrayBattleZone[m])
});
param.Add(new SqlParameter("@logicJson", SqlDbType.NVarChar)
{
Value = strBattleZone
});
param.Add(new SqlParameter("@taskId", SqlDbType.Int)
{
Value = taskID
});
DataSet ds = DBHelperGSSDB.RunProcedure("SP_AddAwardToMysql", param.ToArray(), "tableName");
if (ds == null || ds.Tables.Count == 0 || ds.Tables[0].Rows.Count == 0)
{
Response.Write("<Script Language=JavaScript>alert('" + App_GlobalResources.Language.Tip_SyncDBFailure + ";已经发送成功的战区：" + sendBattleZone + "');</Script>");
return;
}
string link = ds.Tables[0].Rows[0]["name"] as string;
string conn = ds.Tables[0].Rows[0]["provider_string"] as string;
string filter = FilterMySqlDBConnString(conn);
dbHelperMySQL.connectionString = filter;
string sqlSelect = string.Format("SELECT * FROM deposit_table WHERE F_ProductID={0}", strProductID);
ds = dbHelperMySQL.QueryForMysql(sqlSelect);
if (ds == null || ds.Tables.Count == 0 || ds.Tables[0].Rows.Count == 0)
{
string sqlInsert = string.Format("INSERT INTO deposit_table (F_ProductID, F_Type, F_SubType, F_OldKRWCostMoney, F_OldUSDCostMoney, F_CurKRWCostMoney, F_CurUSDCostMoney, F_GetMoney, F_Para1, F_Para2, F_Para3, F_Exp, F_BeginGiveBindGoldTime, F_EndGiveBindGoldTime, F_FirstGiveBindGold, F_GiveBindGold, F_Mail_Title, F_Mail_Content, F_Sender_Name) VALUES ({0}, {1}, {2},{3},{4}, {5}, {6}, {7}, {8}, {9}, {10}, {11}, '{12}', '{13}', {14}, {15}, N'{16}', N'{17}',N'{18}')", strProductID, strType, strSubType, strOldKRWCostMoney, strOldUSDCostMoney, strCurKRWCostMoney, strCurUSDCostMoney, strGetMoney, strPara1, strPara2, strPara3, strExp, strBeginGiveBindGoldTime, strEndGiveBindGoldTime, strFirstGiveBindGold, strGiveBindGold, strTitle, strMailContent, strSendUser);
int res = dbHelperMySQL.ExecuteMySql(sqlInsert);
if (res > 0)
{
}
else
{
Response.Write("<Script Language=JavaScript>alert('" + App_GlobalResources.Language.Tip_Failure + "已经发送成功的战区：" + sendBattleZone + "');</Script>");
return;
}
}
else
{
string sqlUpdate = string.Format("UPDATE deposit_table SET F_ProductID={0}, F_Type={1}, F_SubType={2}, F_OldKRWCostMoney={3}, F_OldUSDCostMoney={4}, F_CurKRWCostMoney={5}, F_CurUSDCostMoney={6}, F_GetMoney={7}, F_Para1={8}, F_Para2={9}, F_Para3={10}, F_Exp={11}, F_BeginGiveBindGoldTime='{12}', F_EndGiveBindGoldTime='{13}', F_FirstGiveBindGold={14}, F_GiveBindGold={15}, F_Mail_Title=N'{16}', F_Mail_Content=N'{17}', F_Sender_Name=N'{18}' WHERE (F_ProductID={19})", strProductID, strType, strSubType, strOldKRWCostMoney, strOldUSDCostMoney, strCurKRWCostMoney, strCurUSDCostMoney, strGetMoney, strPara1, strPara2, strPara3, strExp, strBeginGiveBindGoldTime, strEndGiveBindGoldTime, strFirstGiveBindGold, strGiveBindGold, strTitle, strMailContent, strSendUser, strProductID);
int res = dbHelperMySQL.ExecuteMySql(sqlUpdate);
if (res > 0)
{
}
else
{
Response.Write("<Script Language=JavaScript>alert('" + App_GlobalResources.Language.Tip_Failure + "已经发送成功的战区：" + sendBattleZone + "');</Script>");
return;
}
}
sendBattleZone += arrayBattleZone[m] + ";";
}
Response.Write("<Script Language=JavaScript>alert('" + App_GlobalResources.Language.Tip_Success + "');</Script>");
#endregion
#region 写入T_GiftConfigLog表
string sql = string.Format("INSERT INTO T_DepositConfigLog (F_ProductID, F_Type, F_SubType, F_OldKRWCostMoney, F_OldUSDCostMoney, F_CurKRWCostMoney, F_CurUSDCostMoney, F_GetMoney, F_Para1, F_Para2, F_Para3, F_Exp, F_BeginGiveBindGoldTime, F_EndGiveBindGoldTime, F_FirstGiveBindGold, F_GiveBindGold, F_Mail_Title, F_Mail_Content, F_Sender_Name,F_BattleZone,F_OPTime) VALUES ({0}, {1}, {2},{3},{4}, {5}, {6}, {7}, {8}, {9}, {10}, {11}, '{12}', '{13}', {14}, {15}, N'{16}', N'{17}',N'{18}',N'{19}',GETDATE())", strProductID, strType, strSubType, strOldKRWCostMoney, strOldUSDCostMoney, strCurKRWCostMoney, strCurUSDCostMoney, strGetMoney, strPara1, strPara2, strPara3, strExp, strBeginGiveBindGoldTime, strEndGiveBindGoldTime, strFirstGiveBindGold, strGiveBindGold, strTitle, strMailContent, strSendUser, sendBattleZone);
DBHelperDigGameDB.ExecuteSql(sql);
#endregion
}
catch (Exception ex)
{
}
}
/// <summary>
/// 确认
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnConfirm_Click(object sender, EventArgs e)
{
lblinfo.Text = "";
string sendBattleZone = string.Empty;
#region 全服邮件基本信息
int taskID = Convert.ToInt32(DateTime.Now.ToString("yyMMddHHmm"));
string strTitle = tbTitle.Text.Trim();
if (string.IsNullOrEmpty(strTitle))
{
Response.Write("<Script Language=JavaScript>alert('" + App_GlobalResources.Language.Tip_Title + "');</Script>");
return;
}
string strSendUser = tbSnedUser.Text.Trim();
if (string.IsNullOrEmpty(strSendUser))
{
Response.Write("<Script Language=JavaScript>alert('" + App_GlobalResources.Language.Tip_WriteSendUser + "');</Script>");
return;
}
string strMinLevel = tbMinLevel.Text.Trim();
if (string.IsNullOrEmpty(strMinLevel))
{
Response.Write("<Script Language=JavaScript>alert('" + App_GlobalResources.Language.Tip_WriteMinLevel + "');</Script>");
return;
}
string strMaxLevel = tbMaxLevel.Text.Trim();
if (string.IsNullOrEmpty(strMaxLevel))
{
Response.Write("<Script Language=JavaScript>alert('" + App_GlobalResources.Language.Tip_WriteMaxLevel + "');</Script>");
return;
}
string strStime = tbSTime.Text;
string strETime = tbETime.Text;
string strBigZone = "0";
string strBattleZone = string.Empty;
for (int i = 0; i < ckbBattleZone.Items.Count; i++)
{
if (ckbBattleZone.Items[i].Selected)
{
strBattleZone += ckbBattleZone.Items[i].Value + ";";
}
}
if (strBattleZone.Length > 0)
{
strBattleZone = strBattleZone.Substring(0, strBattleZone.Length - 1);
}
if (string.IsNullOrEmpty(strBattleZone))
{
Response.Write("<Script Language=JavaScript>alert('" + App_GlobalResources.Language.Tip_SelectBattleZone + "');</Script>");
return;
}
string[] arrayBattleZone = strBattleZone.Split(';');
string strBindGold = string.IsNullOrEmpty(tbBindGold.Text.Trim()) ? "0" : tbBindGold.Text.Trim();
string strGold = string.IsNullOrEmpty(tbGold.Text.Trim()) ? "0" : tbGold.Text.Trim();
string strItemID1 = string.IsNullOrEmpty(tbItemID1.Text.Trim()) ? "0" : tbItemID1.Text.Trim();
string strItemID2 = string.IsNullOrEmpty(tbItemID2.Text.Trim()) ? "0" : tbItemID2.Text.Trim();
string strItemID3 = string.IsNullOrEmpty(tbItemID3.Text.Trim()) ? "0" : tbItemID3.Text.Trim();
string strItemID4 = string.IsNullOrEmpty(tbItemID4.Text.Trim()) ? "0" : tbItemID4.Text.Trim();
string strItemID5 = string.IsNullOrEmpty(tbItemID5.Text.Trim()) ? "0" : tbItemID5.Text.Trim();
string strItemNum1 = string.IsNullOrEmpty(tbItemNum1.Text.Trim()) ? "0" : tbItemNum1.Text.Trim();
string strItemNum2 = string.IsNullOrEmpty(tbItemNum2.Text.Trim()) ? "0" : tbItemNum2.Text.Trim();
string strItemNum3 = string.IsNullOrEmpty(tbItemNum3.Text.Trim()) ? "0" : tbItemNum3.Text.Trim();
string strItemNum4 = string.IsNullOrEmpty(tbItemNum4.Text.Trim()) ? "0" : tbItemNum4.Text.Trim();
string strItemNum5 = string.IsNullOrEmpty(tbItemNum5.Text.Trim()) ? "0" : tbItemNum5.Text.Trim();
string strMailContent = tbMailContent.Text.Trim();
if (string.IsNullOrEmpty(strMailContent))
{
Response.Write("<Script Language=JavaScript>alert('" + App_GlobalResources.Language.Tip_WriteMailContent + "');</Script>");
return;
}
string strBak = tbBak.Text.Trim();
int type = 20000217;//全服邮件
string giftStr = string.Format("{0}|{1}|{2}|{3}|{4}|{5}|{6}|{7}|{8}|{9}|{10}|{11}", strItemID1, strItemNum1, strItemID2, strItemNum2, strItemID3, strItemNum3, strItemID4, strItemNum4, strItemID5, strItemNum5, strBindGold, strGold);
#endregion
try
{
#region 写入Mysql-gsdata-sys_loss_award_table
for (int m = 0; m < arrayBattleZone.Count(); m++)
{
List <SqlParameter> param = new List <SqlParameter>();
param.Add(new SqlParameter("@bigZone", SqlDbType.Int)
{
Value = strBigZone
});
param.Add(new SqlParameter("@ZoneID", SqlDbType.Int)
{
Value = Convert.ToInt32(arrayBattleZone[m])
});
param.Add(new SqlParameter("@logicJson", SqlDbType.NVarChar)
{
Value = strBattleZone + "&" + giftStr
});
param.Add(new SqlParameter("@taskId", SqlDbType.Int)
{
Value = taskID
});
DataSet ds = DBHelperGSSDB.RunProcedure("SP_AddAwardToMysql", param.ToArray(), "tableName");
if (ds == null || ds.Tables.Count == 0 || ds.Tables[0].Rows.Count == 0)
{
Response.Write("<Script Language=JavaScript>alert('" + App_GlobalResources.Language.Tip_SyncDBFailure + ";已经发送成功的战区：" + sendBattleZone + "');</Script>");
return;
}
string sql = string.Format("INSERT INTO sys_loss_award_table (DBID,LevelMin,LevelMax,ItemID1,ItemNum1,ItemID2,ItemNum2,ItemID3,ItemNum3,ItemID4,ItemNum4,ItemID5,ItemNum5,BeginTime,InvalidTime,ItemContent,F_Mail_Title,F_Mail_Content,F_Sender_Name,F_BIND_GOLD,F_GOLD) VALUES({0},{1},{2},{3},{4},{5},{6},{7},{8},{9},{10},{11},{12},'{13}','{14}',N'{15}',N'{16}',N'{17}',N'{18}',{19},{20})", taskID, strMinLevel, strMaxLevel, strItemID1, strItemNum1, strItemID2, strItemNum2, strItemID3, strItemNum3, strItemID4, strItemNum4, strItemID5, strItemNum5, strStime, strETime, strBak, strTitle, strMailContent, strSendUser, strBindGold, strGold);
foreach (DataRow item in ds.Tables[0].Rows)
{
string link = item["name"] as string;
string conn = item["provider_string"] as string;
if (string.IsNullOrEmpty(conn))
{
continue;
}
string filter = FilterMySqlDBConnString(conn);
dbHelperMySQL.connectionString = filter;
int res = dbHelperMySQL.ExecuteMySql(sql);
if (res > 0)
{
}
else
{
Response.Write("<Script Language=JavaScript>alert('" + App_GlobalResources.Language.Tip_Failure + "已经发送成功的战区：" + sendBattleZone + "');</Script>");
return;
}
}
sendBattleZone += arrayBattleZone[m] + ";";
}
Response.Write("<Script Language=JavaScript>alert('" + App_GlobalResources.Language.Tip_Success + "');</Script>");
#endregion
#region 写入[GSSDB].dbo.T_Tasks
//F_ID-taskID
//F_Title-标题
//F_GPeopleName-发起人
//F_Note-邮件内容
//F_COther-邮件备注
//F_URInfo-红蓝钻及道具信息
//F_TUseData-战区
//F_CreatTime-开始时间
//F_EditTime-结束时间
//F_PreDutyMan-关联taskID
//F_OAlwaysPlace-最低级和最高级
string strSql = string.Format("INSERT INTO [T_Tasks] ([F_Title], [F_Note], [F_From], [F_VipLevel], [F_LimitType], [F_LimitTime], [F_Type], [F_State], [F_GameName], [F_GameBigZone], [F_GameZone], [F_GUserID], [F_GUserName], [F_GRoleID], [F_GRoleName], [F_Telphone], [F_GPeopleName], [F_DutyMan], [F_PreDutyMan], [F_CreatMan], [F_CreatTime], [F_EditMan], [F_EditTime], [F_URInfo], [F_Rowtype], [F_CUserName], [F_CPSWProtect], [F_CPersonID], [F_COther], [F_OLastLoginTime], [F_OCanRestor], [F_OAlwaysPlace], [F_TToolUsed], [F_TUseData]) VALUES (N'{0}', N'{1}', 0 , 0 , 0, NULL, '{2}', '100100100', '1000', N'{3}', NULL, NULL, NULL, NULL, NULL, N'', N'{4}', NULL, {5}, '0', '{6}', '0','{7}', N'{8}', '0', '0', '0', '0', N'{9}', N'', NULL, N'" + strMinLevel + "&" + strMaxLevel + "', '1', N'{10}');", strTitle, strMailContent, type, strBigZone, strSendUser, taskID, strStime, strETime, giftStr, strBak, sendBattleZone);
DBHelperGSSDB.ExecuteSql(strSql);
#endregion
}
catch (Exception ex)
{
string strSql = string.Format("INSERT INTO [T_Tasks] ([F_Title], [F_Note], [F_From], [F_VipLevel], [F_LimitType], [F_LimitTime], [F_Type], [F_State], [F_GameName], [F_GameBigZone], [F_GameZone], [F_GUserID], [F_GUserName], [F_GRoleID], [F_GRoleName], [F_Telphone], [F_GPeopleName], [F_DutyMan], [F_PreDutyMan], [F_CreatMan], [F_CreatTime], [F_EditMan], [F_EditTime], [F_URInfo], [F_Rowtype], [F_CUserName], [F_CPSWProtect], [F_CPersonID], [F_COther], [F_OLastLoginTime], [F_OCanRestor], [F_OAlwaysPlace], [F_TToolUsed], [F_TUseData]) VALUES (N'{0}', N'{1}', 0 , 0 , 0, NULL, '{2}', '100100100', '1000', N'{3}', NULL, NULL, NULL, NULL, NULL, N'', N'{4}', NULL, {5}, '0', '{6}', '0','{7}', N'{8}', '0', '0', '0', '0', N'{9}', N'', NULL, N'" + strMinLevel + "&" + strMaxLevel + "', '1', N'{10}');", strTitle, strMailContent, type, strBigZone, strSendUser, taskID, strStime, strETime, giftStr, strBak, sendBattleZone);
//DBHelperGSSDB.ExecuteSql(strSql);
lblinfo.Text = "已经发送成功的战区：" + sendBattleZone + ";ErrorMessage:" + ex.Message;
}
}
/// <summary>
/// 确定
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnConfirm_Click(object sender, EventArgs e)
{
int taskID = Convert.ToInt32(DateTime.Now.ToString("yyMMddHHmm"));
string sendBattleZone = string.Empty;
#region 获取礼包配置基本信息
#region 战区
string strBigZone = "0";//大区默认值
string strBattleZone = string.Empty;
for (int i = 0; i < ckbBattleZone.Items.Count; i++)//获取选中的战区
{
if (ckbBattleZone.Items[i].Selected)
{
strBattleZone += ckbBattleZone.Items[i].Value + ";";
}
}
if (strBattleZone.Length > 0)//判断是否选择战区
{
strBattleZone = strBattleZone.Substring(0, strBattleZone.Length - 1);
}
if (string.IsNullOrEmpty(strBattleZone))
{
Response.Write("<Script Language=JavaScript>alert('" + App_GlobalResources.Language.Tip_SelectBattleZone + "');</Script>");
return;
}
string[] arrayBattleZone = strBattleZone.Split(';');
#endregion
string strPackageName = this.tbPackageName.Text.Trim();//礼包名称
if (string.IsNullOrEmpty(strPackageName))
{
Response.Write("<Script Language=JavaScript>alert('请填写礼包名称！');</Script>");
return;
}
string strItemFlag = this.ckbItemFlag.Checked ? "1" : "0"; //是否推荐0正常1推荐
string strProductID = this.ddlProductID.SelectedValue; //ProductID
string strOldKRWMoney = this.OldKRWMoney.Text.Trim();
string strOldUSDMoney = this.OldUSDMoney.Text.Trim();
string strCurKRWMoney = this.CurKRWMoney.Text.Trim();
string strCurUSDMoney = this.CurUSDMoney.Text.Trim();
if (string.IsNullOrEmpty(strOldKRWMoney) || string.IsNullOrEmpty(strOldUSDMoney) || string.IsNullOrEmpty(strCurKRWMoney) || string.IsNullOrEmpty(strCurUSDMoney))
{
Response.Write("<Script Language=JavaScript>alert('请填写商品价格！');</Script>");
return;
}
string strItemType = this.ddlItemType.SelectedValue; //分页类型
string strItemTypeText = GetItemTypeText(this.ddlItemType.SelectedValue); //分页类型显示文本
string strPos = this.Pos.Text.Trim(); //礼包显示位置
if (string.IsNullOrEmpty(strPos))
{
Response.Write("<Script Language=JavaScript>alert('请填写礼包显示顺利！');</Script>");
return;
}
string strPackageMoneyType = this.ddlPackageMoneyType.SelectedValue; //礼包类型
string strLimitStell = this.ddlLimitStell.SelectedValue; //限制类型
string strLimitNum = string.IsNullOrEmpty(this.LimitNum.Text.Trim()) ? "0" : this.LimitNum.Text.Trim(); //限购个数
string strLimitTime = this.ckbLimitTime.Checked ? "1" : "0"; //是否限时
string strSTime = string.IsNullOrEmpty(this.TimeStart.Text.Trim()) ? DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") : this.TimeStart.Text.Trim(); //限时开始时间
string strETime = string.IsNullOrEmpty(this.TimeEnd.Text.Trim()) ? DateTime.Now.AddDays(1).ToString("yyyy-MM-dd HH:mm:ss") : this.TimeEnd.Text.Trim(); //限时结束时间
string strPicID = this.ddlPicID.SelectedValue; //显示图片
string strGiftID_0 = string.IsNullOrEmpty(this.F_GiftID_0.Text.Trim()) ? "0" : this.F_GiftID_0.Text.Trim();
string strGiftID_1 = string.IsNullOrEmpty(this.F_GiftID_1.Text.Trim()) ? "0" : this.F_GiftID_1.Text.Trim();
string strGiftID_2 = string.IsNullOrEmpty(this.F_GiftID_2.Text.Trim()) ? "0" : this.F_GiftID_2.Text.Trim();
string strGiftID_3 = string.IsNullOrEmpty(this.F_GiftID_3.Text.Trim()) ? "0" : this.F_GiftID_3.Text.Trim();
string strGiftID_4 = string.IsNullOrEmpty(this.F_GiftID_4.Text.Trim()) ? "0" : this.F_GiftID_4.Text.Trim();
string strGiftNUM_0 = string.IsNullOrEmpty(this.F_GiftNUM_0.Text.Trim()) ? "0" : this.F_GiftNUM_0.Text.Trim();
string strGiftNUM_1 = string.IsNullOrEmpty(this.F_GiftNUM_1.Text.Trim()) ? "0" : this.F_GiftNUM_1.Text.Trim();
string strGiftNUM_2 = string.IsNullOrEmpty(this.F_GiftNUM_2.Text.Trim()) ? "0" : this.F_GiftNUM_2.Text.Trim();
string strGiftNUM_3 = string.IsNullOrEmpty(this.F_GiftNUM_3.Text.Trim()) ? "0" : this.F_GiftNUM_3.Text.Trim();
string strGiftNUM_4 = string.IsNullOrEmpty(this.F_GiftNUM_4.Text.Trim()) ? "0" : this.F_GiftNUM_4.Text.Trim();
string strGifts = string.Format("{0};{1}|{2};{3}|{4};{5}|{6};{7}|{8};{9}|", strGiftID_0, strGiftNUM_0, strGiftID_1, strGiftNUM_1, strGiftID_2, strGiftNUM_2, strGiftID_3, strGiftNUM_3, strGiftID_4, strGiftNUM_4);
string strTitle = this.tbTitle.Text.Trim();
if (string.IsNullOrEmpty(strTitle))
{
Response.Write("<Script Language=JavaScript>alert('请填写邮件标题！');</Script>");
return;
}
string strSendUser = this.tbSnedUser.Text.Trim();
if (string.IsNullOrEmpty(strSendUser))
{
Response.Write("<Script Language=JavaScript>alert('请填写发件人！');</Script>");
return;
}
string strMailContent = this.tbMailContent.Text.Trim();
if (string.IsNullOrEmpty(strMailContent))
{
Response.Write("<Script Language=JavaScript>alert('请填写邮件内容！');</Script>");
return;
}
string strItemInfo = this.ItemInfo.Text.Trim();
if (string.IsNullOrEmpty(strItemInfo))
{
Response.Write("<Script Language=JavaScript>alert('请填写礼包描述！');</Script>");
return;
}
#endregion
try
{
#region 写入gameshop_package
for (int m = 0; m < arrayBattleZone.Count(); m++)
{
List <SqlParameter> param = new List <SqlParameter>();
param.Add(new SqlParameter("@bigZone", SqlDbType.Int)
{
Value = strBigZone
});
param.Add(new SqlParameter("@ZoneID", SqlDbType.Int)
{
Value = Convert.ToInt32(arrayBattleZone[m])
});
param.Add(new SqlParameter("@logicJson", SqlDbType.NVarChar)
{
Value = strBattleZone + "&" + strGifts
});
param.Add(new SqlParameter("@taskId", SqlDbType.Int)
{
Value = taskID
});
DataSet ds = DBHelperGSSDB.RunProcedure("SP_AddAwardToMysql", param.ToArray(), "tableName");
if (ds == null || ds.Tables.Count == 0 || ds.Tables[0].Rows.Count == 0)
{
Response.Write("<Script Language=JavaScript>alert('" + App_GlobalResources.Language.Tip_SyncDBFailure + ";已经发送成功的战区：" + sendBattleZone + "');</Script>");
return;
}
string link = ds.Tables[0].Rows[0]["name"] as string;
string conn = ds.Tables[0].Rows[0]["provider_string"] as string;
string filter = FilterMySqlDBConnString(conn);
dbHelperMySQL.connectionString = filter;
string sqlSelect = string.Format("SELECT * FROM gameshop_package WHERE F_ProductID={0}", strProductID);
ds = dbHelperMySQL.QueryForMysql(sqlSelect);
if (ds == null || ds.Tables.Count == 0 || ds.Tables[0].Rows.Count == 0)
{
string sqlInsert = string.Format("INSERT INTO gameshop_package (F_ProductID, F_ServerSaveID, F_PicID, F_Pos, F_ItemType, F_ItemType_TextId, F_PackageName, F_PackageMoneyType, F_OldKRWMoney, F_OldUSDMoney, F_CurKRWMoney, F_CurUSDMoney, F_ItemFlag, F_LimitNum, F_LimitTime, F_LimitStell, F_TimeStart, F_TimeEnd, F_GiftID_0, F_GiftNUM_0, F_GiftID_1, F_GiftNUM_1, F_GiftID_2, F_GiftNUM_2, F_GiftID_3, F_GiftNUM_3, F_GiftID_4, F_GiftNUM_4, F_Mail_Title, F_Mail_Content, F_Sender_Name, F_ItemInfo) VALUES ({0}, {1}, {2}, {3}, {4}, {5}, N'{6}', {7}, {8}, {9}, {10}, {11}, {12},{13},{14},{15}, '{16}', '{17}', {18},{19},{20},{21}, {22},{23},{24},{25},{26},{27}, N'{28}', N'{29}', N'{30}', N'{31}')", strProductID, strProductID, strPicID, strPos, strItemType, strItemTypeText, strPackageName, strPackageMoneyType, strOldKRWMoney, strOldUSDMoney, strCurKRWMoney, strCurUSDMoney, strItemFlag, strLimitNum, strLimitTime, strLimitStell, strSTime, strETime, strGiftID_0, strGiftNUM_0, strGiftID_1, strGiftNUM_1, strGiftID_2, strGiftNUM_2, strGiftID_3, strGiftNUM_3, strGiftID_4, strGiftNUM_4, strTitle, strMailContent, strSendUser, strItemInfo);
int res = dbHelperMySQL.ExecuteMySql(sqlInsert);
if (res > 0)
{
}
else
{
Response.Write("<Script Language=JavaScript>alert('" + App_GlobalResources.Language.Tip_Failure + "已经发送成功的战区：" + sendBattleZone + "');</Script>");
return;
}
}
else
{
string strServerSaveID = string.Empty;
if (strProductID.Length == ds.Tables[0].Rows[0]["F_ServerSaveID"].ToString().Length)
{
strServerSaveID = strProductID + "00";
}
else
{
strServerSaveID = (Convert.ToInt32(ds.Tables[0].Rows[0]["F_ServerSaveID"].ToString()) + 1).ToString();
}
string sqlUpdate = string.Format("UPDATE gameshop_package SET F_ProductID={0}, F_ServerSaveID={1}, F_PicID={2}, F_Pos={3}, F_ItemType={4}, F_ItemType_TextId={5}, F_PackageName=N'{6}', F_PackageMoneyType={7}, F_OldKRWMoney={8}, F_OldUSDMoney={9}, F_CurKRWMoney={10}, F_CurUSDMoney={11}, F_ItemFlag={12}, F_LimitNum={13}, F_LimitTime={14}, F_LimitStell={15}, F_TimeStart='{16}', F_TimeEnd='{17}', F_GiftID_0={18}, F_GiftNUM_0={19}, F_GiftID_1={20}, F_GiftNUM_1={21}, F_GiftID_2={22}, F_GiftNUM_2={23}, F_GiftID_3={24}, F_GiftNUM_3={25}, F_GiftID_4={26}, F_GiftNUM_4={27}, F_Mail_Title=N'{28}', F_Mail_Content=N'{29}', F_Sender_Name=N'{30}', F_ItemInfo=N'{31}' WHERE (F_ProductID={32})", strProductID, strServerSaveID, strPicID, strPos, strItemType, strItemTypeText, strPackageName, strPackageMoneyType, strOldKRWMoney, strOldUSDMoney, strCurKRWMoney, strCurUSDMoney, strItemFlag, strLimitNum, strLimitTime, strLimitStell, strSTime, strETime, strGiftID_0, strGiftNUM_0, strGiftID_1, strGiftNUM_1, strGiftID_2, strGiftNUM_2, strGiftID_3, strGiftNUM_3, strGiftID_4, strGiftNUM_4, strTitle, strMailContent, strSendUser, strItemInfo, strProductID);
int res = dbHelperMySQL.ExecuteMySql(sqlUpdate);
if (res > 0)
{
}
else
{
Response.Write("<Script Language=JavaScript>alert('" + App_GlobalResources.Language.Tip_Failure + "已经发送成功的战区：" + sendBattleZone + "');</Script>");
return;
}
}
sendBattleZone += arrayBattleZone[m] + ";";
}
Response.Write("<Script Language=JavaScript>alert('" + App_GlobalResources.Language.Tip_Success + "');</Script>");
#endregion
#region 写入T_GiftConfigLog表
string sql = string.Format("INSERT INTO T_GiftConfigLog (F_ProductID, F_ServerSaveID, F_PicID, F_Pos, F_ItemType, F_ItemType_TextId, F_PackageName, F_PackageMoneyType, F_OldKRWMoney, F_OldUSDMoney, F_CurKRWMoney, F_CurUSDMoney, F_ItemFlag, F_LimitNum, F_LimitTime, F_LimitStell, F_TimeStart, F_TimeEnd, F_GiftID_0, F_GiftNUM_0, F_GiftID_1, F_GiftNUM_1, F_GiftID_2, F_GiftNUM_2, F_GiftID_3, F_GiftNUM_3, F_GiftID_4, F_GiftNUM_4, F_Mail_Title, F_Mail_Content, F_Sender_Name, F_ItemInfo,F_BattleZone,F_OPTime) VALUES ({0}, {1}, {2}, {3}, {4}, {5}, N'{6}', {7}, {8}, {9}, {10}, {11}, {12},{13},{14},{15}, '{16}', '{17}', {18},{19},{20},{21}, {22},{23},{24},{25},{26},{27}, N'{28}', N'{29}', N'{30}', N'{31}',N'{32}',GETDATE())", strProductID, strProductID, strPicID, strPos, strItemType, strItemTypeText, strPackageName, strPackageMoneyType, strOldKRWMoney, strOldUSDMoney, strCurKRWMoney, strCurUSDMoney, strItemFlag, strLimitNum, strLimitTime, strLimitStell, strSTime, strETime, strGiftID_0, strGiftNUM_0, strGiftID_1, strGiftNUM_1, strGiftID_2, strGiftNUM_2, strGiftID_3, strGiftNUM_3, strGiftID_4, strGiftNUM_4, strTitle, strMailContent, strSendUser, strItemInfo, sendBattleZone);
DBHelperDigGameDB.ExecuteSql(sql);
#endregion
}
catch (Exception ex)
{
}
}