예제 #1
0
파일: BillBLL.cs 프로젝트: wuyanqing/wc001
 /// <summary>
 /// 修改数据
 /// </summary>
 /// <param name="Item">model</param>
 /// <returns></returns>
 public static bool Update(D_Bill Item)
 {
     DataBase db = new DataBase();
     DataBaseVisitor visitor = new BillDAL();
     bool Flag = false, ReFlag = false;
     int N = 0;
     SqlParameter[] prams ={
         db.MakeInParam("@BillName", SqlDbType.VarChar,50, Item.BillName),
         db.MakeInParam("@PrintTitle", SqlDbType.VarChar,50, Item.PrintTitle),
         db.MakeInParam("@Preview", SqlDbType.Bit,50, Item.Preview),
         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;
 }
예제 #2
0
파일: BillBLL.cs 프로젝트: wuyanqing/wc001
 /// <summary>
 /// 查询出所有的数据
 /// </summary>
 /// <returns>返回数据源</returns>
 public static DataSet SelectAll()
 {
     DataBase db = new DataBase();
     DataBaseVisitor visitor = new BillDAL();
     DataSet ds = new DataSet();
     try
     {
         ds = db.ReturnDataSet(visitor, "Select", "C_Weight");
     }
     catch (Exception ex)
     {
         throw ex;
     }
     finally
     {
         db.Dispose();
     }
     return ds;
 }