public bool Insert(tbOrderSync OrderSync) { bool IsOk = false; IDbDataParameter[] parm = GetInsertParam(); parm[0].Value = OrderSync.UserId; parm[1].Value = OrderSync.Sync; parm[2].Value = OrderSync.SyncEnum; try { DBHelper.ExecuteNonQuery(CommandType.StoredProcedure, SQL_INSERT, parm); IsOk = true; } catch { } return(IsOk); }
public bool Update(tbOrderSync OrderSync) { bool IsOk = false; IDbDataParameter[] parm = GetUpdateParam(); parm[0].Value = OrderSync.UserId; parm[1].Value = OrderSync.Sync; parm[2].Value = OrderSync.SyncEnum; parm[3].Value = OrderSync.LastModifyTime; try { DBHelper.ExecuteNonQuery(CommandType.StoredProcedure, SQL_UPDATE, parm); IsOk = true; } catch { } return(IsOk); }
public tbOrderSync Select(int UserId, int SyncEnum) { tbOrderSync Sync = null; IDbDataParameter[] parm = GetSelecByUIdParam(); parm[0].Value = UserId; parm[1].Value = SyncEnum; using (IDataReader MyReader = DBHelper.ExecuteReader(CommandType.StoredProcedure, SQL_SELECT, parm)) { if (MyReader.Read()) { Sync = new tbOrderSync() { UserId = MyReader.GetInt32(0), Sync = MyReader.GetBoolean(1), SyncEnum = MyReader.GetInt32(2), LastModifyTime = MyReader.GetDateTime(3), }; } } return(Sync == null ? new tbOrderSync() : Sync); }
/// <summary> /// 修改订单同步状态信息 /// </summary> /// <param name="OrderSync">订单同步状态表</param> /// <returns></returns> public static bool Update(tbOrderSync OrderSync) { return(OrderSyncDal.Update(OrderSync)); }
/// <summary> /// 添加订单同步状态信息 /// </summary> /// <param name="OrderSync">订单同步状态表</param> /// <returns></returns> public static bool Insert(tbOrderSync OrderSync) { return(OrderSyncDal.Insert(OrderSync)); }