/// <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);
}