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