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