public static IEnumerable <TireRecallModel> SelectList(TireRecallModel model)
{
using (var dbHelper = new SqlDbHelper(ConnectionHelper.GetDecryptConn("Tuhu_log")))
{
// pager.TotalItem = GetListCount(dbHelper, model, pager);
return(dbHelper.ExecuteDataTable(@"SELECT [PKID]
,[OrderNo]
,[Mobile]
,[CarNo]
,[VehicleLicenseImg]
,[TireDetailImg]
,[TireAndLicenseImg]
,[OrderImg]
,[Status]
,[LastAuthor]
,[UpdateTime]
,[CreateTime]
,[Reason]
,ISNULL([Num],0) AS Num
FROM [dbo].[tbl_ProductRecall](nolock)
where (OrderNo=@OrderNo or @OrderNo is null)
and (Mobile=@Mobile or @Mobile is null)
and (Status=@Status or @Status=-1)
order by PKID desc
;", CommandType.Text,
new SqlParameter[] {
new SqlParameter("@OrderNo", String.IsNullOrWhiteSpace(model.OrderNo)?null:model.OrderNo),
new SqlParameter("@Mobile", String.IsNullOrWhiteSpace(model.Mobile)?null:model.Mobile),
new SqlParameter("@Status", model.Status)
}).ConvertTo <TireRecallModel>());
}
}
public static int GetListCount(SqlDbHelper dbHelper, TireRecallModel model, PagerModel pager)
{
var OBJ = dbHelper.ExecuteScalar(@"select count(OrderNo) from [dbo].[tbl_ProductRecall](nolock) where (OrderNo=@OrderNo or @OrderNo is null)
and (Mobile=@Mobile or @Mobile is null)
and (Status=@Status or @Status=-1)", CommandType.Text,
new SqlParameter[] {
new SqlParameter("@OrderNo", String.IsNullOrWhiteSpace(model.OrderNo)?null:model.OrderNo),
new SqlParameter("@Mobile", String.IsNullOrWhiteSpace(model.Mobile)?null:model.Mobile),
new SqlParameter("@Status", model.Status)
});
return(Convert.ToInt32(OBJ));
}
public static bool InsertTireRecallLog(TireRecallModel model)
{
using (var dbHelper = new SqlDbHelper(ConnectionHelper.GetDecryptConn("Tuhu_log")))
{
using (var cmd =
new SqlCommand(
@"INSERT INTO [dbo].[TireRecallLog]([RecallID],[OperateType],[CreateDateTime],[LastUpdateDateTime],[Operator],[Reason])
VALUES(@RecallID,@OperateType,@CreateDateTime,@LastUpdateDateTime,@Operator,@Reason)")
)
{
DateTime now = DateTime.Now;
cmd.CommandType = CommandType.Text;
cmd.Parameters.AddWithValue("@RecallID", model.PKID);
cmd.Parameters.AddWithValue("@OperateType", model.OperateType);
cmd.Parameters.AddWithValue("@CreateDateTime", now);
cmd.Parameters.AddWithValue("@LastUpdateDateTime", now);
cmd.Parameters.AddWithValue("@Operator", model.Operator);
cmd.Parameters.AddWithValue("@Reason", model.Reason);
return(dbHelper.ExecuteNonQuery(cmd) > 0 ? true : false);
}
}
}
public static bool InsertProductRecallLog(TireRecallModel model) => DalTireRecall.InsertTireRecallLog(model);
public static IEnumerable <TireRecallModel> SelectList(TireRecallModel model) => DalTireRecall.SelectList(model);
public static IEnumerable <TireRecallModel> SelectList(TireRecallModel model, PagerModel pager) => DalTireRecall.SelectList(model, pager);
