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