public static System.Collections.Hashtable Insert(Model.SMS model, System.Collections.Hashtable MyHs)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into SMS(");
strSql.Append("SType,SContent,Tel,SMSKey,CreateDate,MID,SendState,Email)");
strSql.Append(" values (");
strSql.Append("@SType,@SContent,@Tel,@SMSKey,@CreateDate,@MID,@SendState,@Email)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@SType", SqlDbType.VarChar, 10),
new SqlParameter("@SContent", SqlDbType.Text),
new SqlParameter("@Tel", SqlDbType.VarChar, 20),
new SqlParameter("@SMSKey", SqlDbType.VarChar, 50),
new SqlParameter("@CreateDate", SqlDbType.DateTime),
new SqlParameter("@MID", SqlDbType.VarChar, 50),
new SqlParameter("@SendState", SqlDbType.Bit, 1),
new SqlParameter("@Email", SqlDbType.VarChar, 50)
};
parameters[0].Value = model.SType;
parameters[1].Value = model.SContent;
parameters[2].Value = model.Tel;
parameters[3].Value = model.SMSKey;
parameters[4].Value = model.CreateDate;
parameters[5].Value = model.MID;
parameters[6].Value = model.SendState;
parameters[7].Value = model.Email;
MyHs.Add(strSql.ToString(), parameters);
return(MyHs);
}
/// <summary>
/// 得到个人信息
/// </summary>
/// <returns></returns>
public Model.Member GetSelf()
{
if (TModel == null)
{
return(null);
}
Model.Member model = DAL.Member.GetModel(TModel.MID);
if (model != null && !model.Role.Super)
{
if (string.IsNullOrEmpty(model.TempThrPsd) || model.ThrPsd != model.TempThrPsd)
{
if (!model.IsClose)
{
model.IsClose = true;
MemberClose(model);
string Msg = "会员：" + model.MID + "于当前时间[" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "]账号异常，已锁定，未冻结";
Model.SMS smsmodel = new Model.SMS {
SType = Model.SMSType.ZCYZ, Tel = BLL.WebBase.Model.MonitorTel, SContent = Msg
};
string error = "";
if (BLL.SMS.Insert(smsmodel, ref error))
{
Msg += "[已发送您手机]";
}
Task.SendManage(model, "001", Msg);
}
return(null);
}
}
return(model);
}
public static bool Insert(Model.SMS model, ref string error)
{
if (BLL.WebBase.Model.EmailState && !string.IsNullOrEmpty(model.Email))
{
int level = 0;
while (!model.SendState && level++ < 5)
{
try
{
model.SendState = SendMessage(model, ref error);
}
catch (Exception ex)
{
//BLL.WebBase.Model.EmailName = Emails[new Random().Next(0, 100)];
//BLL.WebBase.Update(BLL.WebBase.Model);
error += "邮件发送失败！" + ex.Message;
model.SendState = false;
}
}
model.CreateDate = DateTime.Now;
model.SMSKey = BLL.WebBase.Model.EmailName;
DAL.SMS.Insert(model);
}
else
{
error += "邮箱功能已关闭！";
return(false);
}
return(model.SendState);
}
/// <summary>
/// Parses received messages into IEnumberable object
/// </summary>
/// <param name="input"></param>
/// <returns>IEnumerable of Model.SMS</returns>
static IEnumerable <Model.SMS> ParseMessages(string input)
{
List <Model.SMS> msgs = new List <Model.SMS>();
Regex r = new Regex(@"\+CMGL: (\d+),""(.+)"",""(.+)"",(.*),""(.+)""\r\n(.+)\r\n");
Match m = r.Match(input);
while (m.Success)
{
Model.SMS msg = new Model.SMS();
msg.ID = Guid.NewGuid();
msg.Status = dictstatus[m.Groups[2].Value];
msg.Mobile = m.Groups[3].Value;
DateTime today;
if (!DateTime.TryParseExact(m.Groups[5].Value, "yy/MM/dd,H:mm:ss+32", CultureInfo.InvariantCulture, DateTimeStyles.None, out today))
{
today = DateTime.Now;
}
msg.SMSDate = today;
msg.Message = m.Groups[6].Value;
msgs.Add(msg);
m = m.NextMatch();
}
return(msgs);
}
public static bool Insert(Model.SMS model, ref string error)
{
try
{
model.SendState = false;
model.CreateDate = DateTime.Now;
//model.SContent += "[" + BLL.WebBase.Model.SMSTitle + "]";
if (BLL.WebBase.Model.SMSState && !string.IsNullOrEmpty(model.Tel))
{
if (TimeVerify(model.Tel, model.SType, BLL.Configuration.CodeTime[model.SType.ToString()]))
{
//if (DAL.SMS.GetDayCount(DateTime.Now) <= DAL.WebBase.Model.SMSMinCount)
//{
string dian = @"^(13+\d{9})|(15+\d{9})|(18+\d{9})|(17+\d{9})|(14+\d{9})|(19+\d{9})$";
Regex regex = new Regex(dian);
if (regex.IsMatch(model.Tel))
{
model.SendState = SendSMS(model.Tel, model.SContent);
if (model.SendState)
{
DAL.SMS.Insert(model);
}
else
{
error = "短信发送失败,请稍后重试";
}
}
else
{
model.SendState = false;
error += "手机号格式不正确";
}
//}
//else
//{
// error += "今日短信已用完";
//}
}
else
{
error += "请等待" + (BLL.Configuration.CodeTime[model.SType.ToString()]) + "秒后，才可以重新接收手机短信";
}
}
else
{
error += "短信功能已关闭!";
}
return(model.SendState);
}
catch (Exception ex)
{
error += ex.ToString();
return(false);
}
}
public static bool Update(Model.SMS model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update SMS set ");
strSql.Append("SType=@SType,");
strSql.Append("SContent=@SContent,");
strSql.Append("Tel=@Tel,");
strSql.Append("Email=@Email,");
strSql.Append("SMSKey=@SMSKey,");
strSql.Append("CreateDate=@CreateDate,");
strSql.Append("MID=@MID,");
strSql.Append("SendState=@SendState");
strSql.Append(" where SID=@SID");
SqlParameter[] parameters =
{
new SqlParameter("@SType", SqlDbType.VarChar, 10),
new SqlParameter("@SContent", SqlDbType.Text),
new SqlParameter("@Tel", SqlDbType.VarChar, 20),
new SqlParameter("@Email", SqlDbType.VarChar, 50),
new SqlParameter("@SMSKey", SqlDbType.VarChar, 50),
new SqlParameter("@CreateDate", SqlDbType.DateTime),
new SqlParameter("@MID", SqlDbType.VarChar, 50),
new SqlParameter("@SID", SqlDbType.Int, 4),
new SqlParameter("@SendState", SqlDbType.Bit, 1)
};
parameters[0].Value = model.SType;
parameters[1].Value = model.SContent;
parameters[2].Value = model.Tel;
parameters[3].Value = model.Email;
parameters[4].Value = model.SMSKey;
parameters[5].Value = model.CreateDate;
parameters[6].Value = model.MID;
parameters[7].Value = model.SID;
parameters[8].Value = model.SendState;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
protected override string btnAdd_Click()
{
string tel = Request.Form["tel"];
string content = Request.Form["contents"];
Model.SMS model = new Model.SMS {
SType = Model.SMSType.ZCYZ, Tel = tel, SContent = content, SMSKey = ""
};
string error = "";
if (BLL.SMS.Insert(model, ref error))
{
return("发送成功");
}
else
{
return(error);
}
}
private static bool SendMessage(Model.SMS model, ref string error)
{
SmtpClient client = new SmtpClient(BLL.WebBase.Model.EmailSmtp, 25);
//出站方式设置为NetWork
client.DeliveryMethod = SmtpDeliveryMethod.Network;
//smtp服务器验证并制定账号密码
client.Credentials = new NetworkCredential(BLL.WebBase.Model.EmailName, BLL.WebBase.Model.EmailPassword);
MailMessage message = new MailMessage();
//设置优先级
message.Priority = MailPriority.Normal;
//设置收件方看到的邮件来源为:发送方邮件地址、来源标题、编码
message.From = new MailAddress(BLL.WebBase.Model.EmailName, "Vinci", Encoding.GetEncoding("gb2312"));
//接收方
if (!string.IsNullOrEmpty(model.Email))
{
try
{
message.To.Add(model.Email);
}
catch
{
error += "邮箱设置不正确！";
return(false);
}
}
else
{
error += "邮箱未设置！";
return(false);
}
//标题
message.Subject = BLL.WebBase.Model.EmailTitle;
message.SubjectEncoding = Encoding.GetEncoding("gb2312");
//邮件正文是否支持HTML
message.IsBodyHtml = true;
//正文编码
message.BodyEncoding = Encoding.GetEncoding("gb2312");
message.Body = model.SContent;
client.Send(message);
return(true);
}
public static bool Insert(Model.SMS model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into SMS(");
strSql.Append("SType,SContent,Tel,SMSKey,CreateDate,MID,SendState,Email)");
strSql.Append(" values (");
strSql.Append("@SType,@SContent,@Tel,@SMSKey,@CreateDate,@MID,@SendState,@Email)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@SType", SqlDbType.VarChar, 10),
new SqlParameter("@SContent", SqlDbType.Text),
new SqlParameter("@Tel", SqlDbType.VarChar, 20),
new SqlParameter("@SMSKey", SqlDbType.VarChar, 50),
new SqlParameter("@CreateDate", SqlDbType.DateTime),
new SqlParameter("@MID", SqlDbType.VarChar, 50),
new SqlParameter("@SendState", SqlDbType.Bit, 1),
new SqlParameter("@Email", SqlDbType.VarChar, 50)
};
parameters[0].Value = model.SType;
parameters[1].Value = model.SContent;
parameters[2].Value = model.Tel;
parameters[3].Value = model.SMSKey;
parameters[4].Value = model.CreateDate;
parameters[5].Value = model.MID;
parameters[6].Value = model.SendState;
parameters[7].Value = model.Email;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(true);
}
else
{
return(Convert.ToInt32(obj) > 0);
}
}
public static System.Collections.Hashtable Update(Model.SMS model, System.Collections.Hashtable MyHs)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update SMS set ");
strSql.Append("SType=@SType,");
strSql.Append("SContent=@SContent,");
strSql.Append("Tel=@Tel,");
strSql.Append("Email=@Email,");
strSql.Append("SMSKey=@SMSKey,");
strSql.Append("CreateDate=@CreateDate,");
strSql.Append("MID=@MID");
strSql.Append("SendState=@SendState");
strSql.Append(" where SID=@SID");
SqlParameter[] parameters =
{
new SqlParameter("@SType", SqlDbType.VarChar, 10),
new SqlParameter("@SContent", SqlDbType.Text),
new SqlParameter("@Tel", SqlDbType.VarChar, 20),
new SqlParameter("@Email", SqlDbType.VarChar, 50),
new SqlParameter("@SMSKey", SqlDbType.VarChar, 50),
new SqlParameter("@CreateDate", SqlDbType.DateTime),
new SqlParameter("@MID", SqlDbType.VarChar, 50),
new SqlParameter("@SID", SqlDbType.Int, 4),
new SqlParameter("@SendState", SqlDbType.Bit, 1)
};
parameters[0].Value = model.SType;
parameters[1].Value = model.SContent;
parameters[2].Value = model.Tel;
parameters[3].Value = model.Email;
parameters[4].Value = model.SMSKey;
parameters[5].Value = model.CreateDate;
parameters[6].Value = model.MID;
parameters[7].Value = model.SID;
parameters[8].Value = model.SendState;
MyHs.Add(strSql.ToString(), parameters);
return(MyHs);
}
public static bool Insert(Model.SMS model, ref string error)
{
model.SendState = false;
model.CreateDate = DateTime.Now;
//model.SContent += "[" + BLL.WebBase.Model.SMSTitle + "]";
if (BLL.WebBase.Model.SMSState && !string.IsNullOrEmpty(model.Tel))
{
//if (TimeVerify(model.Tel, model.SType, BLL.Configuration.CodeTime[model.SType.ToString()]))
{
if (DAL.SMS.GetDayCount(DateTime.Now) <= DAL.WebBase.Model.SMSMinCount)
{
model.SendState = SendSMS(model.Tel, model.SContent);
DAL.SMS.Insert(model);
if (model.SendState)
{
error = "发送成功";
}
else
{
error += "发送失败";
}
}
else
{
error += "今日短信已用完";
}
}
//else
//{
// error += "请等待" + (BLL.Configuration.CodeTime[model.SType.ToString()] / 60) + "分钟后，才可以重新接收手机短信";
//}
}
else
{
error += "短信功能已关闭!";
}
return(model.SendState);
}
/// <summary>
/// 推荐人
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool Insert(Model.Member model, bool NeedEmail, ref string retStr)
{
if (model.AgencyCode == "001")
{
model.MState = false;
model.RoleCode = BLL.Roles.RolsList["Notactive"].RType;
model.MBDIndex = 0;
model.MCreateDate = DateTime.Now;
model.MDate = DateTime.MaxValue;
model.MConfig = new Model.MemberConfig
{
MID = model.MID,
JJTypeList = DAL.Reward.RewardStr,
DTFHState = true,
JTFHState = true
};
}
retStr = Validation(model);
if (retStr != "")
{
return(false);
}
string password = model.Password;
string secpsd = model.SecPsd;
if (string.IsNullOrEmpty(model.FMID))
{
model.Password = System.Web.Security.FormsAuthentication.HashPasswordForStoringInConfigFile(model.Password + model.Salt, "MD5").ToUpper();
model.SecPsd = System.Web.Security.FormsAuthentication.HashPasswordForStoringInConfigFile(model.SecPsd + model.Salt, "MD5").ToUpper();
}
if (DAL.Member.Insert(model))
{
Model.Member mtjmodel = DAL.Member.GetModel(model.MTJ);
retStr = "恭喜您注册成功，您的会员账号为：" + model.MID +
"，登录密码是：" + password + "，资金密码是：" + secpsd + "！";
Model.SMS smsmodel = new Model.SMS {
MID = model.MID, SContent = retStr, Email = model.Email, SType = Model.SMSType.QT
};
BLL.Task.ManageSend(model, "尊敬的" + model.MID +
"会员：恭喜成功注册，为了您的账户安全，请妥善保管您的密码，并且定期在[安全中心]修改密码，为了使您能够享受更多的服务，请及时购币激活账号，您的推荐人QQ号码：" + mtjmodel.QQ + "，手机号码：" + mtjmodel.Tel);
string emailerr = "";
if (NeedEmail)
{
BLL.Email.Insert(smsmodel, ref emailerr);
}
emailerr = "恭喜您，会员账号" + model.MID + "成功注册为您伞下体验会员，请尽快协助新会员购币激活账号，谢谢合作！";
BLL.Task.ManageSend(mtjmodel, emailerr);
smsmodel = new Model.SMS {
MID = mtjmodel.MID, SContent = emailerr, Email = mtjmodel.Email, SType = Model.SMSType.QT
};
if (NeedEmail)
{
BLL.Email.Insert(smsmodel, ref emailerr);
}
return(true);
}
return(false);
}
public static bool Update(Model.SMS model)
{
return(DAL.SMS.Update(model));
}
public static System.Collections.Hashtable Update(Model.SMS model, System.Collections.Hashtable MyHs)
{
return(DAL.SMS.Update(model, MyHs));
}
public static System.Collections.Hashtable Insert(Model.SMS model, System.Collections.Hashtable MyHs)
{
model.SendState = SendSMS(model.Tel, model.SContent);
model.CreateDate = DateTime.Now;
return(DAL.SMS.Insert(model, MyHs));
}
