/// <summary>
/// 互亿无线群发
/// </summary>
/// <param name="request"></param>
/// <returns></returns>
internal static Result MassSMSMessage(DataContract.Request request)
{
string url = WebConfigurationManager.AppSettings["MassSMSURL"].ToString();
var para = request.GetParameters <SendSmsReqPara>();
SMSSendBLL bll = new SMSSendBLL(new JIT.Utility.BasicUserInfo());
var entity = new SMSSendEntity()
{
MobileNO = para.MobileNO,
Sign = para.Sign,
SMSContent = para.SMSContent,
Account = "cf_znxx",
Password = "******"
};
//调用短信接口直接发送
var result = GetResult(entity.GetSMS().Send2(SendType.Get, url));//GetSMS确定了是用的HuYiSMS
if (result.IsSuccess)
{
entity.Status = 1;
entity.SendCount = (entity.SendCount ?? 0) + 1;
entity.Mtmsgid = result.SMSID;
entity.RegularlySendTime = DateTime.Now;
// Loggers.Debug(new DebugLogInfo() { Message = "【发送成功】{0}【手机号】:{1}{0}【内容】:{2}{0}【返回码】：{3}".Fmt(Environment.NewLine, entity.MobileNO, entity.SMSContent, result.ToJSON()) });
}
else
{
entity.SendCount = (entity.SendCount ?? 0) + 1;
//Loggers.Debug(new DebugLogInfo() { Message = "【发送失败】{0}【手机号】:{1}{0}【内容】:{2}{0}【错误信息】:{3}".Fmt(Environment.NewLine, entity.MobileNO, entity.SMSContent, result.ToJSON()) });
}
return(result);
}
/// <summary>
/// 根据标识符获取实例
/// </summary>
/// <param name="pID">标识符的值</param>
public SMSSendEntity GetByID(object pID)
{
//参数检查
if (pID == null)
{
return(null);
}
string id = pID.ToString();
//组织SQL
StringBuilder sql = new StringBuilder();
sql.AppendFormat("select * from [SMS_send] where SMS_send_id='{0}'", id.ToString());
//读取数据
SMSSendEntity m = null;
using (SqlDataReader rdr = this.SQLHelper.ExecuteReader(sql.ToString()))
{
while (rdr.Read())
{
this.Load(rdr, out m);
break;
}
}
//返回
return(m);
}
/// <summary>
/// 阿里大鱼
/// </summary>
/// <param name="pSign"></param>
/// <param name="pSMSContent"></param>
/// <param name="pMobileNO"></param>
/// <param name="pSmsTemplateCode"></param>
/// <returns></returns>
private static AlibabaAliqinFcSmsNumSendResponse AlidatySendMessage(string pSign, string pSMSContent, string pMobileNO, string pSmsTemplateCode)
{
string appKey = WebConfigurationManager.AppSettings["AlidayuAppKey"].ToString();
string secret = WebConfigurationManager.AppSettings["AlidayuSecret"].ToString();
string url = WebConfigurationManager.AppSettings["AlidayuURL"].ToString();
//短信发送日志
SMSSendBLL bll = new SMSSendBLL(new JIT.Utility.BasicUserInfo());
ITopClient client = new DefaultTopClient(url, appKey, secret);
AlibabaAliqinFcSmsNumSendRequest req = new AlibabaAliqinFcSmsNumSendRequest();
req.SmsType = "normal";
req.SmsFreeSignName = pSign; //签名
req.SmsParam = pSMSContent;
req.RecNum = pMobileNO; //手机号
req.SmsTemplateCode = pSmsTemplateCode;
AlibabaAliqinFcSmsNumSendResponse rsp = client.Execute(req);
string[] temp = pMobileNO.Split(',');
foreach (var i in temp)
{
var entity = new SMSSendEntity()
{
MobileNO = i,
Sign = pSign,
};
if (rsp.Result != null)
{
entity.Status = 1;
entity.SendCount = (entity.SendCount ?? 0) + 1;
entity.RegularlySendTime = DateTime.Now;
var debug = new DebugLogInfo()
{
Message = "【发送成功】{0}【手机号】:{1}{0}【内容】:{2}{0}【返回码】：{3}".Fmt(Environment.NewLine, entity.MobileNO, rsp.Result.Msg, rsp.Result.ErrCode)
};
Loggers.Debug(debug);
}
else
{
entity.SendCount = (entity.SendCount ?? 0) + 1;
rsp.Result = new BizResult()
{
ErrCode = rsp.ErrCode,
Msg = rsp.SubErrMsg,
Success = false,
};
var debug = new DebugLogInfo()
{
Message = "【发送失败】{0}【手机号】:{1}{0}【内容】:{2}{0}【错误信息】:{3}".Fmt(Environment.NewLine, entity.MobileNO, rsp.SubErrCode, rsp.ErrCode)
};
Loggers.Debug(debug);
}
//保存数据库
bll.Create(entity);
}
return(rsp);
}
public static BaseRequest GetRequest(this SMSSendEntity entity)
{
SmsRequest request = new SmsRequest(SmsCommandType.MT_REQUEST);
request.Sm = entity.SMSContent;
request.Da = entity.MobileNO.ToString();
return(request);
}
public void TestProcess()
{
MessageHandler handler = new MessageHandler();
SMSSendEntity entity = new SMSSendEntity();
entity.SMSSendNO = 66472;
entity.MobileNO = "18019438327";
entity.SMSContent = "测试111";
var str = handler.Process(entity);
}
private void button1_Click(object sender, EventArgs e)
{
MessageHandler handler = new MessageHandler();
SMSSendEntity entity = new SMSSendEntity();
entity.SMSSendNO = 66472;
entity.MobileNO = "18019438327";
entity.SMSContent = "测试111";
var str = handler.Process(entity);
}
/// <summary>
/// 删除
/// </summary>
/// <param name="pEntity">实体实例</param>
/// <param name="pTran">事务实例,可为null,如果为null,则不使用事务来更新</param>
public void Delete(SMSSendEntity pEntity, IDbTransaction pTran)
{
//参数校验
if (pEntity == null)
{
throw new ArgumentNullException("pEntity");
}
if (!pEntity.SMSSendID.HasValue)
{
throw new ArgumentException("执行删除时,实体的主键属性值不能为null.");
}
//执行
this.Delete(pEntity.SMSSendID.Value, pTran);
}
public string Process(SMSSendEntity entity)
{
var NO = entity.MobileNO;
string param = "URL{0}";
if (PhoneNOHelper.IsCMCC(NO))
{
param = param.Fmt(2);
}
else if (PhoneNOHelper.IsCUCC(NO))
{
param = param.Fmt(3);
}
else if (PhoneNOHelper.IsCTCC(NO))
{
param = param.Fmt(4);
}
else
{
param = param.Fmt(2);
}
string URL = ConfigurationManager.AppSettings[param];
int retryTime = 0;
bool isSuccess = false;
String postReturn = string.Empty;
while (isSuccess == false && retryTime < 3)
{
try
{
postReturn = doPostRequest(URL, entity.GetRequest().GetCommandStrData());
isSuccess = true;
retryTime++;
}
catch (Exception ex)
{
Loggers.Exception(new ExceptionLogInfo(ex));
if (retryTime >= 3)
{
throw ex;
}
}
}
return(postReturn);
}
/// <summary>
/// 互亿无线
/// </summary>
/// <param name="request"></param>
/// <returns></returns>
internal static Result SendMessage(DataContract.Request request)
{
string url = WebConfigurationManager.AppSettings["SMSSendURL"].ToString();
var para = request.GetParameters <SendSmsReqPara>();
SMSSendBLL bll = new SMSSendBLL(new JIT.Utility.BasicUserInfo());
SMSCustomerBLL smsCustomerBll = new SMSCustomerBLL(new JIT.Utility.BasicUserInfo());
var smsCustomer = smsCustomerBll.GetByID(null, para.Sign);
var entity = new SMSSendEntity()
{
MobileNO = para.MobileNO,
Sign = para.Sign,
SMSContent = para.SMSContent,
Account = smsCustomer.Account,
Password = smsCustomer.Password
};
//调用短信接口直接发送
var result = GetResult(entity.GetSMS().Send2(JIT.Utility.SMS.Base.SendType.Get, url));//GetSMS确定了是用的HuYiSMS
if (result.IsSuccess)
{
entity.Status = 1;
entity.SendCount = (entity.SendCount ?? 0) + 1;
entity.Mtmsgid = result.SMSID;
entity.RegularlySendTime = DateTime.Now;
Loggers.Debug(new DebugLogInfo()
{
Message = "【发送成功】{0}【手机号】:{1}{0}【内容】:{2}{0}【返回码】：{3}".Fmt(Environment.NewLine, entity.MobileNO, entity.SMSContent, result.ToJSON())
});
}
else
{
entity.SendCount = (entity.SendCount ?? 0) + 1;
Loggers.Debug(new DebugLogInfo()
{
Message = "【发送失败】{0}【手机号】:{1}{0}【内容】:{2}{0}【错误信息】:{3}".Fmt(Environment.NewLine, entity.MobileNO, entity.SMSContent, result.ToJSON())
});
}
//保存数据库
bll.Create(entity);
return(result);
}
/// <summary>
/// 删除
/// </summary>
/// <param name="pEntity"></param>
public void Delete(SMSSendEntity pEntity)
{
this.Delete(pEntity, null);
}
/// <summary>
/// 更新
/// </summary>
/// <param name="pEntity">实体实例</param>
public void Update(SMSSendEntity pEntity)
{
this.Update(pEntity, null);
}
/// <summary>
/// 更新
/// </summary>
/// <param name="pEntity">实体实例</param>
/// <param name="pTran">事务实例,可为null,如果为null,则不使用事务来更新</param>
public void Update(SMSSendEntity pEntity, IDbTransaction pTran, bool pIsUpdateNullField)
{
//参数校验
if (pEntity == null)
{
throw new ArgumentNullException("pEntity");
}
if (!pEntity.SMSSendID.HasValue)
{
throw new ArgumentException("执行更新时,实体的主键属性值不能为null.");
}
//组织参数化SQL
StringBuilder strSql = new StringBuilder();
strSql.Append("update [SMS_send] set ");
if (pIsUpdateNullField || pEntity.MobileNO != null)
{
strSql.Append("[Mobile_NO]=@MobileNO,");
}
if (pIsUpdateNullField || pEntity.SMSContent != null)
{
strSql.Append("[SMS_content]=@SMSContent,");
}
if (pIsUpdateNullField || pEntity.SendTime != null)
{
strSql.Append("[Send_time]=@SendTime,");
}
if (pIsUpdateNullField || pEntity.RegularlySendTime != null)
{
strSql.Append("[Regularly_send_time]=@RegularlySendTime,");
}
if (pIsUpdateNullField || pEntity.SMSSendNO != null)
{
strSql.Append("[SMS_send_NO]=@SMSSendNO,");
}
if (pIsUpdateNullField || pEntity.UserID != null)
{
strSql.Append("[User_id]=@UserID,");
}
if (pIsUpdateNullField || pEntity.Status != null)
{
strSql.Append("[Status]=@Status,");
}
if (pIsUpdateNullField || pEntity.SMSStatus != null)
{
strSql.Append("[SMS_status]=@SMSStatus,");
}
if (pIsUpdateNullField || pEntity.Mtmsgid != null)
{
strSql.Append("[mtmsgid]=@Mtmsgid,");
}
if (pIsUpdateNullField || pEntity.ReceiveUserID != null)
{
strSql.Append("[Receive_user_id]=@ReceiveUserID,");
}
if (pIsUpdateNullField || pEntity.SendCount != null)
{
strSql.Append("[Send_count]=@SendCount,");
}
if (pIsUpdateNullField || pEntity.Sign != null)
{
strSql.Append("[sign]=@Sign,");
}
if (pIsUpdateNullField || pEntity.SMSSource != null)
{
strSql.Append("[SMS_source]=@SMSSource");
}
strSql.Append(" where SMS_send_id=@SMSSendID ");
SqlParameter[] parameters =
{
new SqlParameter("@MobileNO", SqlDbType.NChar),
new SqlParameter("@SMSContent", SqlDbType.NVarChar),
new SqlParameter("@SendTime", SqlDbType.DateTime),
new SqlParameter("@RegularlySendTime", SqlDbType.DateTime),
new SqlParameter("@SMSSendNO", SqlDbType.Int),
new SqlParameter("@UserID", SqlDbType.Int),
new SqlParameter("@Status", SqlDbType.Int),
new SqlParameter("@SMSStatus", SqlDbType.Int),
new SqlParameter("@Mtmsgid", SqlDbType.NChar),
new SqlParameter("@ReceiveUserID", SqlDbType.Int),
new SqlParameter("@SendCount", SqlDbType.Int),
new SqlParameter("@Sign", SqlDbType.NVarChar),
new SqlParameter("@SMSSource", SqlDbType.Int),
new SqlParameter("@SMSSendID", SqlDbType.Int)
};
parameters[0].Value = pEntity.MobileNO;
parameters[1].Value = pEntity.SMSContent;
parameters[2].Value = pEntity.SendTime;
parameters[3].Value = pEntity.RegularlySendTime;
parameters[4].Value = pEntity.SMSSendNO;
parameters[5].Value = pEntity.UserID;
parameters[6].Value = pEntity.Status;
parameters[7].Value = pEntity.SMSStatus;
parameters[8].Value = pEntity.Mtmsgid;
parameters[9].Value = pEntity.ReceiveUserID;
parameters[10].Value = pEntity.SendCount;
parameters[11].Value = pEntity.Sign;
parameters[12].Value = pEntity.SMSSource;
parameters[13].Value = pEntity.SMSSendID;
//执行语句
int result = 0;
if (pTran != null)
{
result = this.SQLHelper.ExecuteNonQuery((SqlTransaction)pTran, CommandType.Text, strSql.ToString(), parameters);
}
else
{
result = this.SQLHelper.ExecuteNonQuery(CommandType.Text, strSql.ToString(), parameters);
}
}
/// <summary>
/// 分页根据实体条件查询实体
/// </summary>
/// <param name="pQueryEntity">以实体形式传入的参数</param>
/// <param name="pOrderBys">排序组合</param>
/// <returns>符合条件的实体集</returns>
public PagedQueryResult <SMSSendEntity> PagedQueryByEntity(SMSSendEntity pQueryEntity, OrderBy[] pOrderBys, int pPageSize, int pCurrentPageIndex)
{
return(_currentDAO.PagedQueryByEntity(pQueryEntity, pOrderBys, pPageSize, pCurrentPageIndex));
}
/// <summary>
/// 在事务内创建一个新实例
/// </summary>
/// <param name="pEntity">实体实例</param>
/// <param name="pTran">事务实例,可为null,如果为null,则不使用事务来更新</param>
public void Create(SMSSendEntity pEntity, IDbTransaction pTran)
{
//参数校验
if (pEntity == null)
{
throw new ArgumentNullException("pEntity");
}
//初始化固定字段
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into [SMS_send](");
strSql.Append("[Mobile_NO],[SMS_content],[Send_time],[Regularly_send_time],[SMS_send_NO],[User_id],[Status],[SMS_status],[mtmsgid],[Receive_user_id],[Send_count],[sign],[SMS_source])");
strSql.Append(" values (");
strSql.Append("@MobileNO,@SMSContent,@SendTime,@RegularlySendTime,@SMSSendNO,@UserID,@Status,@SMSStatus,@Mtmsgid,@ReceiveUserID,@SendCount,@Sign,@SMSSource)");
strSql.AppendFormat("{0}select SCOPE_IDENTITY();", Environment.NewLine);
SqlParameter[] parameters =
{
new SqlParameter("@MobileNO", SqlDbType.NChar),
new SqlParameter("@SMSContent", SqlDbType.NVarChar),
new SqlParameter("@SendTime", SqlDbType.DateTime),
new SqlParameter("@RegularlySendTime", SqlDbType.DateTime),
new SqlParameter("@SMSSendNO", SqlDbType.Int),
new SqlParameter("@UserID", SqlDbType.Int),
new SqlParameter("@Status", SqlDbType.Int),
new SqlParameter("@SMSStatus", SqlDbType.Int),
new SqlParameter("@Mtmsgid", SqlDbType.NChar),
new SqlParameter("@ReceiveUserID", SqlDbType.Int),
new SqlParameter("@SendCount", SqlDbType.Int),
new SqlParameter("@Sign", SqlDbType.NVarChar),
new SqlParameter("@SMSSource", SqlDbType.Int)
};
parameters[0].Value = pEntity.MobileNO;
parameters[1].Value = pEntity.SMSContent;
parameters[2].Value = pEntity.SendTime;
parameters[3].Value = pEntity.RegularlySendTime;
parameters[4].Value = pEntity.SMSSendNO;
parameters[5].Value = pEntity.UserID;
parameters[6].Value = pEntity.Status;
parameters[7].Value = pEntity.SMSStatus;
parameters[8].Value = pEntity.Mtmsgid;
parameters[9].Value = pEntity.ReceiveUserID;
parameters[10].Value = pEntity.SendCount;
parameters[11].Value = pEntity.Sign;
parameters[12].Value = pEntity.SMSSource;
//执行并将结果回写
object result;
if (pTran != null)
{
result = this.SQLHelper.ExecuteScalar((SqlTransaction)pTran, CommandType.Text, strSql.ToString(), parameters);
}
else
{
result = this.SQLHelper.ExecuteScalar(CommandType.Text, strSql.ToString(), parameters);
}
pEntity.SMSSendID = Convert.ToInt32(result);
}
/// <summary>
/// 分页根据实体条件查询实体
/// </summary>
/// <param name="pQueryEntity">以实体形式传入的参数</param>
/// <param name="pOrderBys">排序组合</param>
/// <returns>符合条件的实体集</returns>
public PagedQueryResult <SMSSendEntity> PagedQueryByEntity(SMSSendEntity pQueryEntity, OrderBy[] pOrderBys, int pPageSize, int pCurrentPageIndex)
{
IWhereCondition[] queryWhereCondition = GetWhereConditionByEntity(pQueryEntity);
return(PagedQuery(queryWhereCondition, pOrderBys, pPageSize, pCurrentPageIndex));
}
/// <summary>
/// 删除
/// </summary>
/// <param name="pEntity"></param>
public void Delete(SMSSendEntity pEntity)
{
_currentDAO.Delete(pEntity);
}
/// <summary>
/// 删除
/// </summary>
/// <param name="pEntity">实体实例</param>
/// <param name="pTran">事务实例,可为null,如果为null,则不使用事务来更新</param>
public void Delete(SMSSendEntity pEntity, IDbTransaction pTran)
{
_currentDAO.Delete(pEntity, pTran);
}
/// <summary>
/// 更新
/// </summary>
/// <param name="pEntity">实体实例</param>
/// <param name="pTran">事务实例,可为null,如果为null,则不使用事务来更新</param>
public void Update(SMSSendEntity pEntity, IDbTransaction pTran)
{
_currentDAO.Update(pEntity, pTran);
}
/// <summary>
/// 创建一个新实例
/// </summary>
/// <param name="pEntity">实体实例</param>
public void Create(SMSSendEntity pEntity)
{
_currentDAO.Create(pEntity);
}
/// <summary>
/// 创建一个新实例
/// </summary>
/// <param name="pEntity">实体实例</param>
public void Create(SMSSendEntity pEntity)
{
this.Create(pEntity, null);
}
/// <summary>
/// 根据实体条件查询实体
/// </summary>
/// <param name="pQueryEntity">以实体形式传入的参数</param>
/// <param name="pOrderBys">排序组合</param>
/// <returns>符合条件的实体集</returns>
public SMSSendEntity[] QueryByEntity(SMSSendEntity pQueryEntity, OrderBy[] pOrderBys)
{
IWhereCondition[] queryWhereCondition = GetWhereConditionByEntity(pQueryEntity);
return(Query(queryWhereCondition, pOrderBys));
}
/// <summary>
/// 更新
/// </summary>
/// <param name="pEntity">实体实例</param>
public void Update(SMSSendEntity pEntity)
{
_currentDAO.Update(pEntity);
}
/// <summary>
/// 根据实体非Null属性生成查询条件。
/// </summary>
/// <returns></returns>
protected IWhereCondition[] GetWhereConditionByEntity(SMSSendEntity pQueryEntity)
{
//获取非空属性数量
List <EqualsCondition> lstWhereCondition = new List <EqualsCondition>();
if (pQueryEntity.SMSSendID != null)
{
lstWhereCondition.Add(new EqualsCondition()
{
FieldName = "SMSSendID", Value = pQueryEntity.SMSSendID
});
}
if (pQueryEntity.MobileNO != null)
{
lstWhereCondition.Add(new EqualsCondition()
{
FieldName = "MobileNO", Value = pQueryEntity.MobileNO
});
}
if (pQueryEntity.SMSContent != null)
{
lstWhereCondition.Add(new EqualsCondition()
{
FieldName = "SMSContent", Value = pQueryEntity.SMSContent
});
}
if (pQueryEntity.SendTime != null)
{
lstWhereCondition.Add(new EqualsCondition()
{
FieldName = "SendTime", Value = pQueryEntity.SendTime
});
}
if (pQueryEntity.RegularlySendTime != null)
{
lstWhereCondition.Add(new EqualsCondition()
{
FieldName = "RegularlySendTime", Value = pQueryEntity.RegularlySendTime
});
}
if (pQueryEntity.SMSSendNO != null)
{
lstWhereCondition.Add(new EqualsCondition()
{
FieldName = "SMSSendNO", Value = pQueryEntity.SMSSendNO
});
}
if (pQueryEntity.UserID != null)
{
lstWhereCondition.Add(new EqualsCondition()
{
FieldName = "UserID", Value = pQueryEntity.UserID
});
}
if (pQueryEntity.Status != null)
{
lstWhereCondition.Add(new EqualsCondition()
{
FieldName = "Status", Value = pQueryEntity.Status
});
}
if (pQueryEntity.SMSStatus != null)
{
lstWhereCondition.Add(new EqualsCondition()
{
FieldName = "SMSStatus", Value = pQueryEntity.SMSStatus
});
}
if (pQueryEntity.Mtmsgid != null)
{
lstWhereCondition.Add(new EqualsCondition()
{
FieldName = "Mtmsgid", Value = pQueryEntity.Mtmsgid
});
}
if (pQueryEntity.ReceiveUserID != null)
{
lstWhereCondition.Add(new EqualsCondition()
{
FieldName = "ReceiveUserID", Value = pQueryEntity.ReceiveUserID
});
}
if (pQueryEntity.SendCount != null)
{
lstWhereCondition.Add(new EqualsCondition()
{
FieldName = "SendCount", Value = pQueryEntity.SendCount
});
}
if (pQueryEntity.Sign != null)
{
lstWhereCondition.Add(new EqualsCondition()
{
FieldName = "Sign", Value = pQueryEntity.Sign
});
}
if (pQueryEntity.SMSSource != null)
{
lstWhereCondition.Add(new EqualsCondition()
{
FieldName = "SMSSource", Value = pQueryEntity.SMSSource
});
}
return(lstWhereCondition.ToArray());
}
/// <summary>
/// 更新
/// </summary>
/// <param name="pEntity">实体实例</param>
/// <param name="pTran">事务实例,可为null,如果为null,则不使用事务来更新</param>
public void Update(SMSSendEntity pEntity, IDbTransaction pTran)
{
Update(pEntity, pTran, true);
}
/// <summary>
/// 装载实体
/// </summary>
/// <param name="pReader">向前只读器</param>
/// <param name="pInstance">实体实例</param>
protected void Load(SqlDataReader pReader, out SMSSendEntity pInstance)
{
//将所有的数据从SqlDataReader中读取到Entity中
pInstance = new SMSSendEntity();
pInstance.PersistenceHandle = new PersistenceHandle();
pInstance.PersistenceHandle.Load();
if (pReader["SMS_send_id"] != DBNull.Value)
{
pInstance.SMSSendID = Convert.ToInt32(pReader["SMS_send_id"]);
}
if (pReader["Mobile_NO"] != DBNull.Value)
{
pInstance.MobileNO = Convert.ToString(pReader["Mobile_NO"]);
}
if (pReader["SMS_content"] != DBNull.Value)
{
pInstance.SMSContent = Convert.ToString(pReader["SMS_content"]);
}
if (pReader["Send_time"] != DBNull.Value)
{
pInstance.SendTime = Convert.ToDateTime(pReader["Send_time"]);
}
if (pReader["Regularly_send_time"] != DBNull.Value)
{
pInstance.RegularlySendTime = Convert.ToDateTime(pReader["Regularly_send_time"]);
}
if (pReader["SMS_send_NO"] != DBNull.Value)
{
pInstance.SMSSendNO = Convert.ToInt32(pReader["SMS_send_NO"]);
}
if (pReader["User_id"] != DBNull.Value)
{
pInstance.UserID = Convert.ToInt32(pReader["User_id"]);
}
if (pReader["Status"] != DBNull.Value)
{
pInstance.Status = Convert.ToInt32(pReader["Status"]);
}
if (pReader["SMS_status"] != DBNull.Value)
{
pInstance.SMSStatus = Convert.ToInt32(pReader["SMS_status"]);
}
if (pReader["mtmsgid"] != DBNull.Value)
{
pInstance.Mtmsgid = Convert.ToString(pReader["mtmsgid"]);
}
if (pReader["Receive_user_id"] != DBNull.Value)
{
pInstance.ReceiveUserID = Convert.ToInt32(pReader["Receive_user_id"]);
}
if (pReader["Send_count"] != DBNull.Value)
{
pInstance.SendCount = Convert.ToInt32(pReader["Send_count"]);
}
if (pReader["sign"] != DBNull.Value)
{
pInstance.Sign = Convert.ToString(pReader["sign"]);
}
if (pReader["SMS_source"] != DBNull.Value)
{
pInstance.SMSSource = Convert.ToInt32(pReader["SMS_source"]);
}
if (pReader["SMSCustomerID"] != DBNull.Value)
{
pInstance.SMSCustomerID = Convert.ToString(pReader["SMSCustomerID"]);
}
}
/// <summary>
/// 根据实体条件查询实体
/// </summary>
/// <param name="pQueryEntity">以实体形式传入的参数</param>
/// <param name="pOrderBys">排序组合</param>
/// <returns>符合条件的实体集</returns>
public SMSSendEntity[] QueryByEntity(SMSSendEntity pQueryEntity, OrderBy[] pOrderBys)
{
return(_currentDAO.QueryByEntity(pQueryEntity, pOrderBys));
}
