摘要:
public static class PagerHelper { #region 数字分页类 /// /// /// /// 总记录数 /// 每页显示条数 /// 总页数 /// 当前页数 /// Url /// public static string strPage (int intCounts , int intPageSizes, int intPageCounts, int intThisPages... 阅读全文
摘要:
//CC_AutoId, CC_LoginId, CC_LoginPassword, CC_UserName, CC_ErrorTimes, CC_LockDateTime, CC_TestIntstringsqlStr="select * from T_Seats";using(SqlDataReaderreader=Alian_SQL_Helper.SqlHelper.ExecuteReader(sqlStr,CommandType.Text)) {if(reader.HasRows) { //获得列的索引intautoIdindex=reader.GetOrdinal 阅读全文
摘要:
using (FileStream fileStreamRead = new FileStream("new.xls" , FileMode.Open )) { //创建工作簿 IWorkbook wk = new HSSFWorkbook (fileStreamRead ); //获得工作表的个数 int sheetCount = wk.NumberOfSheets; for (int i = 0... 阅读全文
摘要:
//获取数据 using (SqlDataReader reader = Alian_SQL_Helper.SQL_Helper .ExecuteReader( "select CC_AutoId, CC_CustomerName, CC_CellPhone, CC_Landline, CC_Postcode, CC_Email, CC_Address, CC_BranchId, CC_BuyDate, CC_CarNum, CC_BracketNum, CC_Brand, CC_TypeNum, CC_Suggest... 阅读全文