/// <summary>
/// 更新 PraiseNumber
/// </summary>
/// Create By zhouqi
/// 2017/4/28 11:50:19
/// <param name="praiseNumber">PraiseNumber 实体</param>
/// <returns></returns>
public Int32 UpdatePraiseNumber(PraiseNumber praiseNumber)
{
DbCommand cmd = DB.GetStoredProcCommand("ChangePraiseNumber");
DB.AddInParameter(cmd, PraiseNumber.NumField, DbType.Int32, praiseNumber.Num);
//增加返回参数
DB.AddParameter(cmd, ConstUtil.ReturnValue, DbType.Int32, ParameterDirection.ReturnValue,
string.Empty, DataRowVersion.Default, (int)ReturnState.UnSuccessful);
DB.ExecuteNonQuery(cmd);
//如果增加成功，返回ID，如果失败，返回0，如果检测到重复值，返回-1
Int32 rs = Convert.ToInt32(DB.GetParameterValue(cmd, ConstUtil.ReturnValue));
return(rs);
}
public Int32 UpdatePraiseNumber(PraiseNumber searchPraiseNumber)
{
_admin = new WeaponDesignAdminService.WeaponDesignAdminServiceClient();
Int32 result = 0;
try
{
result = _admin.UpdatePraiseNumber(searchPraiseNumber);
_admin.Close();
return(result);
}
catch (Exception ex)
{
_admin.CloseCatch(ex, "UpdatePraiseNumber failed");
return(result);
}
}
/// <summary>
/// 获取 PraiseNumber 翻页列表
/// </summary>
/// Create By zhouqi
/// 2017/4/28 11:50:19
/// <param name="dp">翻页类 如果PageSize = 0 则不翻页</param>
/// <param name="searchPraiseNumber">PraiseNumber 查询实体</param>
/// <returns></returns>
public List <PraiseNumber> GetPraiseNumberList(ref DataPage dp)
{
DbCommand cmd = DB.GetStoredProcCommand("PraiseNumber_GetList");
//翻页参数
DB.AddInParameter(cmd, DataPage.PageSizeField, DbType.Int32, dp.PageSize);
DB.AddInParameter(cmd, DataPage.PageIndexField, DbType.Int32, dp.PageIndex);
DB.AddParameter(cmd, DataPage.RowCountField, DbType.Int64, ParameterDirection.InputOutput, String.Empty, DataRowVersion.Default, dp.RowCount);
List <PraiseNumber> praiseNumberList = new List <PraiseNumber>();
using (IDataReader dr = DB.ExecuteReader(cmd))
{
if (dr.FieldCount > 0)
{
int coID = dr.GetOrdinal(PraiseNumber.IDField);
int coNum = dr.GetOrdinal(PraiseNumber.NumField);
while (dr.Read())
{
PraiseNumber praiseNumber = new PraiseNumber();
praiseNumber.ID = dr.IsDBNull(coID) ? (int)0 : dr.GetInt32(coID);
praiseNumber.Num = dr.IsDBNull(coNum) ? (int)0 : dr.GetInt32(coNum);
praiseNumberList.Add(praiseNumber);
}
}
}
//获取翻页
dp.RowCount = Convert.ToInt64(DB.GetParameterValue(cmd, DataPage.RowCountField));
return(praiseNumberList);
}
public Int32 UpdatePraiseNumber(PraiseNumber PraiseNumber)
{
return(_dal.UpdatePraiseNumber(PraiseNumber));
}
