/// <summary> /// 添加数据 /// </summary> /// <param name="Item">model</param> /// <returns></returns> public static bool Insert(DC_Power Item) { DataBase db = new DataBase(); DataBaseVisitor visitor = new PowerDAL(); bool Flag = false, ReFlag = false; int N = 0; SqlParameter[] prams ={ db.MakeInParam("@Id", SqlDbType.BigInt,0,PublicFun.PublicFun.MaxId("DC_Power")), db.MakeInParam("@Code", SqlDbType.VarChar,50, Item.Code), db.MakeInParam("@Name", SqlDbType.VarChar,50, Item.Name), db.MakeInParam("@ParentCode", SqlDbType.VarChar,50, Item.ParentCode), db.MakeInParam("@RuleName", SqlDbType.VarChar,50, Item.RuleName) }; try { ReFlag = db.TransactSql(visitor, "Insert", 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(string WhereSql) { DataBase db = new DataBase(); DataBaseVisitor visitor = new PowerDAL(); DataSet ds = new DataSet(); try { ds = db.ReturnDataSet(visitor, "Select", "DC_Power",WhereSql); } catch (Exception ex) { throw ex; } finally { db.Dispose(); } return ds; }