/// <summary> /// 添加 /// </summary> /// <param name="model"></param> /// <returns></returns> public bool Add(tsuhan_scgl_khdm model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into tsuhan_scgl_khdm("); strSql.Append("id,客户代码,客户信息,录入员,录入时间)"); strSql.Append(" values ("); strSql.Append("@id,@客户代码,@客户信息,@录入员,@录入时间)"); SqlParameter[] parameters = { new SqlParameter("@id", SqlDbType.Int, 4), new SqlParameter("@客户代码", SqlDbType.VarChar, 30), new SqlParameter("@客户信息", SqlDbType.VarChar, 100), new SqlParameter("@录入员", SqlDbType.VarChar, 20), new SqlParameter("@录入时间", SqlDbType.VarChar, 50) }; parameters[0].Value = model.id; parameters[1].Value = model.客户代码; parameters[2].Value = model.客户信息; parameters[3].Value = model.录入员; parameters[4].Value = model.录入时间; int rows = dbhelper3.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
protected void btnconfirm_Click(object sender, EventArgs e) { string services = ddlServices.SelectedValue; if (string.IsNullOrEmpty(services)) { Response.Write("<Script Language=JavaScript>alert('" + App_GlobalResources.Language.Tip_SelectServices + "!');</Script>"); return; } string servicesState = ddlServicesState.SelectedValue; if (string.IsNullOrEmpty(servicesState)) { Response.Write("<Script Language=JavaScript>alert('" + App_GlobalResources.Language.Tip_SetState + "');</Script>"); return; } string sql = string.Format("UPDATE OPENQUERY(LKSV_2_GameCoreDB_0_1,'SELECT * FROM T_BattleZone WHERE F_ZoneID={0}') SET F_ZoneAttrib={1}", services, servicesState); int res = DBHelperDigGameDB.ExecuteSql(sql); if (res > 0) { bind(); 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="model"></param> /// <returns></returns> public bool Add(tsuhan_gt_cpbm model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into tsuhan_gt_cpbm("); strSql.Append("成品编码,录入员,时间)"); strSql.Append(" values ("); strSql.Append("@成品编码,@录入员,@时间)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@成品编码", SqlDbType.NVarChar, 30), new SqlParameter("@录入员", SqlDbType.NVarChar, 10), new SqlParameter("@时间", SqlDbType.DateTime) }; parameters[0].Value = model.成品编码; parameters[1].Value = model.录入员; parameters[2].Value = model.时间; int rows = dbhelper1.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
public static bool Add(Model.User user) { string cmd = "insert into [User] (username,password,name) VALUES (@username,@password,@name)"; SqlParameter[] p = new SqlParameter[] { new SqlParameter("username", SqlDbType.NVarChar, 50), new SqlParameter("password", SqlDbType.NVarChar, 50), new SqlParameter("name", SqlDbType.NVarChar, 50), }; p[0].Value = user.username; p[1].Value = user.password; p[2].Value = user.name; return(helper.ExecuteSql(cmd, p) > 0); }
public static bool Add(Model.UrlInfo model) { string cmd = "insert into [UrlInfo] (Id,Region,Url) VALUES (@id,@region,@url) "; SqlParameter[] p = new SqlParameter[] { new SqlParameter("Id", SqlDbType.UniqueIdentifier, 16), new SqlParameter("Region", SqlDbType.NVarChar, 50), new SqlParameter("Url", SqlDbType.NVarChar, -1) }; p[0].Value = model.Id = Guid.NewGuid(); p[1].Value = model.Region; p[2].Value = model.Url; return(helper.ExecuteSql(cmd, p) > 0); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(yinxiang.Model.t_Item_XS_Base_New model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update t_Item_XS_Base_New set "); strSql.Append("产品代码=@产品代码,"); strSql.Append("产品名称=@产品名称,"); strSql.Append("肉品系数=@肉品系数,"); strSql.Append("人工系数=@人工系数,"); strSql.Append("车间类别=@车间类别,"); strSql.Append("备注=@备注,"); strSql.Append("OrderID=@OrderID,"); strSql.Append("气调系数=@气调系数"); strSql.Append(" where FID=@FID"); SqlParameter[] parameters = { new SqlParameter("@产品代码", SqlDbType.VarChar, 100), new SqlParameter("@产品名称", SqlDbType.VarChar, 100), new SqlParameter("@肉品系数", SqlDbType.Float, 8), new SqlParameter("@人工系数", SqlDbType.Float, 8), new SqlParameter("@车间类别", SqlDbType.VarChar, 50), new SqlParameter("@备注", SqlDbType.VarChar, 500), new SqlParameter("@OrderID", SqlDbType.Float, 8), new SqlParameter("@气调系数", SqlDbType.Float, 8), new SqlParameter("@FID", SqlDbType.Int, 4) }; parameters[0].Value = model.产品代码; parameters[1].Value = model.产品名称; parameters[2].Value = model.肉品系数; parameters[3].Value = model.人工系数; parameters[4].Value = model.车间类别; parameters[5].Value = model.备注; parameters[6].Value = model.OrderID; parameters[7].Value = model.气调系数; parameters[8].Value = model.FID; //DbHelperSQLP DbHelperSQLP = new DbHelperSQLP(PubConstant.GetConnectionString("ConnectionString_RY")); int rows = DbHelperSQLP.ExecuteSql(strSql.ToString(), parameters); //int rows=DbHelperSQL.ExecuteSql(strSql.ToString(),parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(MES.Server.Model.User_JDS_Test_Good model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update User_JDS_Test_Good set "); strSql.Append("TestDate=@TestDate,"); strSql.Append("PartNumber=@PartNumber,"); strSql.Append("SN=@SN,"); strSql.Append("Result=@Result,"); strSql.Append("Wave=@Wave,"); strSql.Append("IL_A=@IL_A,"); strSql.Append("Refl_A=@Refl_A,"); strSql.Append("IL_B=@IL_B,"); strSql.Append("Refl_B=@Refl_B"); strSql.Append(" where ID_Key=@ID_Key"); SqlParameter[] parameters = { new SqlParameter("@TestDate", SqlDbType.VarChar, 25), new SqlParameter("@PartNumber", SqlDbType.VarChar, 50), new SqlParameter("@SN", SqlDbType.VarChar, 35), new SqlParameter("@Result", SqlDbType.VarChar, 10), new SqlParameter("@Wave", SqlDbType.VarChar, 10), new SqlParameter("@IL_A", SqlDbType.VarChar, 10), new SqlParameter("@Refl_A", SqlDbType.VarChar, 10), new SqlParameter("@IL_B", SqlDbType.VarChar, 10), new SqlParameter("@Refl_B", SqlDbType.VarChar, 10), new SqlParameter("@ID_Key", SqlDbType.Decimal, 9) }; parameters[0].Value = model.TestDate; parameters[1].Value = model.PartNumber; parameters[2].Value = model.SN; parameters[3].Value = model.Result; parameters[4].Value = model.Wave; parameters[5].Value = model.IL_A; parameters[6].Value = model.Refl_A; parameters[7].Value = model.IL_B; parameters[8].Value = model.Refl_B; parameters[9].Value = model.ID_Key; int rows = TwoLineCon.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(Maticsoft.Model.tsuhan_scgl_fx model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into tsuhan_scgl_fx("); strSql.Append("序列号,客户,型号,成品编码,原因,工位,处理方式,不良现象,次数,关联码,进时间,出时间)"); strSql.Append(" values ("); strSql.Append("@序列号,@客户,@型号,@成品编码,@原因,@工位,@处理方式,@不良现象,@次数,@关联码,@进时间,@出时间)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@序列号", SqlDbType.NVarChar, 20), new SqlParameter("@客户", SqlDbType.NVarChar, 20), new SqlParameter("@型号", SqlDbType.NVarChar, 20), new SqlParameter("@成品编码", SqlDbType.NVarChar, 30), new SqlParameter("@原因", SqlDbType.NVarChar, 50), new SqlParameter("@工位", SqlDbType.NVarChar, 20), new SqlParameter("@处理方式", SqlDbType.NVarChar, 50), new SqlParameter("@不良现象", SqlDbType.NVarChar, 50), new SqlParameter("@次数", SqlDbType.Int, 4), new SqlParameter("@关联码", SqlDbType.NVarChar, 20), new SqlParameter("@进时间", SqlDbType.DateTime, 8), new SqlParameter("@出时间", SqlDbType.DateTime, 8) }; parameters[0].Value = model.序列号; parameters[1].Value = model.客户; parameters[2].Value = model.型号; parameters[3].Value = model.成品编码; parameters[4].Value = model.原因; parameters[5].Value = model.工位; parameters[6].Value = model.处理方式; parameters[7].Value = model.良现象; parameters[8].Value = model.次数; parameters[9].Value = model.关联码; parameters[10].Value = model.进时间; parameters[11].Value = model.出时间; int rows = dbhelper1.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 修改 /// </summary> /// <param name="model"></param> /// <returns></returns> public bool Update1(baozhuang_chuhuo model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update baozhuang_chuhuo set "); strSql.Append("备货单=@备货单,"); strSql.Append("出货日期=@出货日期,"); strSql.Append("出货数量=@出货数量"); strSql.Append(" where 备货单=@备货单 and 出货日期=@出货日期"); SqlParameter[] parameters = { new SqlParameter("@备货单", SqlDbType.NVarChar, 20), new SqlParameter("@出货日期", SqlDbType.DateTime), new SqlParameter("@出货数量", SqlDbType.Int, 4) }; parameters[0].Value = model.备货单; parameters[1].Value = model.出货日期; parameters[2].Value = model.出货数量; int rows = dbhelper1.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Maticsoft.Model.tsuhan_scgl_cplx model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update tsuhan_scgl_cplx set "); strSql.Append("产品类型=@产品类型,"); strSql.Append("录入员=@录入员,"); strSql.Append("录入时间=@录入时间"); strSql.Append(" where id=@id"); SqlParameter[] parameters = { new SqlParameter("@产品类型", SqlDbType.VarChar, 100), new SqlParameter("@录入员", SqlDbType.VarChar, 50), new SqlParameter("@录入时间", SqlDbType.DateTime), new SqlParameter("@id", SqlDbType.Int, 4) }; parameters[0].Value = model.产品类型; parameters[1].Value = model.录入员; parameters[2].Value = model.录入时间; parameters[3].Value = model.id; int rows = dbhelper3.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 清除Login对象占用任务 /// </summary> /// <param name="strConn"></param> protected void ClearUATask(BaseData bd) { DbHelperSQLP dsp = new DbHelperSQLP(bd.ConnectInfo.Constring); string sql = string.Format("DELETE UFSystem..ua_Task WHERE cStation='{0}' AND cUser_Id='{1}' AND cAcc_Id='{2}' ", bd.ConnectInfo.Srv, bd.ConnectInfo.UserId, bd.ConnectInfo.AccId); dsp.ExecuteSql(sql); }
/// <summary> /// 删除 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void lbtDelete_Click(object sender, EventArgs e) { var _sender = sender as LinkButton; if (_sender != null) { //获取要删除数据ID string ID = _sender.Attributes["_InfoID"]; if (string.IsNullOrEmpty(ID)) { Response.Write("<Script Language=JavaScript>alert('" + App_GlobalResources.Language.Tip_Failure + "');</Script>"); return; } string sql = string.Format("SELECT [F_ID],[F_PreDutyMan],[F_TUseData] FROM [dbo].[T_Tasks] WHERE F_Type=20000217 AND F_ID={0}", ID); ds = DBHelperGSSDB.Query(sql); if (ds == null || ds.Tables.Count == 0 || ds.Tables[0].Rows.Count == 0) { Response.Write("<Script Language=JavaScript>alert('" + App_GlobalResources.Language.Tip_OrderIsDelete + "');</Script>"); return; } string DBID = ds.Tables[0].Rows[0]["F_PreDutyMan"].ToString(); string battleZone = ds.Tables[0].Rows[0]["F_TUseData"].ToString(); string[] arrayBattleZone = battleZone.Split(';'); for (int i = 0; i < arrayBattleZone.Length; i++) { if (!string.IsNullOrEmpty(arrayBattleZone[i])) { sql = string.Format("DELETE FROM OPENQUERY([LKSV_7_gspara_db_0_{0}],'SELECT * FROM sys_loss_award_table WHERE DBID={1}')", arrayBattleZone[i], DBID); DBHelperGSSDB.ExecuteSql(sql); } } sql = string.Format("DELETE FROM [dbo].[T_Tasks] WHERE F_Type=20000217 AND F_ID={0}", ID); int res = DBHelperGSSDB.ExecuteSql(sql); if (res > 0) { bind(); sql = string.Format("INSERT INTO [dbo].[T_OpLog] ([F_Module], [F_OPID], [F_TaskID], [F_User], [F_CreateTime]) VALUES (N'全服邮件', N'Delete', {0},N'{1}', GETDATE())", ID, Session["LoginUser"].ToString()); DBHelperDigGameDB.ExecuteSql(sql); 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="bd"></param> /// <param name="dt"></param> /// <returns></returns> public override Model.DealResult UndoMake(BaseData bd, Model.Synergismlogdt dt) { Model.DealResult dr = new Model.DealResult(); dr = base.UndoMake(bd, dt); string vouchid = this.GetCodeorID(dt.Cvoucherno, bd, "id"); string sql1 = string.Format("delete PU_ArrivalVouch_ExtraDefine where id='{0}'", vouchid); string sql2 = string.Format("delete PU_ArrivalVouchs where id='{0}'", vouchid); string sql3 = string.Format("delete PU_ArrivalVouch where id='{0}'", vouchid); try { DbHelperSQLP help = new DbHelperSQLP(bd.ConnectInfo.Constring); help.ExecuteSql(sql1); help.ExecuteSql(sql2); help.ExecuteSql(sql3); } catch { } return(dr); }
/// <summary> /// 执行sql并弹窗 /// </summary> /// <param name="sql"></param> private void ExecuteAndAlter(string sql) { int result = DBHelperGameCoreDB.ExecuteSql(sql); if (result > 0) { //this.Response.Write("<script language=javascript>ALTER('操作成功')</script>"); } else { } }
protected void btnGM_Click(object sender, EventArgs e) { //角色ID string roleID = tbGMContent.Text.Trim(); //判断角色ID if (string.IsNullOrEmpty(roleID)) { Response.Write("<Script Language=JavaScript>alert('" + App_GlobalResources.Language.Tip_WriteRoleID + "');</Script>"); return; } //获取用户ID 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 [F_UserID],[F_GMName],[F_GMPassWord],[F_IP],[F_RightLevel] FROM [T_GameManager] WHERE [F_UserID]={0}", userID); ds = DBHelperGameCoreDB.Query(sql); if (ds != null && ds.Tables[0].Rows.Count > 0) { Response.Write("<Script Language=JavaScript>alert('" + App_GlobalResources.Language.Tip_GmIsExist + "');</Script>"); return; } sql = string.Format("INSERT INTO [T_GameManager] ([F_UserID], [F_GMName], [F_GMPassWord], [F_IP], [F_RightLevel]) VALUES ({0}, '{1}', '{2}', '{3}', 9)", userID, userName, gmPassWord, gmIP); int res = DBHelperGameCoreDB.ExecuteSql(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>"); } }
public static bool Add(Model.Data model) { string cmd = "insert into [Data] (Id,ProjectName,WinCom,Money,Time) VALUES (@Id,@ProjectName,@WinCom,@Money,@Time)"; SqlParameter[] p = new SqlParameter[] { new SqlParameter("Id", SqlDbType.UniqueIdentifier, 16), new SqlParameter("ProjectName", SqlDbType.NVarChar, 100), new SqlParameter("WinCom", SqlDbType.NVarChar, 50), new SqlParameter("Money", SqlDbType.Int), new SqlParameter("Time", SqlDbType.Date), }; p[0].Value = model.Id = Guid.NewGuid(); p[1].Value = model.ProjectName; p[2].Value = model.WinCom; p[3].Value = model.Money; p[4].Value = model.Time; return(helper.ExecuteSql(cmd, p) > 0); }
/// <summary> /// 生单 /// </summary> /// <param name="bd"></param> /// <returns></returns> public override Model.DealResult MakeVouch(BaseData bd) { Model.DealResult dr = base.MakeVouch(bd); string sql = string.Empty; string ccuspersoncode = string.Empty; string ccusperson = string.Empty; sql = " select cContactCode,cContactName from Crm_Contact where cCusCode =(select cCusCode from DispatchList where DLID = '" + dr.VouchIdRet + "')"; DbHelperSQLP help = new DbHelperSQLP(bd.ConnectInfo.Constring); DataSet ds = help.Query(sql); if (ds.Tables[0].Rows.Count > 0) { //设置客户联系人编码,客户联系人 ccuspersoncode = ds.Tables[0].Rows[0]["cContactCode"].ToString(); ccusperson = ds.Tables[0].Rows[0]["cContactName"].ToString(); sql = "update DispatchList set ccuspersoncode='" + ccuspersoncode + "',ccusperson ='" + ccusperson + "' where DLID = '" + dr.VouchIdRet + "'"; help.ExecuteSql(sql); } return(dr); }
public SMSSendResult SendSms(string mobile, string message, string sign, string user) { SMSSendResult result = new SMSSendResult(); try { Guid id = Guid.NewGuid(); var re = msService.SendOneMessage(mobile, message, sign, id.ToString(), int.Parse(target)); if (re != "") { result.success = false; result.info = re; } else { result.success = true; result.info = "发送成功"; try { string str = string.Format("insert into dbo.SMSSendBase(Id,Phone,Message,State,CreateDate,CreateUserId,SenderMark,SendCount,SendState,UnitPrice,UpdateDate,TaskId," + "ClientName,SmsTempletName,Templet_Id,Category,BatchId) values('{0}','{1}','{2}',1,getdate(),'{3}',{4},1,0,0.07,getdate(),'{3}','{5}','{6}','{3}','CFC','{0}');", id, mobile, message, Guid.Empty, target, sign, user); db.ExecuteSql(str); } catch (Exception ex) { result.info = "入库失败!"; } } return(result); } catch (Exception ex) { result.success = false; result.info = ex.Message; return(result); } }
/// <summary> /// 测试U8登录 /// source = "(default)" /// </summary> /// <returns></returns> public static int TestU8Login(string sqlconnection, string ServerName, string source, string accid, string userid, string pwd, string yearid, string date, out string errmsg) { Model.DealResult dr = new Model.DealResult(); U8Login.clsLogin u8Login = new U8Login.clsLogin(); #region 判断格式 登录 string strErr = ",请在[账套档案注册]模块中更新!"; if (string.IsNullOrEmpty(userid)) { dr.ResultMsg = "默认操作员不能为空" + strErr; dr.ResultNum = -1; Marshal.FinalReleaseComObject(u8Login); throw new Exception(dr.ResultMsg); } if (string.IsNullOrEmpty(source)) { dr.ResultMsg = "数据源不能为空" + strErr; dr.ResultNum = -1; Marshal.FinalReleaseComObject(u8Login); throw new Exception(dr.ResultMsg); } if (string.IsNullOrEmpty(accid)) { dr.ResultMsg = "账套号不能为空" + strErr; dr.ResultNum = -1; Marshal.FinalReleaseComObject(u8Login); throw new Exception(dr.ResultMsg); } if (string.IsNullOrEmpty(ServerName)) { dr.ResultMsg = "服务器地址不能为空" + strErr; dr.ResultNum = -1; Marshal.FinalReleaseComObject(u8Login); throw new Exception(dr.ResultMsg); } if (string.IsNullOrEmpty(yearid)) { dr.ResultMsg = "登陆年度不能为空" + strErr; dr.ResultNum = -1; Marshal.FinalReleaseComObject(u8Login); throw new Exception(dr.ResultMsg); } else { try { int.Parse(yearid); } catch { dr.ResultMsg = "登陆年度格式错误:" + yearid + strErr; dr.ResultNum = -1; Marshal.FinalReleaseComObject(u8Login); throw new Exception(dr.ResultMsg); } } if (!string.IsNullOrEmpty(sqlconnection)) { DbHelperSQLP dsp = new DbHelperSQLP(sqlconnection); string strSql = "SELECT 1 FROM UFSystem.dbo.UA_AccountDatabase A JOIN UFSystem.dbo.UA_Account B ON A.cAcc_Id=B.cAcc_Id WHERE A.cAcc_Id='" + accid + "' "; if (!dsp.Exists(strSql)) { dr.ResultMsg = "登陆失败,原因:账套 " + accid + " 在 " + ServerName + " 上不存在"; dr.ResultNum = -1; Marshal.FinalReleaseComObject(u8Login); errmsg = dr.ResultMsg; return(-1); } } #endregion string subId = U8.Interface.Bus.SysInfo.subId; string userId = userid; string accId = source + "@" + accid; string yearId = yearid; // DateTime.Now.ToString("yyyy"); // yearid; string password = pwd; string _date = date; // DateTime.Now.ToString("yyyy-MM-dd"); //bd.ConnectInfo.Date; string srv = ServerName; string serial = BLL.Common.GetSerial(); #region 20140814 #endregion if (!u8Login.Login(ref subId, ref accId, ref yearId, ref userId, ref password, ref _date, ref srv, ref serial)) { dr.ResultMsg = "登陆失败,原因:" + u8Login.ShareString; if (u8Login.ShareString.IndexOf("年度") > 0 || u8Login.ShareString.IndexOf("日期") > 0) { dr.ResultMsg += " - " + _date; } dr.ResultNum = -1; Marshal.FinalReleaseComObject(u8Login); errmsg = dr.ResultMsg; return(-1); } //清除站点 if (!string.IsNullOrEmpty(sqlconnection)) { DbHelperSQLP dsp = new DbHelperSQLP(sqlconnection); string sql = string.Format("DELETE UFSystem..ua_Task WHERE cStation='{0}' AND cUser_Id='{1}' AND cAcc_Id='{2}' ", ServerName, userId, accId); dsp.ExecuteSql(sql); } errmsg = null; return(1); }
/// <summary> /// 确认 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnConfirm_Click(object sender, EventArgs e) { if (string.IsNullOrEmpty(tbContent.Text.Trim())) { lblinfo.Text = App_GlobalResources.Language.Tip_RoleIDOrRoleName; return; } string transactionID = string.IsNullOrEmpty(TransactionID.Text.Trim()) ? "0" : TransactionID.Text.Trim(); string gold = string.IsNullOrEmpty(Gold.Text.Trim()) ? "0" : Gold.Text.Trim(); string bindGold = string.IsNullOrEmpty(BindGold.Text.Trim()) ? "0" : BindGold.Text.Trim(); string money = string.IsNullOrEmpty(Money.Text.Trim()) ? "0" : Money.Text.Trim(); string bindMoney = string.IsNullOrEmpty(BindMoney.Text.Trim()) ? "0" : BindMoney.Text.Trim(); string item1 = string.IsNullOrEmpty(Item1.Text.Trim()) ? "0" : Item1.Text.Trim(); string item1Num = string.IsNullOrEmpty(Item1Num.Text.Trim()) ? "0" : Item1Num.Text.Trim(); string item2 = string.IsNullOrEmpty(Item2.Text.Trim()) ? "0" : Item2.Text.Trim(); string item2Num = string.IsNullOrEmpty(Item2Num.Text.Trim()) ? "0" : Item2Num.Text.Trim(); string item3 = string.IsNullOrEmpty(Item3.Text.Trim()) ? "0" : Item3.Text.Trim(); string item3Num = string.IsNullOrEmpty(Item3Num.Text.Trim()) ? "0" : Item3Num.Text.Trim(); string item4 = string.IsNullOrEmpty(Item4.Text.Trim()) ? "0" : Item4.Text.Trim(); string item4Num = string.IsNullOrEmpty(Item4Num.Text.Trim()) ? "0" : Item4Num.Text.Trim(); string item5 = string.IsNullOrEmpty(Item5.Text.Trim()) ? "0" : Item5.Text.Trim(); string item5Num = string.IsNullOrEmpty(Item5Num.Text.Trim()) ? "0" : Item5Num.Text.Trim(); int isUseMail = ckbSendEmail.Checked ? 1 : 0; string mailTitle = "0"; string txtMailSendName = "0"; string txtMailContent = "0"; if (isUseMail == 1) { mailTitle = this.mailTitle.Text.Trim(); txtMailSendName = this.txtMailSendName.Text.Trim(); txtMailContent = this.txtMailContent.Text.Trim(); } try { string txt = tbContent.Text.Trim(); string sql = string.Empty; if (rbtRoleID.Checked) { sql = string.Format("SELECT F_RoleID,F_ZoneID FROM(SELECT F_RoleID,F_ZoneID FROM LKSV_2_GameCoreDB_0_1.Gamecoredb.dbo.T_RoleBaseData_0 WHERE F_RoleID={0} UNION ALL SELECT F_RoleID,F_ZoneID FROM LKSV_2_GameCoreDB_0_1.Gamecoredb.dbo.T_RoleBaseData_1 WHERE F_RoleID={1} UNION ALL SELECT F_RoleID,F_ZoneID FROM LKSV_2_GameCoreDB_0_1.Gamecoredb.dbo.T_RoleBaseData_2 WHERE F_RoleID={2} UNION ALL SELECT F_RoleID,F_ZoneID FROM LKSV_2_GameCoreDB_0_1.Gamecoredb.dbo.T_RoleBaseData_3 WHERE F_RoleID={3} UNION ALL SELECT F_RoleID,F_ZoneID FROM LKSV_2_GameCoreDB_0_1.Gamecoredb.dbo.T_RoleBaseData_4 WHERE F_RoleID={4})TEPM", txt, txt, txt, txt, txt); } else { sql = string.Format("SELECT F_RoleID,F_ZoneID FROM(SELECT F_RoleID,F_ZoneID FROM LKSV_2_GameCoreDB_0_1.Gamecoredb.dbo.T_RoleBaseData_0 WHERE F_RoleName=N'{0}' UNION ALL SELECT F_RoleID,F_ZoneID FROM LKSV_2_GameCoreDB_0_1.Gamecoredb.dbo.T_RoleBaseData_1 WHERE F_RoleName=N'{1}' UNION ALL SELECT F_RoleID,F_ZoneID FROM LKSV_2_GameCoreDB_0_1.Gamecoredb.dbo.T_RoleBaseData_2 WHERE F_RoleName=N'{2}' UNION ALL SELECT F_RoleID,F_ZoneID FROM LKSV_2_GameCoreDB_0_1.Gamecoredb.dbo.T_RoleBaseData_3 WHERE F_RoleName=N'{3}' UNION ALL SELECT F_RoleID,F_ZoneID FROM LKSV_2_GameCoreDB_0_1.Gamecoredb.dbo.T_RoleBaseData_4 WHERE F_RoleName=N'{4}')TEPM", txt, txt, txt, txt, txt); } ds = DBHelperDigGameDB.Query(sql); if (ds != null && ds.Tables[0].Rows.Count > 0) { string roleID = ds.Tables[0].Rows[0]["F_RoleID"].ToString(); string zoneID = ds.Tables[0].Rows[0]["F_ZoneID"].ToString(); sql = string.Format("INSERT INTO OPENQUERY(LKSV_3_gsdata_db_0_" + zoneID + ",'SELECT GlobalID,transactionID,CostGold,CostBindGold,CostMoney,CostBindMoney,ItemID1,ItemNum1,ItemID2,ItemNum2,ItemID3,ItemNum3,ItemID4,ItemNum4,ItemID5,ItemNum5,F_IS_Use_Mail,F_Mail_Title,F_Mail_Content,F_Sender_Name,State,AddTime FROM COSTPLAYERGOLDTABLE WHERE 1=0') VALUES({0},{1},{2},{3},{4},{5},{6},{7},{8},{9},{10},{11},{12},{13},{14},{15},{16},N'{17}',N'{18}',N'{19}',{20},'{21}')", roleID, transactionID, gold, bindGold, money, bindMoney, item1, item1Num, item2, item2Num, item3, item3Num, item4, item4Num, item5, item5Num, isUseMail, mailTitle, txtMailContent, txtMailSendName, 0, DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss")); int res = DBHelperDigGameDB.ExecuteSql(sql); if (res > 0) { sql = string.Format("INSERT INTO [dbo].[T_CostPlayerGoldLog] ([GlobalID], [CostGold], [CostBindGold], [CostMoney], [CostBindMoney], [ItemID1], [ItemNum1], [ItemID2], [ItemNum2], [ItemID3], [ItemNum3], [ItemID4], [ItemNum4], [ItemID5], [ItemNum5], [F_IS_Use_Mail], [F_Mail_Title], [F_Mail_Content], [F_Sender_Name], [AddTime], [AddUser]) VALUES ({0},{1},{2},{3},{4},{5},{6},{7},{8},{9},{10},{11},{12},{13},{14},{15},N'{16}',N'{17}',N'{18}',GETDATE(),'{19}')", roleID, gold, bindGold, money, bindMoney, item1, item1Num, item2, item2Num, item3, item3Num, item4, item4Num, item5, item5Num, isUseMail, mailTitle, txtMailContent, txtMailSendName, "登录人"); DBHelperDigGameDB.ExecuteSql(sql); lblinfo.Text = App_GlobalResources.Language.Tip_Success; } else { lblinfo.Text = App_GlobalResources.Language.Tip_Failure; } } else { lblinfo.Text = App_GlobalResources.Language.Tip_SearchInfo; return; } } catch (Exception ex) { lblinfo.Text = ex.Message; } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(MES.Server.Model.User_3D_Test_Good model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update User_3D_Test_Good set "); strSql.Append("SN=@SN,"); strSql.Append("Name=@Name,"); strSql.Append("Type=@Type,"); strSql.Append("Result=@Result,"); strSql.Append("Curvature=@Curvature,"); strSql.Append("Curvature_Result=@Curvature_Result,"); strSql.Append("Spherical=@Spherical,"); strSql.Append("Spherical_Result=@Spherical_Result,"); strSql.Append("Planar=@Planar,"); strSql.Append("Planar_Result=@Planar_Result,"); strSql.Append("Apex_Offset=@Apex_Offset,"); strSql.Append("Apex_Offset_Result=@Apex_Offset_Result,"); strSql.Append("Bearing=@Bearing,"); strSql.Append("Bearing_Result=@Bearing_Result,"); strSql.Append("Apex_Angle=@Apex_Angle,"); strSql.Append("Apex_Angle_Result=@Apex_Angle_Result,"); strSql.Append("Tilt_Offset=@Tilt_Offset,"); strSql.Append("Tilt_Offset_Result=@Tilt_Offset_Result,"); strSql.Append("Tilt_Angle=@Tilt_Angle,"); strSql.Append("Tilt_Angle_Result=@Tilt_Angle_Result,"); strSql.Append("KeyError=@KeyError,"); strSql.Append("KeyError_Result=@KeyError_Result,"); strSql.Append("FiberRq=@FiberRq,"); strSql.Append("FiberRq_Result=@FiberRq_Result,"); strSql.Append("FiberRa=@FiberRa,"); strSql.Append("FiberRa_Result=@FiberRa_Result,"); strSql.Append("FerruleRq=@FerruleRq,"); strSql.Append("FerruleRq_Result=@FerruleRq_Result,"); strSql.Append("FerruleRa=@FerruleRa,"); strSql.Append("FerruleRa_Result=@FerruleRa_Result,"); strSql.Append("Diameter=@Diameter,"); strSql.Append("Diameter_Result=@Diameter_Result,"); strSql.Append("Test_Date=@Test_Date,"); strSql.Append("Test_Time=@Test_Time,"); strSql.Append("D=@D,"); strSql.Append("E=@E,"); strSql.Append("F=@F,"); strSql.Append("A=@A"); strSql.Append(" where ID_Key=@ID_Key"); SqlParameter[] parameters = { new SqlParameter("@SN", SqlDbType.VarChar, 25), new SqlParameter("@Name", SqlDbType.VarChar, 35), new SqlParameter("@Type", SqlDbType.VarChar, 35), new SqlParameter("@Result", SqlDbType.VarChar, 8), new SqlParameter("@Curvature", SqlDbType.VarChar, 15), new SqlParameter("@Curvature_Result", SqlDbType.VarChar, 6), new SqlParameter("@Spherical", SqlDbType.VarChar, 15), new SqlParameter("@Spherical_Result", SqlDbType.VarChar, 6), new SqlParameter("@Planar", SqlDbType.VarChar, 15), new SqlParameter("@Planar_Result", SqlDbType.VarChar, 6), new SqlParameter("@Apex_Offset", SqlDbType.VarChar, 15), new SqlParameter("@Apex_Offset_Result", SqlDbType.VarChar, 6), new SqlParameter("@Bearing", SqlDbType.VarChar, 15), new SqlParameter("@Bearing_Result", SqlDbType.VarChar, 6), new SqlParameter("@Apex_Angle", SqlDbType.VarChar, 15), new SqlParameter("@Apex_Angle_Result", SqlDbType.VarChar, 6), new SqlParameter("@Tilt_Offset", SqlDbType.VarChar, 15), new SqlParameter("@Tilt_Offset_Result", SqlDbType.VarChar, 6), new SqlParameter("@Tilt_Angle", SqlDbType.VarChar, 15), new SqlParameter("@Tilt_Angle_Result", SqlDbType.VarChar, 6), new SqlParameter("@KeyError", SqlDbType.VarChar, 15), new SqlParameter("@KeyError_Result", SqlDbType.VarChar, 6), new SqlParameter("@FiberRq", SqlDbType.VarChar, 15), new SqlParameter("@FiberRq_Result", SqlDbType.VarChar, 6), new SqlParameter("@FiberRa", SqlDbType.VarChar, 15), new SqlParameter("@FiberRa_Result", SqlDbType.VarChar, 6), new SqlParameter("@FerruleRq", SqlDbType.VarChar, 15), new SqlParameter("@FerruleRq_Result", SqlDbType.VarChar, 6), new SqlParameter("@FerruleRa", SqlDbType.VarChar, 15), new SqlParameter("@FerruleRa_Result", SqlDbType.VarChar, 6), new SqlParameter("@Diameter", SqlDbType.VarChar, 15), new SqlParameter("@Diameter_Result", SqlDbType.VarChar, 6), new SqlParameter("@Test_Date", SqlDbType.VarChar, 35), new SqlParameter("@Test_Time", SqlDbType.VarChar, 35), new SqlParameter("@D", SqlDbType.VarChar, 15), new SqlParameter("@E", SqlDbType.VarChar, 15), new SqlParameter("@F", SqlDbType.VarChar, 15), new SqlParameter("@A", SqlDbType.VarChar, 15), new SqlParameter("@ID_Key", SqlDbType.Decimal, 9) }; parameters[0].Value = model.SN; parameters[1].Value = model.Name; parameters[2].Value = model.Type; parameters[3].Value = model.Result; parameters[4].Value = model.Curvature; parameters[5].Value = model.Curvature_Result; parameters[6].Value = model.Spherical; parameters[7].Value = model.Spherical_Result; parameters[8].Value = model.Planar; parameters[9].Value = model.Planar_Result; parameters[10].Value = model.Apex_Offset; parameters[11].Value = model.Apex_Offset_Result; parameters[12].Value = model.Bearing; parameters[13].Value = model.Bearing_Result; parameters[14].Value = model.Apex_Angle; parameters[15].Value = model.Apex_Angle_Result; parameters[16].Value = model.Tilt_Offset; parameters[17].Value = model.Tilt_Offset_Result; parameters[18].Value = model.Tilt_Angle; parameters[19].Value = model.Tilt_Angle_Result; parameters[20].Value = model.KeyError; parameters[21].Value = model.KeyError_Result; parameters[22].Value = model.FiberRq; parameters[23].Value = model.FiberRq_Result; parameters[24].Value = model.FiberRa; parameters[25].Value = model.FiberRa_Result; parameters[26].Value = model.FerruleRq; parameters[27].Value = model.FerruleRq_Result; parameters[28].Value = model.FerruleRa; parameters[29].Value = model.FerruleRa_Result; parameters[30].Value = model.Diameter; parameters[31].Value = model.Diameter_Result; parameters[32].Value = model.Test_Date; parameters[33].Value = model.Test_Time; parameters[34].Value = model.D; parameters[35].Value = model.E; parameters[36].Value = model.F; parameters[37].Value = model.A; parameters[38].Value = model.ID_Key; int rows = TwoLineCon.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 运行公告 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void lbtStart_Click(object sender, EventArgs e) { var _sender = sender as LinkButton; if (_sender != null) { //获取要删除数据ID string ID = _sender.Attributes["_InfoID"]; if (string.IsNullOrEmpty(ID)) { Response.Write("<Script Language=JavaScript>alert('" + App_GlobalResources.Language.Tip_Failure + "');</Script>"); return; } string sql = string.Format("SELECT * FROM T_Tasks WHERE F_Type=20000213 AND F_ID={0}", ID); ds = DBHelperGSSDB.Query(sql); if (ds == null || ds.Tables.Count == 0 || ds.Tables[0].Rows.Count == 0) { Response.Write("<Script Language=JavaScript>alert('" + App_GlobalResources.Language.Tip_OrderNotExisit + "');</Script>"); return; } string strTaskID = ds.Tables[0].Rows[0]["F_PreDutyMan"].ToString(); string strContentInfo = ds.Tables[0].Rows[0]["F_URInfo"].ToString(); string strBattleZone = ds.Tables[0].Rows[0]["F_TUseData"].ToString(); string sendBattleZone = string.Empty; int rowcount = 0; try { sql = @"select 1 FROM T_GameNotice with(nolock) WHERE (F_TaskID = " + strTaskID + ") and F_TaskState = 1"; rowcount = DBHelperGameCoreDB.ExecuteSql(sql); if (rowcount > 0) { Response.Write("<Script Language=JavaScript>alert('" + App_GlobalResources.Language.Tip_RunNoticeIsRun + "');</Script>"); return; } sql = @"delete FROM T_GameNotice WHERE (F_TaskID = " + strTaskID + ")"; DBHelperGameCoreDB.ExecuteSql(sql); int res = 0; string[] arrayNoticeInfo = strContentInfo.Split('|'); string[] arrayBattleZone = strBattleZone.Split(';'); for (int i = 0; i < arrayBattleZone.Length; i++) { sql = @"INSERT INTO T_GameNotice (F_ReciveZone, F_ReciveLine, F_ReciveObject, F_MSGLocation, F_Message, F_RunTimeBegin, F_RunTimeEnd, F_RunInterval, F_TaskState,F_TaskID, F_NoticeTimes) VALUES (" + arrayBattleZone[i] + ",-1,N'" + arrayNoticeInfo[1] + "', " + arrayNoticeInfo[2] + ", N'" + arrayNoticeInfo[0] + "', '" + arrayNoticeInfo[3] + "', '" + arrayNoticeInfo[4] + "', " + arrayNoticeInfo[5] + ", 1, " + strTaskID + ", 0)"; res += DBHelperGameCoreDB.ExecuteSql(sql); sendBattleZone += arrayBattleZone[i] + ";"; } if (res == arrayBattleZone.Length) { sql = string.Format("UPDATE T_Tasks SET F_TToolUsed=1 WHERE F_ID={0}", ID); DBHelperGSSDB.ExecuteSql(sql); bind(); Response.Write("<Script Language=JavaScript>alert('" + App_GlobalResources.Language.Tip_Success + "');</Script>"); } else { Response.Write("<Script Language=JavaScript>alert('" + App_GlobalResources.Language.Tip_Failure + ";发送成功的战区:" + sendBattleZone + "');</Script>"); } } catch (System.Exception ex) { lblerro.Text = "运行公告失败;发送成功的战区:" + sendBattleZone + ";ErrorInfo:" + ex.Message; } } }
/// <summary> /// 删除 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void lbtDelete_Click(object sender, EventArgs e) { var _sender = sender as LinkButton; if (_sender != null) { //获取要删除数据ID string ID = _sender.Attributes["_InfoID"]; if (string.IsNullOrEmpty(ID)) { Response.Write("<Script Language=JavaScript>alert('" + App_GlobalResources.Language.Tip_Failure + "');</Script>"); return; } string sql = string.Format("SELECT [F_ID],[F_PreDutyMan],[F_TUseData] FROM [dbo].[T_Tasks] WHERE F_Type=20000214 AND F_ID={0}", ID); ds = DBHelperGSSDB.Query(sql); if (ds == null || ds.Tables.Count == 0 || ds.Tables[0].Rows.Count == 0) { Response.Write("<Script Language=JavaScript>alert('" + App_GlobalResources.Language.Tip_OrderIsDelete + "');</Script>"); return; } string taskID = ds.Tables[0].Rows[0]["F_PreDutyMan"].ToString(); if (string.IsNullOrEmpty(taskID)) { Response.Write("<Script Language=JavaScript>alert('" + App_GlobalResources.Language.Tip_OrderIsOverTime + "');</Script>"); return; } sql = string.Format("SELECT F_State FROM T_GiftAward_List WHERE F_TaskID={0}", taskID); ds = DBHelperGameCoreDB.Query(sql); if (ds == null || ds.Tables.Count == 0 || ds.Tables[0].Rows.Count == 0) { Response.Write("<Script Language=JavaScript>alert('" + App_GlobalResources.Language.Tip_OrderIsDelete + "');</Script>"); return; } string state = ds.Tables[0].Rows[0]["F_State"].ToString(); if (Convert.ToInt32(state) == 1) { sql = string.Format("DELETE FROM T_GiftAward_Gift WHERE F_TaskID={0}", taskID); DBHelperGameCoreDB.ExecuteSql(sql); sql = string.Format("DELETE FROM T_GiftAward_List WHERE F_TaskID={0}", taskID); DBHelperGameCoreDB.ExecuteSql(sql); sql = string.Format("DELETE FROM T_GiftAward_User WHERE F_TaskID={0}", taskID); DBHelperGameCoreDB.ExecuteSql(sql); } else { //todo Response.Write("<Script Language=JavaScript>alert('" + App_GlobalResources.Language.Tip_OrderIsOverTime + "');</Script>"); return; } sql = string.Format("DELETE FROM [dbo].[T_Tasks] WHERE F_Type=20000214 AND F_ID={0}", ID); int res = DBHelperGSSDB.ExecuteSql(sql); if (res > 0) { bind(); sql = string.Format("INSERT INTO [dbo].[T_OpLog] ([F_Module], [F_OPID], [F_TaskID], [F_User], [F_CreateTime]) VALUES (N'发奖工单', N'Delete', {0},N'{1}', GETDATE())", ID, Session["LoginUser"].ToString()); DBHelperDigGameDB.ExecuteSql(sql); 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 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) { } }
/// <summary> /// 查询 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnSerach_Click(object sender, EventArgs e) { string userID = this.tbUserID.Text.Trim(); if (string.IsNullOrEmpty(userID)) { Response.Write("<Script Language=JavaScript>alert('" + App_GlobalResources.Language.Tip_WriteUserID + "');</Script>"); return; } string roleID = this.tbRoleID.Text.Trim(); if (string.IsNullOrEmpty(roleID)) { Response.Write("<Script Language=JavaScript>alert('" + App_GlobalResources.Language.Tip_WriteRoleID + "');</Script>"); return; } string transactionID = this.tbTransactionID.Text.Trim(); if (string.IsNullOrEmpty(transactionID)) { Response.Write("<Script Language=JavaScript>alert('" + App_GlobalResources.Language.Tip_WritetransactionID + "');</Script>"); return; } string url = string.Format(koreaDepositVerifyURL, transactionID); string res = GetInfo(url); SerializeHelper sHelper = new SerializeHelper(); RootObject rb = sHelper.JsonDeserialize <RootObject>(res); if (rb == null) { lblinfo.Text = App_GlobalResources.Language.Tip_NoResule; return; } if (rb.code != "200") { lblinfo.Text = string.Format("{0} {1}", App_GlobalResources.Language.Tip_InfoError, res); return; } List <SqlParameter> param = new List <SqlParameter>(); param.Add(new SqlParameter("@GlobalID", SqlDbType.Int) { Value = roleID }); param.Add(new SqlParameter("@UserID", SqlDbType.Int) { Value = userID }); param.Add(new SqlParameter("@TransactionID", SqlDbType.Char) { Value = transactionID }); param.Add(new SqlParameter("@WebRequestResult", SqlDbType.Int) { Value = 1 }); param.Add(new SqlParameter("@Code", SqlDbType.Int) { Value = rb.code }); param.Add(new SqlParameter("@ProductID", SqlDbType.Int) { Value = rb.result_data.product.id }); param.Add(new SqlParameter("@StrReturn", SqlDbType.NVarChar) { Value = res }); param.Add(new SqlParameter("@StoreName", SqlDbType.Char) { Value = rb.result_data.store }); param.Add(new SqlParameter("@price", SqlDbType.Int) { Value = rb.result_data.product.price }); param.Add(new SqlParameter("@Result", SqlDbType.Int) { Direction = ParameterDirection.Output }); DBHelperUserCoreDB.RunProcedure("_DBIS_Deposit_Verify_Result", param.ToArray()); int result = (int)param[9].Value; lblinfo.Text = GetString(result.ToString()); string sql = string.Format("INSERT INTO [dbo].[T_ReplenishmentLog] ([F_GlobalID], [F_UserID], [F_TransactionID],[F_ReturnStr], [F_DepositResult], [F_InsertTime]) VALUES ({0}, {1}, '{2}', '{3}',{4}, GETDATE())", roleID, userID, transactionID, res, result); DBHelperDigGameDB.ExecuteSql(sql); }
/// <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 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) { #region 喊话工单基本信息 lblinfo.Text = ""; 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 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 strMailContent = tbMailContent.Text; if (string.IsNullOrEmpty(strMailContent)) { Response.Write("<Script Language=JavaScript>alert('" + App_GlobalResources.Language.Tip_CreateCodeInfo + "');</Script>"); return; } //备注 string strBak = tbBak.Text.Trim(); #endregion int rowcount = 0; string sendBattleZone = string.Empty; try { string[] arrayNoticeInfo = strMailContent.Split('|'); for (int i = 0; i < arrayBattleZone.Length; i++) { string sql = @"INSERT INTO T_GameNotice (F_ReciveZone, F_ReciveLine, F_ReciveObject, F_MSGLocation, F_Message, F_RunTimeBegin, F_RunTimeEnd, F_RunInterval, F_TaskState,F_TaskID, F_NoticeTimes) VALUES (" + arrayBattleZone[i] + ",-1,N'" + arrayNoticeInfo[1] + "', " + arrayNoticeInfo[2] + ", N'" + arrayNoticeInfo[0] + "', '" + arrayNoticeInfo[3] + "', '" + arrayNoticeInfo[4] + "', " + arrayNoticeInfo[5] + ", 1, " + taskID + ", 0)"; rowcount += DBHelperGameCoreDB.ExecuteSql(sql); sendBattleZone += arrayBattleZone[i] + ";"; } if (rowcount == arrayBattleZone.Length) { string sql = 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}', '100103100', '10010501', '10010404', NULL, '20000213', '100100100', '1000', NULL, NULL, NULL, NULL, NULL, NULL, N'', N'{2}', NULL, {3}, N'{4}', GETDATE(), N'{5}', GETDATE(), N'{6}', '0', NULL, NULL, NULL, N'运行公告操作成功!', NULL, '1', NULL, '1', N'{7}')", strTitle, strBak, strSendUser, taskID, 0, 0, strMailContent, strBattleZone); DBHelperGSSDB.ExecuteSql(sql); Response.Write("<Script Language=JavaScript>alert('" + App_GlobalResources.Language.Tip_Success + "');</Script>"); } else { Response.Write("<Script Language=JavaScript>alert('" + App_GlobalResources.Language.Tip_Failure + ";发送成功的战区:" + sendBattleZone + "');</Script>"); } } catch (System.Exception ex) { lblinfo.Text = "失败;发送成功的战区:" + sendBattleZone + ";ErrorInfo:" + ex.Message; } }
/// <summary> /// 添加新用户 /// </summary> /// <param name="yh"></param> /// <returns></returns> public bool Add(tsuhan_scgl_yh model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into tsuhan_scgl_yh2("); strSql.Append("离职日期,离职原因,是否工资卡,批注,介绍人,指纹登记号码,工号,姓名,学历,专业,部门,机构,职务,新衣柜,衣柜,新鞋柜,鞋柜1,鞋柜2,性别,入职日期,身份证号,身份证地址,现住址,电话,紧急联系人,紧急联系人电话,婚姻状况,民族,籍贯,户籍,是否转正,转正时间,是否购买社保,购买社保时间,是否购买商保,人事资料情况,是否签订合同,合同年限,起始日期,终止日期,合同状态,合同状态备注,备注,在职状态,邮箱,内部小号,密码,AB班,other1,other2,other3,other4,other5,other6,other7,other8,other9,other10)"); strSql.Append(" values ("); strSql.Append("@离职日期,@离职原因,@是否工资卡,@批注,@介绍人,@指纹登记号码,@工号,@姓名,@学历,@专业,@部门,@机构,@职务,@新衣柜,@衣柜,@新鞋柜,@鞋柜1,@鞋柜2,@性别,@入职日期,@身份证号,@身份证地址,@现住址,@电话,@紧急联系人,@紧急联系人电话,@婚姻状况,@民族,@籍贯,@户籍,@是否转正,@转正时间,@是否购买社保,@购买社保时间,@是否购买商保,@人事资料情况,@是否签订合同,@合同年限,@起始日期,@终止日期,@合同状态,@合同状态备注,@备注,@在职状态,@邮箱,@内部小号,@密码,@AB班,@other1,@other2,@other3,@other4,@other5,@other6,@other7,@other8,@other9,@other10)"); SqlParameter[] parameters = { new SqlParameter("@离职日期", SqlDbType.SmallDateTime), new SqlParameter("@离职原因", SqlDbType.NVarChar, 255), new SqlParameter("@是否工资卡", SqlDbType.NVarChar, 255), new SqlParameter("@批注", SqlDbType.NVarChar, 255), new SqlParameter("@介绍人", SqlDbType.NVarChar, 255), new SqlParameter("@指纹登记号码", SqlDbType.NVarChar, 255), new SqlParameter("@工号", SqlDbType.NVarChar, 20), new SqlParameter("@姓名", SqlDbType.NVarChar, 255), new SqlParameter("@学历", SqlDbType.NVarChar, 255), new SqlParameter("@专业", SqlDbType.NVarChar, 255), new SqlParameter("@部门", SqlDbType.NVarChar, 255), new SqlParameter("@机构", SqlDbType.NVarChar, 255), new SqlParameter("@职务", SqlDbType.NVarChar, 255), new SqlParameter("@新衣柜", SqlDbType.NVarChar, 255), new SqlParameter("@衣柜", SqlDbType.NVarChar, 255), new SqlParameter("@新鞋柜", SqlDbType.NVarChar, 255), new SqlParameter("@鞋柜1", SqlDbType.NVarChar, 255), new SqlParameter("@鞋柜2", SqlDbType.NVarChar, 255), new SqlParameter("@性别", SqlDbType.NVarChar, 255), new SqlParameter("@入职日期", SqlDbType.SmallDateTime), new SqlParameter("@身份证号", SqlDbType.NVarChar, 255), new SqlParameter("@身份证地址", SqlDbType.NVarChar, 255), new SqlParameter("@现住址", SqlDbType.NVarChar, 255), new SqlParameter("@电话", SqlDbType.Float, 8), new SqlParameter("@紧急联系人", SqlDbType.NVarChar, 255), new SqlParameter("@紧急联系人电话", SqlDbType.Float, 8), new SqlParameter("@婚姻状况", SqlDbType.NVarChar, 255), new SqlParameter("@民族", SqlDbType.NVarChar, 255), new SqlParameter("@籍贯", SqlDbType.NVarChar, 255), new SqlParameter("@户籍", SqlDbType.NVarChar, 255), new SqlParameter("@是否转正", SqlDbType.NVarChar, 255), new SqlParameter("@转正时间", SqlDbType.SmallDateTime), new SqlParameter("@是否购买社保", SqlDbType.NVarChar, 255), new SqlParameter("@购买社保时间", SqlDbType.NVarChar, 255), new SqlParameter("@是否购买商保", SqlDbType.NVarChar, 255), new SqlParameter("@人事资料情况", SqlDbType.NVarChar, 255), new SqlParameter("@是否签订合同", SqlDbType.NVarChar, 255), new SqlParameter("@合同年限", SqlDbType.NVarChar, 255), new SqlParameter("@起始日期", SqlDbType.SmallDateTime), new SqlParameter("@终止日期", SqlDbType.NVarChar, 255), new SqlParameter("@合同状态", SqlDbType.NVarChar, 255), new SqlParameter("@合同状态备注", SqlDbType.NVarChar, 255), new SqlParameter("@备注", SqlDbType.NVarChar, 255), new SqlParameter("@在职状态", SqlDbType.NVarChar, 50), new SqlParameter("@邮箱", SqlDbType.NVarChar, 50), new SqlParameter("@内部小号", SqlDbType.NVarChar, 20), new SqlParameter("@密码", SqlDbType.NVarChar, 20), new SqlParameter("@AB班", SqlDbType.NVarChar, 10), new SqlParameter("@other1", SqlDbType.NVarChar, 50), new SqlParameter("@other2", SqlDbType.NVarChar, 50), new SqlParameter("@other3", SqlDbType.NVarChar, 50), new SqlParameter("@other4", SqlDbType.NVarChar, 50), new SqlParameter("@other5", SqlDbType.NVarChar, 50), new SqlParameter("@other6", SqlDbType.NVarChar, 50), new SqlParameter("@other7", SqlDbType.NVarChar, 50), new SqlParameter("@other8", SqlDbType.NVarChar, 50), new SqlParameter("@other9", SqlDbType.NVarChar, 50), new SqlParameter("@other10", SqlDbType.NVarChar, 50) }; parameters[0].Value = model.离职日期; parameters[1].Value = model.离职原因; parameters[2].Value = model.是否工资卡; parameters[3].Value = model.批注; parameters[4].Value = model.介绍人; parameters[5].Value = model.指纹登记号码; parameters[6].Value = model.工号; parameters[7].Value = model.姓名; parameters[8].Value = model.学历; parameters[9].Value = model.专业; parameters[10].Value = model.部门; parameters[11].Value = model.机构; parameters[12].Value = model.职务; parameters[13].Value = model.新衣柜; parameters[14].Value = model.衣柜; parameters[15].Value = model.新鞋柜; parameters[16].Value = model.鞋柜1; parameters[17].Value = model.鞋柜2; parameters[18].Value = model.性别; parameters[19].Value = model.入职日期; parameters[20].Value = model.身份证号; parameters[21].Value = model.身份证地址; parameters[22].Value = model.现住址; parameters[23].Value = model.电话; parameters[24].Value = model.紧急联系人; parameters[25].Value = model.紧急联系人电话; parameters[26].Value = model.婚姻状况; parameters[27].Value = model.民族; parameters[28].Value = model.籍贯; parameters[29].Value = model.户籍; parameters[30].Value = model.是否转正; parameters[31].Value = model.转正时间; parameters[32].Value = model.是否购买社保; parameters[33].Value = model.购买社保时间; parameters[34].Value = model.是否购买商保; parameters[35].Value = model.人事资料情况; parameters[36].Value = model.是否签订合同; parameters[37].Value = model.合同年限; parameters[38].Value = model.起始日期; parameters[39].Value = model.终止日期; parameters[40].Value = model.合同状态; parameters[41].Value = model.合同状态备注; parameters[42].Value = model.备注; parameters[43].Value = model.在职状态; parameters[44].Value = model.邮箱; parameters[45].Value = model.内部小号; parameters[46].Value = model.密码; parameters[47].Value = model.AB班; parameters[48].Value = model.other1; parameters[49].Value = model.other2; parameters[50].Value = model.other3; parameters[51].Value = model.other4; parameters[52].Value = model.other5; parameters[53].Value = model.other6; parameters[54].Value = model.other7; parameters[55].Value = model.other8; parameters[56].Value = model.other9; parameters[57].Value = model.other10; int rows = dbhelper3.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 确定 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnConfirm_Click(object sender, EventArgs e) { #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 strMailContent = tbMailContent.Text.Trim(); if (string.IsNullOrEmpty(strMailContent)) { Response.Write("<Script Language=JavaScript>alert('" + App_GlobalResources.Language.Tip_WriteMailContent + "');</Script>"); return; } if (strMailContent.Length > 200) { Response.Write("<Script Language=JavaScript>alert('邮件内容不要超过200个字符!');</Script>"); return; } string strBigZone = "0"; string strBattleZone = "-1"; 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 strContent = tbContent.Text.Trim(); if (string.IsNullOrEmpty(strContent)) { Response.Write("<Script Language=JavaScript>alert('" + App_GlobalResources.Language.Tip_WriteUserInfo + "');</Script>"); return; } int type = 20000214;//发奖工单 #endregion #region 发奖用户信息 DataTable dt = new DataTable("table_a"); DataColumn dc = null; dc = dt.Columns.Add("RoleName", System.Type.GetType("System.String")); dc = dt.Columns.Add("BattleZoneNo", System.Type.GetType("System.String")); string giftUser = string.Empty; string[] strUserInfo = strContent.Split(Environment.NewLine.ToCharArray()); foreach (string userInfo in strUserInfo) { if (!string.IsNullOrEmpty(userInfo)) { DataRow newRow; newRow = dt.NewRow(); newRow["RoleName"] = userInfo; newRow["BattleZoneNo"] = strBattleZone; dt.Rows.Add(newRow); giftUser += userInfo + ";"; } } giftUser = giftUser.Substring(0, giftUser.Length - 1); ds = new DataSet(); ds.Tables.Add(dt); if (ds == null) { Response.Write("<Script Language=JavaScript>alert('" + App_GlobalResources.Language.Tip_WriteUserInfo + "');</Script>"); return; } #endregion try { #region 写入[GameCoreDB].dbo.T_GiftAward_List string sql = @"INSERT INTO T_GiftAward_List (F_AwardName, F_Note,F_State,F_CreateTime, F_ExecType,F_JobTime,F_TaskID) VALUES (N'GSS发奖 工单:" + taskID + " (自动)', N'作业10分钟后自动执行发奖',1, '" + DateTime.Now.AddMinutes(10).ToString("yyyy-MM-dd HH:mm:ss") + "' ,1,'" + DateTime.Now.AddMinutes(10).ToString("yyyy-MM-dd HH:mm:ss") + "'," + taskID + ") ;SELECT @@IDENTITY"; object res = DBHelperGameCoreDB.GetSingle(sql); if (res == null) { Response.Write("<Script Language=JavaScript>alert('" + App_GlobalResources.Language.Tip_GiftAwardDefeat + "');</Script>"); return; } #endregion #region 写入[GameCoreDB].dbo.T_GiftAward_Gift sql = @"INSERT INTO T_GiftAward_Gift ([F_AwardID],[F_ItemID1],[F_ItemNum1],[F_ItemID2],[F_ItemNum2],[F_ItemID3],[F_ItemNum3],[F_ItemID4],[F_ItemNum4],[F_ItemID5],[F_ItemNum5],[F_TaskID],F_MailTitle,F_MailSendName,F_MailContent,[F_Gold],[F_BindGold]) VALUES (" + res.ToString() + ", " + strItemID1 + "," + strItemNum1 + "," + strItemID2 + "," + strItemNum2 + "," + strItemID3 + "," + strItemNum3 + "," + strItemID4 + "," + strItemNum4 + "," + strItemID5 + "," + strItemNum5 + ", " + taskID + ",N'" + strTitle + "',N'" + strSendUser + "',N'" + strMailContent + "'," + strGold + "," + strBindGold + ")"; DBHelperGameCoreDB.ExecuteSql(sql); #endregion #region 写入[GameCoreDB].dbo.T_GiftAward_User //加入用户 string strSql = string.Empty; if (rbtRoleID.Checked) { strSql = "SELECT F_UserID,F_RoleID,-1 F_ZoneID FROM dbo.T_RoleCreate WHERE F_RoleID IN"; } else { strSql = "SELECT F_UserID,F_RoleID,-1 F_ZoneID FROM dbo.T_RoleCreate WHERE F_RoleName IN"; } DataTable dtuser = ds.Tables[0]; string startTemp = "("; string endTemp = ")"; for (int i = 0; i < dtuser.Rows.Count; i++) { startTemp += "N'" + dtuser.Rows[i][0] + "',"; } startTemp = startTemp.Substring(0, startTemp.Length - 1); startTemp += endTemp; strSql += startTemp; DataSet dsRole = DBHelperGameCoreDB.Query(strSql); DataTable dtRole = dsRole.Tables[0]; dtRole.Columns.Add("F_AwardID", typeof(int), res.ToString()); dtRole.Columns.Add("F_TaskID", typeof(int), taskID.ToString()); dtRole.Columns[0].ColumnName = "F_UserID"; dtRole.Columns[1].ColumnName = "F_RoleID"; dtRole.Columns[2].ColumnName = "F_ZoneID"; dtRole.Columns[3].DefaultValue = Convert.ToInt32(res); dtRole.Columns[4].DefaultValue = Convert.ToInt32(taskID); //写入[GameCoreDB].dbo.T_GiftAward_User CopyAwardUserData(dtRole); #endregion #region 创建发奖作业 sql = @"DECLARE @Result INT EXEC [dbo].[_WSS_GiftAward_List_Job] @F_AwardID = " + res.ToString() + ",@Result = @Result OUTPUT SELECT @Result"; object result = DBHelperGameCoreDB.GetSingle(sql); if (result == null || result.ToString() != "0") { Response.Write("<Script Language=JavaScript>alert('" + App_GlobalResources.Language.Tip_CreateExecute + result + "" + "');</Script>"); return; } #endregion #region 写入[GSSDB].dbo.T_Tasks //F_ID-taskID //F_Title-标题 //F_GPeopleName-发起人 //F_Note-邮件内容 //F_URInfo-红蓝钻及道具信息 //F_TUseData-发奖用户信息 //F_PreDutyMan-关联taskID 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); sql = 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}', N'{4}', NULL, NULL, NULL, NULL, N'', N'{5}', NULL, " + taskID + ", '0', GETDATE(), '0', GETDATE(), N'{6}', '0', '0', '0', '0', N'', N'', NULL, N'', '1', N'{7}');", strTitle, strMailContent, type, strBigZone, strBattleZone, strSendUser, giftStr, giftUser); DBHelperGSSDB.ExecuteSql(sql); #endregion Response.Write("<Script Language=JavaScript>alert('" + App_GlobalResources.Language.Tip_Success + "');</Script>"); } catch (Exception ex) { throw ex; } }