/// <summary> /// 修改数据 /// </summary> /// <param name="Item">model</param> /// <returns></returns> public static bool Update(C_Weight Item) { DataBase db = new DataBase(); DataBaseVisitor visitor = new WeightDAL(); bool Flag = false, ReFlag = false; int N = 0; SqlParameter[] prams ={ db.MakeInParam("@Save", SqlDbType.Bit,0, Item.Save), db.MakeInParam("@Show", SqlDbType.Bit,0, Item.Show), db.MakeInParam("@Time", SqlDbType.BigInt,0, Item.Time), db.MakeInParam("@Id", SqlDbType.BigInt,0,Item.Id) }; try { ReFlag = db.TransactSql(visitor, "Update", prams, out N); } catch (Exception ex) { throw ex; } finally { db.Dispose(); } if (ReFlag && N > 0) { Flag = true; } return Flag; }
/// <summary> /// 查询出所有的数据 /// </summary> /// <returns>返回数据源</returns> public static DataSet SelectAll() { DataBase db = new DataBase(); DataBaseVisitor visitor = new WeightDAL(); DataSet ds = new DataSet(); try { ds = db.ReturnDataSet(visitor, "Select", "C_Weight"); } catch (Exception ex) { throw ex; } finally { db.Dispose(); } return ds; }