public int SendMailAndItem(string title, string content, int userID, int gold, int money, string param)
{
int num = 1;
try
{
SqlParameter[] SqlParameters = new SqlParameter[8]
{
new SqlParameter("@Title", (object) title),
new SqlParameter("@Content", (object) content),
new SqlParameter("@UserID", (object) userID),
new SqlParameter("@Gold", (object) gold),
new SqlParameter("@Money", (object) money),
new SqlParameter("@GiftToken", SqlDbType.BigInt),
new SqlParameter("@Param", (object) param),
new SqlParameter("@Result", SqlDbType.Int)
};
SqlParameters[7].Direction = ParameterDirection.ReturnValue;
this.db.RunProcedure("SP_Admin_SendAllItem", SqlParameters);
num = (int)SqlParameters[7].Value;
if (num == 0)
{
using (CenterServiceClient centerServiceClient = new CenterServiceClient())
centerServiceClient.MailNotice(userID);
}
}
catch (Exception ex)
{
if (BaseBussiness.log.IsErrorEnabled)
BaseBussiness.log.Error((object)"Init", ex);
}
return num;
}
public bool SendMailAndItem(MailInfo mail, SqlDataProvider.Data.ItemInfo item, ref int returnValue)
{
bool flag = false;
try
{
SqlParameter[] SqlParameters = new SqlParameter[34]
{
new SqlParameter("@ItemID", (object) item.ItemID),
new SqlParameter("@UserID", (object) item.UserID),
new SqlParameter("@TemplateID", (object) item.TemplateID),
new SqlParameter("@Place", (object) item.Place),
new SqlParameter("@AgilityCompose", (object) item.AgilityCompose),
new SqlParameter("@AttackCompose", (object) item.AttackCompose),
new SqlParameter("@BeginDate", (object) item.BeginDate),
new SqlParameter("@Color", item.Color == null ? (object) "" : (object) item.Color),
new SqlParameter("@Count", (object) item.Count),
new SqlParameter("@DefendCompose", (object) item.DefendCompose),
new SqlParameter("@IsBinds", (object) (int) (item.IsBinds ? 1 : 0)),
new SqlParameter("@IsExist", (object) (int) (item.IsExist ? 1 : 0)),
new SqlParameter("@IsJudge", (object) (int) (item.IsJudge ? 1 : 0)),
new SqlParameter("@LuckCompose", (object) item.LuckCompose),
new SqlParameter("@StrengthenLevel", (object) item.StrengthenLevel),
new SqlParameter("@ValidDate", (object) item.ValidDate),
new SqlParameter("@BagType", (object) item.BagType),
new SqlParameter("@ID", (object) mail.ID),
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null
};
SqlParameters[17].Direction = ParameterDirection.Output;
SqlParameters[18] = new SqlParameter("@Annex1", mail.Annex1 == null ? (object)"" : (object)mail.Annex1);
SqlParameters[19] = new SqlParameter("@Annex2", mail.Annex2 == null ? (object)"" : (object)mail.Annex2);
SqlParameters[20] = new SqlParameter("@Content", mail.Content == null ? (object)"" : (object)mail.Content);
SqlParameters[21] = new SqlParameter("@Gold", (object)mail.Gold);
SqlParameters[22] = new SqlParameter("@Money", (object)mail.Money);
SqlParameters[23] = new SqlParameter("@Receiver", mail.Receiver == null ? (object)"" : (object)mail.Receiver);
SqlParameters[24] = new SqlParameter("@ReceiverID", (object)mail.ReceiverID);
SqlParameters[25] = new SqlParameter("@Sender", mail.Sender == null ? (object)"" : (object)mail.Sender);
SqlParameters[26] = new SqlParameter("@SenderID", (object)mail.SenderID);
SqlParameters[27] = new SqlParameter("@Title", mail.Title == null ? (object)"" : (object)mail.Title);
SqlParameters[28] = new SqlParameter("@IfDelS", (object)false);
SqlParameters[29] = new SqlParameter("@IsDelete", (object)false);
SqlParameters[30] = new SqlParameter("@IsDelR", (object)false);
SqlParameters[31] = new SqlParameter("@IsRead", (object)false);
SqlParameters[32] = new SqlParameter("@SendTime", (object)DateTime.Now);
SqlParameters[33] = new SqlParameter("@Result", SqlDbType.Int);
SqlParameters[33].Direction = ParameterDirection.ReturnValue;
flag = this.db.RunProcedure("SP_Admin_SendUserItem", SqlParameters);
returnValue = (int)SqlParameters[33].Value;
flag = returnValue == 0;
if (flag)
{
using (CenterServiceClient centerServiceClient = new CenterServiceClient())
centerServiceClient.MailNotice(mail.ReceiverID);
}
}
catch (Exception ex)
{
if (BaseBussiness.log.IsErrorEnabled)
BaseBussiness.log.Error((object)"Init", ex);
}
return flag;
}
public bool SendMail(MailInfo mail)
{
bool flag = false;
try
{
SqlParameter[] SqlParameters = new SqlParameter[29];
SqlParameters[0] = new SqlParameter("@ID", (object)mail.ID);
SqlParameters[0].Direction = ParameterDirection.Output;
SqlParameters[1] = new SqlParameter("@Annex1", mail.Annex1 == null ? (object)"" : (object)mail.Annex1);
SqlParameters[2] = new SqlParameter("@Annex2", mail.Annex2 == null ? (object)"" : (object)mail.Annex2);
SqlParameters[3] = new SqlParameter("@Content", mail.Content == null ? (object)"" : (object)mail.Content);
SqlParameters[4] = new SqlParameter("@Gold", (object)mail.Gold);
SqlParameters[5] = new SqlParameter("@IsExist", (object)true);
SqlParameters[6] = new SqlParameter("@Money", (object)mail.Money);
SqlParameters[7] = new SqlParameter("@Receiver", mail.Receiver == null ? (object)"" : (object)mail.Receiver);
SqlParameters[8] = new SqlParameter("@ReceiverID", (object)mail.ReceiverID);
SqlParameters[9] = new SqlParameter("@Sender", mail.Sender == null ? (object)"" : (object)mail.Sender);
SqlParameters[10] = new SqlParameter("@SenderID", (object)mail.SenderID);
SqlParameters[11] = new SqlParameter("@Title", mail.Title == null ? (object)"" : (object)mail.Title);
SqlParameters[12] = new SqlParameter("@IfDelS", (object)false);
SqlParameters[13] = new SqlParameter("@IsDelete", (object)false);
SqlParameters[14] = new SqlParameter("@IsDelR", (object)false);
SqlParameters[15] = new SqlParameter("@IsRead", (object)false);
SqlParameters[16] = new SqlParameter("@SendTime", (object)DateTime.Now);
SqlParameters[17] = new SqlParameter("@Type", (object)mail.Type);
SqlParameters[18] = new SqlParameter("@Annex1Name", mail.Annex1Name == null ? (object)"" : (object)mail.Annex1Name);
SqlParameters[19] = new SqlParameter("@Annex2Name", mail.Annex2Name == null ? (object)"" : (object)mail.Annex2Name);
SqlParameters[20] = new SqlParameter("@Annex3", mail.Annex3 == null ? (object)"" : (object)mail.Annex3);
SqlParameters[21] = new SqlParameter("@Annex4", mail.Annex4 == null ? (object)"" : (object)mail.Annex4);
SqlParameters[22] = new SqlParameter("@Annex5", mail.Annex5 == null ? (object)"" : (object)mail.Annex5);
SqlParameters[23] = new SqlParameter("@Annex3Name", mail.Annex3Name == null ? (object)"" : (object)mail.Annex3Name);
SqlParameters[24] = new SqlParameter("@Annex4Name", mail.Annex4Name == null ? (object)"" : (object)mail.Annex4Name);
SqlParameters[25] = new SqlParameter("@Annex5Name", mail.Annex5Name == null ? (object)"" : (object)mail.Annex5Name);
SqlParameters[26] = new SqlParameter("@ValidDate", (object)mail.ValidDate);
SqlParameters[27] = new SqlParameter("@AnnexRemark", mail.AnnexRemark == null ? (object)"" : (object)mail.AnnexRemark);
SqlParameters[28] = new SqlParameter("GiftToken", (object)mail.GiftToken);
flag = this.db.RunProcedure("SP_Mail_Send", SqlParameters);
mail.ID = (int)SqlParameters[0].Value;
using (CenterServiceClient centerServiceClient = new CenterServiceClient())
centerServiceClient.MailNotice(mail.ReceiverID);
}
catch (Exception ex)
{
if (BaseBussiness.log.IsErrorEnabled)
BaseBussiness.log.Error((object)"Init", ex);
}
return flag;
}
public int SendMailAndItem(string title, string content, int userID, int gold, int money, string param)
{
bool result = false;
int returnValue = 1;
try
{
//SP_Admin_SendAllItem 'kenken','kenken',17,100,200,'11020,4,0,0,0,0,0,0,1|7014,2,9,400,400,400,400,400,0'
SqlParameter[] para = new SqlParameter[8];
//物品
para[0] = new SqlParameter("@Title", title);
para[1] = new SqlParameter("@Content", content);
para[2] = new SqlParameter("@UserID", userID);
para[3] = new SqlParameter("@Gold", gold);
para[4] = new SqlParameter("@Money", money);
para[5] = new SqlParameter("@GiftToken", 0);
para[6] = new SqlParameter("@Param", param);
para[7] = new SqlParameter("@Result", System.Data.SqlDbType.Int);
para[7].Direction = ParameterDirection.ReturnValue;
result = db.RunProcedure("SP_Admin_SendAllItem", para);
returnValue = (int)para[7].Value;
result = returnValue == 0;
if (result)
{
using (CenterServiceClient client = new CenterServiceClient())
{
client.MailNotice(userID);
}
}
}
catch (Exception e)
{
if (log.IsErrorEnabled)
log.Error("Init", e);
}
finally
{
}
return returnValue;
}
public bool SendMailAndItem(MailInfo mail, ItemInfo item, ref int returnValue)
{
bool result = false;
try
{
SqlParameter[] para = new SqlParameter[34];
//物品
para[0] = new SqlParameter("@ItemID", item.ItemID);
para[1] = new SqlParameter("@UserID", item.UserID);
para[2] = new SqlParameter("@TemplateID", item.TemplateID);
para[3] = new SqlParameter("@Place", item.Place);
para[4] = new SqlParameter("@AgilityCompose", item.AgilityCompose);
para[5] = new SqlParameter("@AttackCompose", item.AttackCompose);
para[6] = new SqlParameter("@BeginDate", item.BeginDate);
para[7] = new SqlParameter("@Color", item.Color == null ? "" : item.Color);
para[8] = new SqlParameter("@Count", item.Count);
para[9] = new SqlParameter("@DefendCompose", item.DefendCompose);
para[10] = new SqlParameter("@IsBinds", item.IsBinds);
para[11] = new SqlParameter("@IsExist", item.IsExist);
para[12] = new SqlParameter("@IsJudge", item.IsJudge);
para[13] = new SqlParameter("@LuckCompose", item.LuckCompose);
para[14] = new SqlParameter("@StrengthenLevel", item.StrengthenLevel);
para[15] = new SqlParameter("@ValidDate", item.ValidDate);
para[16] = new SqlParameter("@BagType", item.BagType);
//信箱
para[17] = new SqlParameter("@ID", mail.ID);
para[17].Direction = ParameterDirection.Output;
para[18] = new SqlParameter("@Annex1", mail.Annex1 == null ? "" : mail.Annex1);
para[19] = new SqlParameter("@Annex2", mail.Annex2 == null ? "" : mail.Annex2);
para[20] = new SqlParameter("@Content", mail.Content == null ? "" : mail.Content);
para[21] = new SqlParameter("@Gold", mail.Gold);
para[22] = new SqlParameter("@Money", mail.Money);
para[23] = new SqlParameter("@Receiver", mail.Receiver == null ? "" : mail.Receiver);
para[24] = new SqlParameter("@ReceiverID", mail.ReceiverID);
para[25] = new SqlParameter("@Sender", mail.Sender == null ? "" : mail.Sender);
para[26] = new SqlParameter("@SenderID", mail.SenderID);
para[27] = new SqlParameter("@Title", mail.Title == null ? "" : mail.Title);
para[28] = new SqlParameter("@IfDelS", false);
para[29] = new SqlParameter("@IsDelete", false);
para[30] = new SqlParameter("@IsDelR", false);
para[31] = new SqlParameter("@IsRead", false);
para[32] = new SqlParameter("@SendTime", DateTime.Now);
para[33] = new SqlParameter("@Result", System.Data.SqlDbType.Int);
para[33].Direction = ParameterDirection.ReturnValue;
result = db.RunProcedure("SP_Admin_SendUserItem", para);
returnValue = (int)para[33].Value;
result = returnValue == 0;
if (result)
{
using (CenterServiceClient client = new CenterServiceClient())
{
client.MailNotice(mail.ReceiverID);
}
}
}
catch (Exception e)
{
if (log.IsErrorEnabled)
log.Error("Init", e);
}
finally
{
}
return result;
}
public bool SendMail(MailInfo mail)
{
bool result = false;
try
{
SqlParameter[] para = new SqlParameter[29];
para[0] = new SqlParameter("@ID", mail.ID);
para[0].Direction = ParameterDirection.Output;
para[1] = new SqlParameter("@Annex1", mail.Annex1 == null ? "" : mail.Annex1);
para[2] = new SqlParameter("@Annex2", mail.Annex2 == null ? "" : mail.Annex2);
para[3] = new SqlParameter("@Content", mail.Content == null ? "" : mail.Content);
para[4] = new SqlParameter("@Gold", mail.Gold);
para[5] = new SqlParameter("@IsExist", true);
para[6] = new SqlParameter("@Money", mail.Money);
para[7] = new SqlParameter("@Receiver", mail.Receiver == null ? "" : mail.Receiver);
para[8] = new SqlParameter("@ReceiverID", mail.ReceiverID);
para[9] = new SqlParameter("@Sender", mail.Sender == null ? "" : mail.Sender);
para[10] = new SqlParameter("@SenderID", mail.SenderID);
para[11] = new SqlParameter("@Title", mail.Title == null ? "" : mail.Title);
para[12] = new SqlParameter("@IfDelS", false);
para[13] = new SqlParameter("@IsDelete", false);
para[14] = new SqlParameter("@IsDelR", false);
para[15] = new SqlParameter("@IsRead", false);
para[16] = new SqlParameter("@SendTime", DateTime.Now);
para[17] = new SqlParameter("@Type", mail.Type);
para[18] = new SqlParameter("@Annex1Name", mail.Annex1Name == null ? "" : mail.Annex1Name);
para[19] = new SqlParameter("@Annex2Name", mail.Annex2Name == null ? "" : mail.Annex2Name);
para[20] = new SqlParameter("@Annex3", mail.Annex3 == null ? "" : mail.Annex3);
para[21] = new SqlParameter("@Annex4", mail.Annex4 == null ? "" : mail.Annex4);
para[22] = new SqlParameter("@Annex5", mail.Annex5 == null ? "" : mail.Annex5);
para[23] = new SqlParameter("@Annex3Name", mail.Annex3Name == null ? "" : mail.Annex3Name);
para[24] = new SqlParameter("@Annex4Name", mail.Annex4Name == null ? "" : mail.Annex4Name);
para[25] = new SqlParameter("@Annex5Name", mail.Annex5Name == null ? "" : mail.Annex5Name);
para[26] = new SqlParameter("@ValidDate", mail.ValidDate);
para[27] = new SqlParameter("@AnnexRemark", mail.AnnexRemark == null ? "" : mail.AnnexRemark);
para[28] = new SqlParameter("GiftToken", mail.GiftToken);
// @ID = @ID OUTPUT,
result = db.RunProcedure("SP_Mail_Send", para);
mail.ID = (int)para[0].Value;
using (CenterServiceClient client = new CenterServiceClient())
{
client.MailNotice(mail.ReceiverID);
}
}
catch (Exception e)
{
if (log.IsErrorEnabled)
log.Error("Init", e);
}
finally
{
}
return result;
}
