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);