/// <summary>
/// 更新
/// </summary>
/// <param name="pEntity">实体实例</param>
/// <param name="pTran">事务实例,可为null,如果为null,则不使用事务来更新</param>
public void Update(SMSSendResultEntity pEntity, IDbTransaction pTran, bool pIsUpdateNullField)
{
//参数校验
if (pEntity == null)
{
throw new ArgumentNullException("pEntity");
}
if (!pEntity.SendResultID.HasValue)
{
throw new ArgumentException("执行更新时,实体的主键属性值不能为null.");
}
//初始化固定字段
pEntity.LastUpdateTime = DateTime.Now;
pEntity.LastUpdateBy = CurrentUserInfo.UserID;
//组织参数化SQL
StringBuilder strSql = new StringBuilder();
strSql.Append("update [SMS_SendResult] set ");
if (pIsUpdateNullField || pEntity.Command != null)
{
strSql.Append("[Command]=@Command,");
}
if (pIsUpdateNullField || pEntity.Spid != null)
{
strSql.Append("[Spid]=@Spid,");
}
if (pIsUpdateNullField || pEntity.Mtmsgid != null)
{
strSql.Append("[Mtmsgid]=@Mtmsgid,");
}
if (pIsUpdateNullField || pEntity.Rtstat != null)
{
strSql.Append("[Rtstat]=@Rtstat,");
}
if (pIsUpdateNullField || pEntity.Rterrcode != null)
{
strSql.Append("[Rterrcode]=@Rterrcode,");
}
if (pIsUpdateNullField || pEntity.LastUpdateTime != null)
{
strSql.Append("[LastUpdateTime]=@LastUpdateTime,");
}
if (pIsUpdateNullField || pEntity.LastUpdateBy != null)
{
strSql.Append("[LastUpdateBy]=@LastUpdateBy");
}
strSql.Append(" where SendResultID=@SendResultID ");
SqlParameter[] parameters =
{
new SqlParameter("@Command", SqlDbType.NVarChar),
new SqlParameter("@Spid", SqlDbType.NVarChar),
new SqlParameter("@Mtmsgid", SqlDbType.NVarChar),
new SqlParameter("@Rtstat", SqlDbType.NVarChar),
new SqlParameter("@Rterrcode", SqlDbType.NVarChar),
new SqlParameter("@LastUpdateTime", SqlDbType.DateTime),
new SqlParameter("@LastUpdateBy", SqlDbType.NVarChar),
new SqlParameter("@SendResultID", SqlDbType.Int)
};
parameters[0].Value = pEntity.Command;
parameters[1].Value = pEntity.Spid;
parameters[2].Value = pEntity.Mtmsgid;
parameters[3].Value = pEntity.Rtstat;
parameters[4].Value = pEntity.Rterrcode;
parameters[5].Value = pEntity.LastUpdateTime;
parameters[6].Value = pEntity.LastUpdateBy;
parameters[7].Value = pEntity.SendResultID;
//执行语句
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="pEntity">实体实例</param>
/// <param name="pTran">事务实例,可为null,如果为null,则不使用事务来更新</param>
public void Update(SMSSendResultEntity pEntity, IDbTransaction pTran)
{
_currentDAO.Update(pEntity, pTran);
}
/// <summary>
/// 更新
/// </summary>
/// <param name="pEntity">实体实例</param>
/// <param name="pTran">事务实例,可为null,如果为null,则不使用事务来更新</param>
public void Update(SMSSendResultEntity pEntity, IDbTransaction pTran)
{
Update(pEntity, pTran, true);
}
/// <summary>
/// 分页根据实体条件查询实体
/// </summary>
/// <param name="pQueryEntity">以实体形式传入的参数</param>
/// <param name="pOrderBys">排序组合</param>
/// <returns>符合条件的实体集</returns>
public PagedQueryResult <SMSSendResultEntity> PagedQueryByEntity(SMSSendResultEntity pQueryEntity, OrderBy[] pOrderBys, int pPageSize, int pCurrentPageIndex)
{
return(_currentDAO.PagedQueryByEntity(pQueryEntity, pOrderBys, pPageSize, pCurrentPageIndex));
}
/// <summary>
/// 创建一个新实例
/// </summary>
/// <param name="pEntity">实体实例</param>
public void Create(SMSSendResultEntity pEntity)
{
_currentDAO.Create(pEntity);
}
/// <summary>
/// 删除
/// </summary>
/// <param name="pEntity"></param>
public void Delete(SMSSendResultEntity pEntity)
{
_currentDAO.Delete(pEntity);
}
/// <summary>
/// 根据实体条件查询实体
/// </summary>
/// <param name="pQueryEntity">以实体形式传入的参数</param>
/// <param name="pOrderBys">排序组合</param>
/// <returns>符合条件的实体集</returns>
public SMSSendResultEntity[] QueryByEntity(SMSSendResultEntity pQueryEntity, OrderBy[] pOrderBys)
{
return(_currentDAO.QueryByEntity(pQueryEntity, pOrderBys));
}
/// <summary>
/// 装载实体
/// </summary>
/// <param name="pReader">向前只读器</param>
/// <param name="pInstance">实体实例</param>
protected void Load(SqlDataReader pReader, out SMSSendResultEntity pInstance)
{
//将所有的数据从SqlDataReader中读取到Entity中
pInstance = new SMSSendResultEntity();
pInstance.PersistenceHandle = new PersistenceHandle();
pInstance.PersistenceHandle.Load();
if (pReader["SendResultID"] != DBNull.Value)
{
pInstance.SendResultID = Convert.ToInt32(pReader["SendResultID"]);
}
if (pReader["Command"] != DBNull.Value)
{
pInstance.Command = Convert.ToString(pReader["Command"]);
}
if (pReader["Spid"] != DBNull.Value)
{
pInstance.Spid = Convert.ToString(pReader["Spid"]);
}
if (pReader["Sppassword"] != DBNull.Value)
{
pInstance.Sppassword = Convert.ToString(pReader["Sppassword"]);
}
if (pReader["Spsc"] != DBNull.Value)
{
pInstance.Spsc = Convert.ToString(pReader["Spsc"]);
}
if (pReader["Mtmsgid"] != DBNull.Value)
{
pInstance.Mtmsgid = Convert.ToString(pReader["Mtmsgid"]);
}
if (pReader["Mtstat"] != DBNull.Value)
{
pInstance.Mtstat = Convert.ToString(pReader["Mtstat"]);
}
if (pReader["Mterrocde"] != DBNull.Value)
{
pInstance.Mterrocde = Convert.ToString(pReader["Mterrocde"]);
}
if (pReader["Rttime"] != DBNull.Value)
{
pInstance.Rttime = Convert.ToString(pReader["Rttime"]);
}
if (pReader["CreateTime"] != DBNull.Value)
{
pInstance.CreateTime = Convert.ToDateTime(pReader["CreateTime"]);
}
if (pReader["CreateBy"] != DBNull.Value)
{
pInstance.CreateBy = Convert.ToString(pReader["CreateBy"]);
}
if (pReader["LastUpdateTime"] != DBNull.Value)
{
pInstance.LastUpdateTime = Convert.ToDateTime(pReader["LastUpdateTime"]);
}
if (pReader["IsDelete"] != DBNull.Value)
{
pInstance.IsDelete = Convert.ToInt32(pReader["IsDelete"]);
}
if (pReader["LastUpdateBy"] != DBNull.Value)
{
pInstance.LastUpdateBy = Convert.ToString(pReader["LastUpdateBy"]);
}
}
/// <summary>
/// 更新
/// </summary>
/// <param name="pEntity">实体实例</param>
public void Update(SMSSendResultEntity pEntity)
{
_currentDAO.Update(pEntity);
}
/// <summary>
/// 根据实体非Null属性生成查询条件。
/// </summary>
/// <returns></returns>
protected IWhereCondition[] GetWhereConditionByEntity(SMSSendResultEntity pQueryEntity)
{
//获取非空属性数量
List <EqualsCondition> lstWhereCondition = new List <EqualsCondition>();
if (pQueryEntity.SendResultID != null)
{
lstWhereCondition.Add(new EqualsCondition()
{
FieldName = "SendResultID", Value = pQueryEntity.SendResultID
});
}
if (pQueryEntity.Command != null)
{
lstWhereCondition.Add(new EqualsCondition()
{
FieldName = "Command", Value = pQueryEntity.Command
});
}
if (pQueryEntity.Spid != null)
{
lstWhereCondition.Add(new EqualsCondition()
{
FieldName = "Spid", Value = pQueryEntity.Spid
});
}
if (pQueryEntity.Sppassword != null)
{
lstWhereCondition.Add(new EqualsCondition()
{
FieldName = "Sppassword", Value = pQueryEntity.Sppassword
});
}
if (pQueryEntity.Spsc != null)
{
lstWhereCondition.Add(new EqualsCondition()
{
FieldName = "Spsc", Value = pQueryEntity.Spsc
});
}
if (pQueryEntity.Mtmsgid != null)
{
lstWhereCondition.Add(new EqualsCondition()
{
FieldName = "Mtmsgid", Value = pQueryEntity.Mtmsgid
});
}
if (pQueryEntity.Mtstat != null)
{
lstWhereCondition.Add(new EqualsCondition()
{
FieldName = "Mtstat", Value = pQueryEntity.Mtstat
});
}
if (pQueryEntity.Mterrocde != null)
{
lstWhereCondition.Add(new EqualsCondition()
{
FieldName = "Mterrocde", Value = pQueryEntity.Mterrocde
});
}
if (pQueryEntity.Rttime != null)
{
lstWhereCondition.Add(new EqualsCondition()
{
FieldName = "Rttime", Value = pQueryEntity.Rttime
});
}
if (pQueryEntity.CreateTime != null)
{
lstWhereCondition.Add(new EqualsCondition()
{
FieldName = "CreateTime", Value = pQueryEntity.CreateTime
});
}
if (pQueryEntity.CreateBy != null)
{
lstWhereCondition.Add(new EqualsCondition()
{
FieldName = "CreateBy", Value = pQueryEntity.CreateBy
});
}
if (pQueryEntity.LastUpdateTime != null)
{
lstWhereCondition.Add(new EqualsCondition()
{
FieldName = "LastUpdateTime", Value = pQueryEntity.LastUpdateTime
});
}
if (pQueryEntity.IsDelete != null)
{
lstWhereCondition.Add(new EqualsCondition()
{
FieldName = "IsDelete", Value = pQueryEntity.IsDelete
});
}
if (pQueryEntity.LastUpdateBy != null)
{
lstWhereCondition.Add(new EqualsCondition()
{
FieldName = "LastUpdateBy", Value = pQueryEntity.LastUpdateBy
});
}
return(lstWhereCondition.ToArray());
}
/// <summary>
/// 在事务内创建一个新实例
/// </summary>
/// <param name="pEntity">实体实例</param>
/// <param name="pTran">事务实例,可为null,如果为null,则不使用事务来更新</param>
public void Create(SMSSendResultEntity pEntity, IDbTransaction pTran)
{
//参数校验
if (pEntity == null)
{
throw new ArgumentNullException("pEntity");
}
//初始化固定字段
pEntity.CreateTime = DateTime.Now;
pEntity.CreateBy = CurrentUserInfo.UserID;
pEntity.LastUpdateTime = pEntity.CreateTime;
pEntity.LastUpdateBy = CurrentUserInfo.UserID;
pEntity.IsDelete = 0;
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into [SMS_SendResult](");
strSql.Append("[Command],[Spid],[Sppassword],[Spsc],[Mtmsgid],[Mtstat],[Mterrocde],[Rttime],[CreateTime],[CreateBy],[LastUpdateTime],[IsDelete],[LastUpdateBy])");
strSql.Append(" values (");
strSql.Append("@Command,@Spid,@Sppassword,@Spsc,@Mtmsgid,@Mtstat,@Mterrocde,@Rttime,@CreateTime,@CreateBy,@LastUpdateTime,@IsDelete,@LastUpdateBy)");
strSql.AppendFormat("{0}select SCOPE_IDENTITY();", Environment.NewLine);
SqlParameter[] parameters =
{
new SqlParameter("@Command", SqlDbType.NVarChar),
new SqlParameter("@Spid", SqlDbType.NVarChar),
new SqlParameter("@Sppassword", SqlDbType.NVarChar),
new SqlParameter("@Spsc", SqlDbType.NVarChar),
new SqlParameter("@Mtmsgid", SqlDbType.NVarChar),
new SqlParameter("@Mtstat", SqlDbType.NVarChar),
new SqlParameter("@Mterrocde", SqlDbType.NVarChar),
new SqlParameter("@Rttime", SqlDbType.NVarChar),
new SqlParameter("@CreateTime", SqlDbType.DateTime),
new SqlParameter("@CreateBy", SqlDbType.NVarChar),
new SqlParameter("@LastUpdateTime", SqlDbType.DateTime),
new SqlParameter("@IsDelete", SqlDbType.Int),
new SqlParameter("@LastUpdateBy", SqlDbType.NVarChar)
};
parameters[0].Value = pEntity.Command;
parameters[1].Value = pEntity.Spid;
parameters[2].Value = pEntity.Sppassword;
parameters[3].Value = pEntity.Spsc;
parameters[4].Value = pEntity.Mtmsgid;
parameters[5].Value = pEntity.Mtstat;
parameters[6].Value = pEntity.Mterrocde;
parameters[7].Value = pEntity.Rttime;
parameters[8].Value = pEntity.CreateTime;
parameters[9].Value = pEntity.CreateBy;
parameters[10].Value = pEntity.LastUpdateTime;
parameters[11].Value = pEntity.IsDelete;
parameters[12].Value = pEntity.LastUpdateBy;
//执行并将结果回写
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.SendResultID = Convert.ToInt32(result);
}
/// <summary>
/// 分页根据实体条件查询实体
/// </summary>
/// <param name="pQueryEntity">以实体形式传入的参数</param>
/// <param name="pOrderBys">排序组合</param>
/// <returns>符合条件的实体集</returns>
public PagedQueryResult <SMSSendResultEntity> PagedQueryByEntity(SMSSendResultEntity pQueryEntity, OrderBy[] pOrderBys, int pPageSize, int pCurrentPageIndex)
{
IWhereCondition[] queryWhereCondition = GetWhereConditionByEntity(pQueryEntity);
return(PagedQuery(queryWhereCondition, pOrderBys, pPageSize, pCurrentPageIndex));
}
/// <summary>
/// 根据实体条件查询实体
/// </summary>
/// <param name="pQueryEntity">以实体形式传入的参数</param>
/// <param name="pOrderBys">排序组合</param>
/// <returns>符合条件的实体集</returns>
public SMSSendResultEntity[] QueryByEntity(SMSSendResultEntity pQueryEntity, OrderBy[] pOrderBys)
{
IWhereCondition[] queryWhereCondition = GetWhereConditionByEntity(pQueryEntity);
return(Query(queryWhereCondition, pOrderBys));
}
/// <summary>
/// 创建一个新实例
/// </summary>
/// <param name="pEntity">实体实例</param>
public void Create(SMSSendResultEntity pEntity)
{
this.Create(pEntity, null);
}
/// <summary>
/// 删除
/// </summary>
/// <param name="pEntity"></param>
public void Delete(SMSSendResultEntity pEntity)
{
this.Delete(pEntity, null);
}
/// <summary>
/// 更新
/// </summary>
/// <param name="pEntity">实体实例</param>
public void Update(SMSSendResultEntity pEntity)
{
this.Update(pEntity, null);
}
