/// <summary>
/// 分页查询
/// </summary>
/// <param name="obj"></param>
/// <param name="pager"></param>
/// <returns></returns>
public List <Mes_Tec_TestDataPosition> FindByPage(Mes_Tec_TestDataPosition obj, ref PagerBase pager)
{
string sql = @"SELECT T1.*,T2.Name AS ProcessName FROM Mes_Tec_TestDataPosition T1 WITH(NOLOCK)
LEFT JOIN Mes_Tec_Process T2 WITH(NOLOCK) ON T1.ProcessCode=T2.ProcessCode
WHERE 1=1 ";
if (!string.IsNullOrEmpty(obj.ProcessCode))
{
sql += string.Format(" AND T1.ProcessCode Like '%{0}%'", obj.ProcessCode);
}
if (!string.IsNullOrEmpty(obj.DataTableName))
{
sql += string.Format(" AND T1.DataTableName Like '%{0}%'", obj.DataTableName);
}
if (!string.IsNullOrEmpty(obj.DataProcessName))
{
sql += string.Format(" AND T1.DataProcessName Like '%{0}%'", obj.DataProcessName);
}
string orderBy = pager.OrderBy;
if (string.IsNullOrEmpty(orderBy))
{
orderBy = "CreatedTime DESC";
}
string cmdPageSql = string.Format(BaseDao.PageSql, orderBy, sql, pager.StartNo, pager.EndNo);
string cmdCountSql = string.Format(BaseDao.CountSql, sql.Substring(sql.ToLower().IndexOf("from", StringComparison.Ordinal)));
//查询总记录数
pager.TotalItemCount = this.CurDbSession.FromSql(cmdCountSql).ToScalar <int>();
//返回当前页的记录数
return(this.CurDbSession.FromSql(cmdPageSql).ToList <Mes_Tec_TestDataPosition>());
}
public ActionResult TestDataPosition_FindByPage(Mes_Tec_TestDataPosition obj, int page, int rows)
{
var pager = new PagerBase()
{
CurrentPageIndex = page, PageSize = rows
};
var list = MesTecTestDataPositionDao.Instance.FindByPage(obj, ref pager);
return(Json(new { total = pager.TotalItemCount, rows = list }));
}
/// <summary>
/// 获取单个用户实体
/// </summary>
/// <param name="obj"></param>
/// <returns></returns>
public Mes_Tec_TestDataPosition GetTestDataPosition(Mes_Tec_TestDataPosition obj)
{
List <SqlParameter> list = new List <SqlParameter>();
string sql = "select top 1 * from Mes_Tec_TestDataPosition where 1=1 ";
if (!string.IsNullOrEmpty(obj.ProcessCode))
{
sql = sql + string.Format(" AND ProcessCode='{0}'", obj.ProcessCode);
}
if (!string.IsNullOrEmpty(obj.DataTableName))
{
sql = sql + string.Format(" AND DataTableName='{0}'", obj.DataTableName);
}
if (!string.IsNullOrEmpty(obj.DataProcessName))
{
sql = sql + string.Format(" AND DataProcessName='{0}'", obj.DataProcessName);
}
return(this.CurDbSession.FromSql(sql.ToString()).ToFirstDefault <Mes_Tec_TestDataPosition>());
}
/// <summary>
/// 保存用户
/// </summary>
/// <param name="obj"></param>
/// <returns></returns>
public bool Save(Mes_Tec_TestDataPosition obj)
{
int result = -1;
if (obj.ID > 0)
{
//修改
result = this.CurDbSession.Update <Mes_Tec_TestDataPosition>(obj);
}
else
{
result = this.CurDbSession.Insert <Mes_Tec_TestDataPosition>(obj);
}
if (result < 0)
{
return(false);
}
return(true);
}
/// <summary>
/// 保存记录
/// </summary>
/// <returns></returns>
public ActionResult TestDataPosition_Save(Mes_Tec_TestDataPosition obj)
{
string sMessage = string.Empty;
//判断数据有效性
if (string.IsNullOrEmpty(obj.ProcessCode))
{
sMessage = "工序编号不可为空";
return(Json(new { IsSuccess = false, Message = sMessage }, JsonRequestBehavior.AllowGet));
}
if (string.IsNullOrEmpty(obj.DataTableName))
{
sMessage = "测试数据表名称不可为空";
return(Json(new { IsSuccess = false, Message = sMessage }, JsonRequestBehavior.AllowGet));
}
if (string.IsNullOrEmpty(obj.DataProcessName))
{
sMessage = "测试工序不可为空";
return(Json(new { IsSuccess = false, Message = sMessage }, JsonRequestBehavior.AllowGet));
}
if (obj.ID > 0)
{
obj.Modifier = base.CurUser.UserId;
obj.ModifiedTime = DateTime.Now;
}
else
{
obj.Creater = base.CurUser.UserId;
obj.CreatedTime = DateTime.Now;
}
bool result = MesTecTestDataPositionDao.Instance.Save(obj);
if (!result)
{
sMessage = "保存失败";
return(Json(new { IsSuccess = false, Message = sMessage }, JsonRequestBehavior.AllowGet));
}
return(Json(new { IsSuccess = true, Message = sMessage }, JsonRequestBehavior.AllowGet));
}
