/// <summary>
/// 增加一条数据
/// </summary>
public void Insert(Entities.SMSSendHistory model)
{
SqlParameter[] parameters =
{
new SqlParameter("@RecID", SqlDbType.Int, 4),
new SqlParameter("@BGID", SqlDbType.Int, 4),
new SqlParameter("@TemplateID", SqlDbType.Int, 4),
new SqlParameter("@Phone", SqlDbType.VarChar, 23),
new SqlParameter("@Content", SqlDbType.VarChar, 500),
new SqlParameter("@Status", SqlDbType.Int, 4),
new SqlParameter("@CreateTime", SqlDbType.DateTime),
new SqlParameter("@CreateUserID", SqlDbType.Int, 4),
new SqlParameter("@CustID", SqlDbType.VarChar, 20),
new SqlParameter("@CRMCustID", SqlDbType.VarChar, 20),
new SqlParameter("@TaskType", SqlDbType.Int, 4),
new SqlParameter("@TaskID", SqlDbType.VarChar, 20)
};
parameters[0].Direction = ParameterDirection.Output;
parameters[1].Value = model.BGID;
parameters[2].Value = model.TemplateID;
parameters[3].Value = model.Phone;
parameters[4].Value = model.Content;
parameters[5].Value = model.Status;
parameters[6].Value = model.CreateTime;
parameters[7].Value = model.CreateUserID;
parameters[8].Value = model.CustID;
parameters[9].Value = model.CRMCustID;
parameters[10].Value = model.TaskType;
parameters[11].Value = model.TaskID;
SqlHelper.ExecuteNonQuery(CONNECTIONSTRINGS, CommandType.StoredProcedure, P_SMSSENDHISTORY_INSERT, parameters);
model.RecID = (int)parameters[0].Value;
}
/// 保存数据表
/// <summary>
/// 保存数据表
/// </summary>
/// <param name="jsondata"></param>
/// <param name="loginuserid"></param>
private void SaveSMSSendHistory(CommonCallJsonData jsondata, int loginuserid, int bgid, int sendstatus, out string data)
{
//插入发送短信记录
Entities.SMSSendHistory smssendhistory = new Entities.SMSSendHistory();
smssendhistory.BGID = bgid;
smssendhistory.TemplateID = jsondata.SMSData.TemplateID_Out;
smssendhistory.Phone = jsondata.SMSData.Phone_Out;
smssendhistory.Content = jsondata.SMSData.Content_Out;
smssendhistory.Status = sendstatus;
smssendhistory.CustID = jsondata.CBID;
smssendhistory.CRMCustID = jsondata.PageData.CRMCustID_Out.ToString();
smssendhistory.TaskType = (int)jsondata.PageData.TaskType_Out;
smssendhistory.TaskID = jsondata.PageData.TaskID_Out;
smssendhistory.CreateTime = DateTime.Now;
smssendhistory.CreateUserID = loginuserid;
BLL.SMSSendHistory.Instance.Insert(smssendhistory);
data = "'" + smssendhistory.RecID + "'";
}
private Entities.SMSSendHistory LoadSingleSMSSendHistory(DataRow row)
{
Entities.SMSSendHistory model = new Entities.SMSSendHistory();
if (row["RecID"].ToString() != "")
{
model.RecID = int.Parse(row["RecID"].ToString());
}
if (row["BGID"].ToString() != "")
{
model.BGID = int.Parse(row["BGID"].ToString());
}
if (row["TemplateID"].ToString() != "")
{
model.TemplateID = int.Parse(row["TemplateID"].ToString());
}
model.Phone = row["Phone"].ToString();
model.Content = row["Content"].ToString();
if (row["Status"].ToString() != "")
{
model.Status = int.Parse(row["Status"].ToString());
}
if (row["CreateTime"].ToString() != "")
{
model.CreateTime = DateTime.Parse(row["CreateTime"].ToString());
}
if (row["CreateUserID"].ToString() != "")
{
model.CreateUserID = int.Parse(row["CreateUserID"].ToString());
}
if (row["CustID"].ToString() != "")
{
model.CustID = row["CustID"].ToString();
}
model.CRMCustID = row["CRMCustID"].ToString();
if (row["TaskType"].ToString() != "")
{
model.TaskType = int.Parse(row["TaskType"].ToString());
}
model.TaskID = row["TaskID"].ToString();
return(model);
}
/// 发送短信
/// <summary>
/// 发送短信
/// </summary>
/// <param name="msg"></param>
public void SendSMSToPeople(out string msg)
{
msg = string.Empty;
try
{
string[] telArry = Tels.Split(',');
if (telArry.Length == 0)
{
msg = "电话号码不能为空";
msg = "{result:'false',msg:'" + msg + "'}";
return;
}
if (telArry.Length > 2)
{
msg = "电话号码不能超过3个";
msg = "{result:'false',msg:'" + msg + "'}";
return;
}
foreach (string str in telArry)
{
if (!string.IsNullOrEmpty(str))
{
string telstr = str.Trim();
if (!BLL.Util.IsHandset(telstr))
{
msg = "电话(" + telstr + ")不符合规则";
msg = "{result:'false',msg:'" + msg + "'}";
return;
}
//计算客户id
string custid = CustID;
if (string.IsNullOrEmpty(custid))
{
custid = BLL.CustBasicInfo.Instance.GetMaxNewCustBasicInfoByTel(telstr);
}
//插入发送日志
Entities.SendSMSLog smsLogModel = new Entities.SendSMSLog();
smsLogModel.CreateUserID = BLL.Util.GetLoginUserID();
smsLogModel.CustID = custid;
smsLogModel.Mobile = telstr;
smsLogModel.SendContent = SendContent;
smsLogModel.SendTime = DateTime.Now;
smsLogModel.TemplateID = CommonFunction.ObjectToInteger(TemplateID, -1);
BLL.SendSMSLog.Instance.Insert(smsLogModel);
//发送短信
int status = -1;
string md5 = SMSServiceHelper.Instance.MixMd5(telstr, SendContent);
int msgid = SMSServiceHelper.Instance.SendMsgImmediately(telstr, SendContent, DateTime.Now.AddHours(1), md5);
if (msgid > 0)
{
//插入发送短信记录
status = 0;
BLL.Util.InsertUserLog("给手机（" + telstr + "）发送短信成功");
msg = "{result:'true',msg:''}";
}
else
{
msg = BLL.Util.GetEnumOptText(typeof(Entities.SendSMSInfo), msgid);
BLL.Util.InsertUserLog("给手机（" + telstr + "）发送短信失败【错误信息：" + msg + "】");
msg = "{result:'false',msg:'" + msg + "'}";
}
//插入发送短信记录
Entities.SMSSendHistory smssendhistory = new Entities.SMSSendHistory();
smssendhistory.CreateUserID = BLL.Util.GetLoginUserID();
smssendhistory.CustID = custid;
smssendhistory.CRMCustID = CRMCustID;
Entities.EmployeeAgent agent = new Entities.EmployeeAgent();
agent = BLL.EmployeeAgent.Instance.GetEmployeeAgentByUserID(Convert.ToInt32(smssendhistory.CreateUserID));
if (agent != null && agent.BGID > 0)
{
smssendhistory.BGID = agent.BGID;
}
smssendhistory.TemplateID = CommonFunction.ObjectToInteger(TemplateID, -1);
smssendhistory.TaskType = CommonFunction.ObjectToInteger(TaskType, -1);
smssendhistory.TaskID = TaskID;
smssendhistory.Phone = telstr;
smssendhistory.Content = SendContent;
smssendhistory.CreateTime = DateTime.Now;
smssendhistory.Status = status;
BLL.SMSSendHistory.Instance.Insert(smssendhistory);
//成功后返回
if (status == 0)
{
msg = "{result:'true',msg:'',SMSSendHistoryRecID:'" + smssendhistory.RecID + "'}";
}
}
}
}
catch (Exception ex)
{
msg = "{result:'false',msg:'" + ex.Message + "'}";
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public void Insert(Entities.SMSSendHistory model)
{
Dal.SMSSendHistory.Instance.Insert(model);
}
