Esempio n. 1
0
 /// <summary>
 /// 查询出所有的数据
 /// </summary>
 /// <returns>返回数据源</returns>
 public static DataSet BillPrint(string Code,string TableName)
 {
     string retSql = "";
     DataBase db = new DataBase();
     DataBaseVisitor visitor = new BillInfoDAL();
     DataSet ds = new DataSet();
     try
     {
         ds = db.ReturnDataSet(BillInfoSql(Code), TableName);
         //在程序中表示的名字给Capion
         int i=0;
         foreach (DataRow row in BillInfoColName().Tables[0].Rows)
         {
             ds.Tables[TableName].Columns[i].Caption = row[0].ToString().Trim();
             i++;
         }
     }
     catch (Exception ex)
     {
         throw ex;
     }
     finally
     {
         db.Dispose();
     }
     return ds;
 }
Esempio n. 2
0
 /// <summary>
 /// 查询出所有的数据
 /// </summary>
 /// <returns>返回数据源</returns>
 public static string BillInfoSql(string Code)
 {
     string retSql = "";
     DataBase db = new DataBase();
     DataBaseVisitor visitor = new BillInfoDAL();
     SqlDataReader myread;
     try
     {
         db.GetDataReader(visitor, null, out myread, "BillInfoSql");
         while(myread.Read())
         {
             retSql += "," + myread["DBName"].ToString().Trim()+" as " + myread["Name"].ToString().Trim();
         }
         myread.Close();
         retSql= retSql.Substring(1);
         retSql = "Select " + retSql + " From V_D_Saver_D Where Code='"+Code.Trim()+"'";
     }
     catch (Exception ex)
     {
         throw ex;
     }
     finally
     {
         db.Dispose();
     }
     return retSql;
 }
Esempio n. 3
0
 /// <summary>
 /// 得到列名
 /// </summary>
 public static DataSet BillInfoColName()
 {
     DataBase db = new DataBase();
     DataBaseVisitor visitor = new BillInfoDAL();
     DataSet ds = new DataSet();
     try
     {
         ds = db.ReturnDataSet(visitor, "BillInfoColName", "A");
     }
     catch (Exception ex)
     {
         throw ex;
     }
     finally
     {
         db.Dispose();
     }
     return ds;
 }
Esempio n. 4
0
 /// <summary>
 /// 根据类型得到打印的文件和标题
 /// </summary>
 /// <returns></returns>
 public static DataSet PrintParam(string Type)
 {
     DataBase db = new DataBase();
     DataBaseVisitor visitor = new BillInfoDAL();
     SqlParameter[] prams ={
         db.MakeInParam("@TypeName", SqlDbType.VarChar,50,Type)
     };
     DataSet ds = new DataSet();
     try
     {
         ds = db.ReturnDataSet(visitor,prams, "PrintParam");
     }
     catch (Exception ex)
     {
         throw ex;
     }
     finally
     {
         db.Dispose();
     }
     return ds;
 }