/// <summary> /// 查询全部的供应商信息 /// </summary> /// <param name="pageindex"></param> /// <param name="pagesize"></param> /// <param name="RecordCount"></param> /// <param name="PageCount"></param> /// <returns></returns> public static IList <ProviderInfoModel> GetProviderInfoAll(int pageindex, int pagesize, out int RecordCount, out int PageCount) { string conuls = "ID, Number, Name, ForShort, LinkMan, Mobile, Telephone, Fax, Email, Url, Address, BankName, BankAddress, BankNumber, DutyNumber, Remark, Status, PermissionMan, OperateIP, OperateNum"; DataTable table = CommonDataDAL.GetDataTablePage_Sms(pageindex, pagesize, "ProviderInfo", conuls, "", "ID", out RecordCount, out PageCount); IList <ProviderInfoModel> list = new List <ProviderInfoModel>(); foreach (DataRow row in table.Rows) { ProviderInfoModel pro = new ProviderInfoModel(); pro.Address = row["Address"].ToString(); pro.BankAddress = row["BankAddress"].ToString(); pro.BankName = row["BankName"].ToString(); pro.BankNumber = row["BankNumber"].ToString(); pro.DutyNumber = row["DutyNumber"].ToString(); pro.Email = row["Email"].ToString(); pro.Fax = row["Fax"].ToString(); pro.ForShort = row["ForShort"].ToString(); //pro.ID = Convert.ToInt32(row["ID"]); pro.LinkMan = row["LinkMan"].ToString(); pro.Mobile = row["Mobile"].ToString(); pro.Name = row["Name"].ToString(); pro.Number = row["Number"].ToString(); pro.OperateIP = row["OperateIP"].ToString(); pro.OperateNum = row["OperateNum"].ToString(); pro.PermissionMan = row["PermissionMan"].ToString(); pro.Remark = row["Remark"].ToString(); pro.Status = Convert.ToInt32(row["Status"]); pro.Telephone = row["Telephone"].ToString(); pro.Url = row["Url"].ToString(); list.Add(pro); } return(list); }
/// <summary> /// 查询全部未审核的店铺 /// </summary> /// <param name="storeid"></param> /// <param name="storename"></param> /// <param name="ExpectNum"></param> /// <param name="pageindex"></param> /// <param name="pagesize"></param> /// <param name="RecordCount"></param> /// <param name="pagecount"></param> /// <returns></returns> public static DataTable GetAll(string storeid, string storename, int ExpectNum, int pageindex, int pagesize, out int RecordCount, out int pagecount) { string columns = ""; StringBuilder sb = new StringBuilder(); sb.Append(" 1=1 "); if (storeid.Length > 0) { sb.Append("and StoreId='" + storeid + "'"); } if (storename.Length > 0) { sb.Append(" and StoreName='" + storename + "'"); } if (ExpectNum > 0) { sb.Append(" and ExpectNum=" + ExpectNum); } string wheres = sb.ToString(); DataTable table = CommonDataDAL.GetDataTablePage_Sms(pageindex, pagesize, "UnauditedStoreInfo", columns, wheres, "ID", out RecordCount, out pagecount); return(table); }