/// <summary>
/// 删除
/// </summary>
/// <param name="praiseSchedule">要删除的 实际使用ID删除</param>
/// <returns></returns>
public ActionResult DelPraiseSchedule(PraiseSchedule praiseSchedule)
{
bool rs = _adminBLL.PraiseScheduleDel(praiseSchedule);
//记录日志
Log(string.Format("删除[PraiseSchedule]数据:{0}", praiseSchedule.ToString()));
return(DelResult(rs, "PraiseScheduleList"));
}
/// <summary>
/// 增加
/// </summary>
/// <returns></returns>
public ActionResult AddPraiseSchedule()
{
PraiseSchedule praiseSchedule = new PraiseSchedule();
//记录日志
Log(string.Format("查看[PraiseSchedule]新增页面"));
return(View(praiseSchedule));
}
/// <summary>
/// 查看 ] 编辑页面
/// </summary>
/// <param name="ID">要查看的ID</param>
/// <returns></returns>
public ActionResult EditPraiseSchedule(int ID)
{
PraiseSchedule praiseSchedule = _adminBLL.PraiseScheduleGetByID(new PraiseSchedule {
ID = ID
});
//记录日志
Log(string.Format("查看[PraiseSchedule]]编辑页面 数据:{0}", ID));
return(View("AddPraiseSchedule", praiseSchedule));
}
/// <summary>
/// 删除 PraiseSchedule
/// </summary>
/// Create By zhouqi
/// 2017/4/28 12:32:20
/// <param name="praiseSchedule">PraiseSchedule 实体</param>
/// <returns></returns>
public bool PraiseScheduleDel(PraiseSchedule praiseSchedule)
{
DbCommand cmd = DB.GetStoredProcCommand("PraiseSchedule_Del");
DB.AddInParameter(cmd, PraiseSchedule.IDField, DbType.Int32, praiseSchedule.ID);
DB.ExecuteNonQuery(cmd);
//无异常就返回true
return(true);
}
public ActionResult EditPraiseSchedule(PraiseSchedule praiseSchedule)
{
praiseSchedule.WeaponID = -1;
praiseSchedule.Min = 0;
praiseSchedule.Max = 0;
int rs = _adminBLL.PraiseScheduleUpdate(praiseSchedule);
//记录日志
Log(string.Format("编辑[PraiseSchedule]数据:{0}", praiseSchedule.ToString()));
return(EditResult(rs, "操作失败", "PraiseScheduleList"));
}
/// <summary>
/// 获取 PraiseSchedule 翻页列表
/// </summary>
/// Create By zhouqi
/// 2017/4/28 12:32:20
/// <param name="dp">翻页类 如果PageSize = 0 则不翻页</param>
/// <param name="searchPraiseSchedule">PraiseSchedule 查询实体</param>
/// <returns></returns>
public List <PraiseSchedule> PraiseScheduleGetList(ref DataPage dp)
{
DbCommand cmd = DB.GetStoredProcCommand("PraiseSchedule_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 <PraiseSchedule> praiseScheduleList = new List <PraiseSchedule>();
using (IDataReader dr = DB.ExecuteReader(cmd))
{
if (dr.FieldCount > 0)
{
int coID = dr.GetOrdinal(PraiseSchedule.IDField);
int coStartTS = dr.GetOrdinal(PraiseSchedule.StartTSField);
int coEndTS = dr.GetOrdinal(PraiseSchedule.EndTSField);
int coStatus = dr.GetOrdinal(PraiseSchedule.StatusField);
int coMin = dr.GetOrdinal(PraiseSchedule.MinField);
int coMax = dr.GetOrdinal(PraiseSchedule.MaxField);
int coWeaponID = dr.GetOrdinal(PraiseSchedule.WeaponIDField);
int coRandNum = dr.GetOrdinal(PraiseSchedule.RandNumField);
while (dr.Read())
{
PraiseSchedule praiseSchedule = new PraiseSchedule();
praiseSchedule.ID = dr.IsDBNull(coID) ? (int)0 : dr.GetInt32(coID);
praiseSchedule.StartTS = dr.IsDBNull(coStartTS) ? (DateTime)SqlDateTime.Null : dr.GetDateTime(coStartTS);
praiseSchedule.EndTS = dr.IsDBNull(coEndTS) ? (DateTime)SqlDateTime.Null : dr.GetDateTime(coEndTS);
praiseSchedule.Status = dr.IsDBNull(coStatus) ? (int)0 : dr.GetInt32(coStatus);
praiseSchedule.Min = dr.IsDBNull(coMin) ? (int)0 : dr.GetInt32(coMin);
praiseSchedule.Max = dr.IsDBNull(coMax) ? (int)0 : dr.GetInt32(coMax);
praiseSchedule.WeaponID = dr.IsDBNull(coWeaponID) ? (int)0 : dr.GetInt32(coWeaponID);
praiseSchedule.RandNum = dr.IsDBNull(coRandNum) ? (int)0 : dr.GetInt32(coRandNum);
praiseScheduleList.Add(praiseSchedule);
}
}
}
//获取翻页
dp.RowCount = Convert.ToInt64(DB.GetParameterValue(cmd, DataPage.RowCountField));
return(praiseScheduleList);
}
public Int32 PraiseScheduleUpdate(PraiseSchedule searchPraiseSchedule)
{
_admin = new WeaponDesignAdminService.WeaponDesignAdminServiceClient();
Int32 result = 0;
try
{
result = _admin.PraiseScheduleUpdate(searchPraiseSchedule);
_admin.Close();
return(result);
}
catch (Exception ex)
{
_admin.CloseCatch(ex, "PraiseScheduleUpdate failed");
return(result);
}
}
public PraiseSchedule PraiseScheduleGetByID(PraiseSchedule searchPraiseSchedule)
{
_admin = new WeaponDesignAdminService.WeaponDesignAdminServiceClient();
PraiseSchedule result = new PraiseSchedule();
try
{
result = _admin.PraiseScheduleGetByID(searchPraiseSchedule);
_admin.Close();
return(result);
}
catch (Exception ex)
{
_admin.CloseCatch(ex, "PraiseScheduleGetByID failed");
return(result);
}
}
public bool PraiseScheduleDel(PraiseSchedule searchPraiseSchedule)
{
_admin = new WeaponDesignAdminService.WeaponDesignAdminServiceClient();
bool result = false;
try
{
result = _admin.PraiseScheduleDel(searchPraiseSchedule);
_admin.Close();
return(result);
}
catch (Exception ex)
{
_admin.CloseCatch(ex, "PraiseScheduleDel failed");
return(result);
}
}
/// <summary>
/// 增加 PraiseSchedule
/// </summary>
/// Create By zhouqi
/// 2017/4/28 12:32:20
/// <param name="praiseSchedule">PraiseSchedule 实体</param>
/// <returns></returns>
public Int32 PraiseScheduleAdd(PraiseSchedule praiseSchedule)
{
DbCommand cmd = DB.GetStoredProcCommand("PraiseSchedule_Add");
DB.AddParameter(cmd, PraiseSchedule.IDField, DbType.Int32, ParameterDirection.InputOutput, PraiseSchedule.IDField, DataRowVersion.Current, praiseSchedule.ID);
DB.AddInParameter(cmd, PraiseSchedule.StartTSField, DbType.DateTime, praiseSchedule.StartTS);
DB.AddInParameter(cmd, PraiseSchedule.EndTSField, DbType.DateTime, praiseSchedule.EndTS);
DB.AddInParameter(cmd, PraiseSchedule.StatusField, DbType.Int32, praiseSchedule.Status);
DB.AddInParameter(cmd, PraiseSchedule.MinField, DbType.Int32, praiseSchedule.Min);
DB.AddInParameter(cmd, PraiseSchedule.MaxField, DbType.Int32, praiseSchedule.Max);
DB.AddInParameter(cmd, PraiseSchedule.WeaponIDField, DbType.Int32, praiseSchedule.WeaponID);
DB.AddInParameter(cmd, PraiseSchedule.RandNumField, DbType.Int32, praiseSchedule.RandNum);
//增加返回参数
DB.AddParameter(cmd, ConstUtil.ReturnValue, DbType.Int32, ParameterDirection.ReturnValue,
string.Empty, DataRowVersion.Default, (int)ReturnState.UnSuccessful);
DB.ExecuteNonQuery(cmd);
praiseSchedule.ID = Convert.ToInt32(DB.GetParameterValue(cmd, "ID"));
return(praiseSchedule.ID);
}
/// <summary>
/// 根据ID获取 PraiseSchedule
/// </summary>
/// Create By zhouqi
/// 2017/4/28 12:32:20
/// <param name="praiseSchedule">PraiseSchedule 实体</param>
/// <returns></returns>
public PraiseSchedule PraiseScheduleGetByID(PraiseSchedule searchPraiseSchedule)
{
DbCommand cmd = DB.GetStoredProcCommand("PraiseSchedule_GetByID");
DB.AddInParameter(cmd, PraiseSchedule.IDField, DbType.Int32, searchPraiseSchedule.ID);
PraiseSchedule praiseSchedule = new PraiseSchedule();
using (IDataReader dr = DB.ExecuteReader(cmd))
{
if (dr.FieldCount > 0)
{
int coID = dr.GetOrdinal(PraiseSchedule.IDField);
int coStartTS = dr.GetOrdinal(PraiseSchedule.StartTSField);
int coEndTS = dr.GetOrdinal(PraiseSchedule.EndTSField);
int coStatus = dr.GetOrdinal(PraiseSchedule.StatusField);
int coMin = dr.GetOrdinal(PraiseSchedule.MinField);
int coMax = dr.GetOrdinal(PraiseSchedule.MaxField);
int coWeaponID = dr.GetOrdinal(PraiseSchedule.WeaponIDField);
int coRandNum = dr.GetOrdinal(PraiseSchedule.RandNumField);
if (dr.Read())
{
praiseSchedule.ID = dr.GetInt32(coID);
praiseSchedule.StartTS = dr.GetDateTime(coStartTS);
praiseSchedule.EndTS = dr.GetDateTime(coEndTS);
praiseSchedule.Status = dr.GetInt32(coStatus);
praiseSchedule.Min = dr.GetInt32(coMin);
praiseSchedule.Max = dr.GetInt32(coMax);
praiseSchedule.WeaponID = dr.GetInt32(coWeaponID);
praiseSchedule.RandNum = dr.GetInt32(coRandNum);
}
}
}
return(praiseSchedule);
}
public Int32 PraiseScheduleUpdate(PraiseSchedule searchPraiseSchedule)
{
return(_dal.PraiseScheduleUpdate(searchPraiseSchedule));
}
public PraiseSchedule PraiseScheduleGetByID(PraiseSchedule searchPraiseSchedule)
{
return(_dal.PraiseScheduleGetByID(searchPraiseSchedule));
}
public bool PraiseScheduleDel(PraiseSchedule searchPraiseSchedule)
{
return(_dal.PraiseScheduleDel(searchPraiseSchedule));
}
public Int32 PraiseScheduleAdd(PraiseSchedule searchPraiseSchedule)
{
return(_dal.PraiseScheduleAdd(searchPraiseSchedule));
}
