/// <summary>
/// 获取日志
/// </summary>
/// <returns></returns>
public static List <LogEntity> GetLogs(string guid, EnumLogObjectType type, int pageSize, int pageIndex, ref int totalCount, ref int pageCount, string agentid)
{
string tablename = "";
switch (type)
{
case EnumLogObjectType.Customer:
tablename = "CustomerLog";
break;
case EnumLogObjectType.Orders:
tablename = "OrdersLog";
break;
}
DataTable dt = CommonBusiness.GetPagerData(tablename, "*", "LogGUID='" + guid + "'", "AutoID", pageSize, pageIndex, out totalCount, out pageCount);
List <LogEntity> list = new List <LogEntity>();
foreach (DataRow dr in dt.Rows)
{
LogEntity model = new LogEntity();
model.FillData(dr);
model.CreateUser = OrganizationBusiness.GetUserByUserID(model.CreateUserID, model.AgentID);
list.Add(model);
}
return(list);
}
public static List <ClientAuthorizeLog> GetClientAuthorizeLogs(string clientID, string keyWords, int pageSize, int pageIndex, ref int totalCount, ref int pageCount)
{
DataTable dt = CommonBusiness.GetPagerData("ClientAuthorizeLog", "*", " Status<>9 and ClientID='" + clientID + "' ", "AutoID", pageSize, pageIndex, out totalCount, out pageCount);
List <ClientAuthorizeLog> list = new List <ClientAuthorizeLog>();
ClientAuthorizeLog model;
foreach (DataRow item in dt.Rows)
{
model = new ClientAuthorizeLog();
model.FillData(item);
list.Add(model);
}
return(list);
}
public static List <StorageDocAction> GetStorageDocAction(string docid, int pageSize, int pageIndex, ref int totalCount, ref int pageCount, string agentid)
{
DataTable dt = CommonBusiness.GetPagerData("StorageDocAction", "*", "DocID='" + docid + "'", "AutoID", pageSize, pageIndex, out totalCount, out pageCount);
List <StorageDocAction> list = new List <StorageDocAction>();
foreach (DataRow dr in dt.Rows)
{
StorageDocAction model = new StorageDocAction();
model.FillData(dr);
model.CreateUser = OrganizationBusiness.GetUserByUserID(model.CreateUserID, agentid);
list.Add(model);
}
return(list);
}
public List <OrderEntity> GetOpportunityaByCustomerID(string customerid, int pageSize, int pageIndex, ref int totalCount, ref int pageCount, string userid, string agentid, string clientid)
{
List <OrderEntity> list = new List <OrderEntity>();
DataTable dt = CommonBusiness.GetPagerData("Orders", "*", "CustomerID='" + customerid + "' and Status =0 ", "AutoID", pageSize, pageIndex, out totalCount, out pageCount, false);
foreach (DataRow dr in dt.Rows)
{
OrderEntity model = new OrderEntity();
model.FillData(dr);
model.Owner = OrganizationBusiness.GetUserByUserID(model.OwnerID, model.AgentID);
model.Stage = SystemBusiness.BaseBusiness.GetOpportunityStageByID(model.StageID, model.AgentID, model.ClientID);
list.Add(model);
}
return(list);
}
/// <summary>
/// 获取客户端列表
/// </summary>
/// <param name="keyWords"></param>
/// <param name="pageSize"></param>
/// <param name="pageIndex"></param>
/// <param name="totalCount"></param>
/// <param name="pageCount"></param>
/// <returns></returns>
public static List <Clients> GetClients(string keyWords, int pageSize, int pageIndex, ref int totalCount, ref int pageCount)
{
DataTable dt = CommonBusiness.GetPagerData("Clients", "*", "Status<>9", "AutoID", pageSize, pageIndex, out totalCount, out pageCount);
List <Clients> list = new List <Clients>();
Clients model;
foreach (DataRow item in dt.Rows)
{
model = new Clients();
model.FillData(item);
model.City = CommonCache.Citys.Where(c => c.CityCode == model.CityCode).FirstOrDefault();
model.IndustryEntity = IndustryBusiness.GetIndustryByClientID(AppSettings.Settings[AppSettingsWEB.Manage, "ClientID"]).Where(i => i.IndustryID.ToLower() == model.Industry.ToLower()).FirstOrDefault();
list.Add(model);
}
return(list);
}
public List <ProvidersEntity> GetProviders(string keyWords, int pageSize, int pageIndex, ref int totalCount, ref int pageCount, string clientID)
{
var dal = new StockDAL();
string where = " ClientID='" + clientID + "' and Status<>9";
DataTable dt = CommonBusiness.GetPagerData("Providers", "*", where, "AutoID", pageSize, pageIndex, out totalCount, out pageCount);
List <ProvidersEntity> list = new List <ProvidersEntity>();
foreach (DataRow dr in dt.Rows)
{
ProvidersEntity model = new ProvidersEntity();
model.FillData(dr);
model.City = CommonBusiness.Citys.Where(c => c.CityCode == model.CityCode).FirstOrDefault();
list.Add(model);
}
return(list);
}
public List <CustomerEntity> GetCustomersByActivityID(string activityid, int pageSize, int pageIndex, ref int totalCount, ref int pageCount)
{
List <CustomerEntity> list = new List <CustomerEntity>();
string sqlWhere = " ActivityID='" + activityid + "' and status<>9";
DataTable dt = CommonBusiness.GetPagerData("Customer", "*", sqlWhere, "CustomerID", pageSize, pageIndex, out totalCount, out pageCount);
foreach (DataRow dr in dt.Rows)
{
CustomerEntity model = new CustomerEntity();
model.FillData(dr);
model.Owner = OrganizationBusiness.GetUserByUserID(model.OwnerID, model.AgentID);
model.Source = SystemBusiness.BaseBusiness.GetCustomSourcesByID(model.SourceID, model.AgentID, model.ClientID);
model.Stage = SystemBusiness.BaseBusiness.GetCustomStageByID(model.StageID, model.AgentID, model.ClientID);
list.Add(model);
}
return(list);
}
public static List <ReplyEntity> GetReplys(string guid, int pageSize, int pageIndex, ref int totalCount, ref int pageCount)
{
List <ReplyEntity> list = new List <ReplyEntity>();
string whereSql = " Status<>9 and GUID='" + guid + "' ";
DataTable dt = CommonBusiness.GetPagerData("CustomerReply", "*", whereSql, "AutoID", "CreateTime desc ", pageSize, pageIndex, out totalCount, out pageCount, false);
foreach (DataRow dr in dt.Rows)
{
ReplyEntity model = new ReplyEntity();
model.FillData(dr);
model.CreateUser = OrganizationBusiness.GetUserByUserID(model.CreateUserID, model.AgentID);
if (!string.IsNullOrEmpty(model.FromReplyID))
{
model.FromReplyUser = OrganizationBusiness.GetUserByUserID(model.FromReplyUserID, model.FromReplyAgentID);
}
list.Add(model);
}
return(list);
}
/// <summary>
/// 获取客户端列表
/// </summary>
/// <param name="keyWords"></param>
/// <param name="pageSize"></param>
/// <param name="pageIndex"></param>
/// <param name="totalCount"></param>
/// <param name="pageCount"></param>
/// <returns></returns>
public static List <Clients> GetClients(string keyWords, int pageSize, int pageIndex, ref int totalCount, ref int pageCount)
{
string whereSql = "Status<>9";
if (!string.IsNullOrEmpty(keyWords))
{
whereSql += " and ( CompanyName like '%" + keyWords + "%' or MobilePhone like '%" + keyWords + "%')";
}
DataTable dt = CommonBusiness.GetPagerData("Clients", "*", whereSql, "AutoID", pageSize, pageIndex, out totalCount, out pageCount);
List <Clients> list = new List <Clients>();
Clients model;
foreach (DataRow item in dt.Rows)
{
model = new Clients();
model.FillData(item);
model.City = CommonBusiness.Citys.Where(c => c.CityCode == model.CityCode).FirstOrDefault();
model.IndustryEntity = Manage.IndustryBusiness.GetIndustrys().Where(i => i.IndustryID.ToLower() == model.Industry.ToLower()).FirstOrDefault();
list.Add(model);
}
return(list);
}
/// <summary>
/// 获取用户列表
/// </summary>
/// <param name="keyWords"></param>
/// <param name="pageSize"></param>
/// <param name="pageIndex"></param>
/// <param name="totalCount"></param>
/// <param name="pageCount"></param>
/// <returns></returns>
public static List <Users> GetUsers(string keyWords, string departID, string roleID, string agentid, int pageSize, int pageIndex, ref int totalCount, ref int pageCount)
{
string whereSql = "AgentID='" + agentid + "' and Status<>9";
if (!string.IsNullOrEmpty(keyWords))
{
whereSql += " and ( Name like '%" + keyWords + "%' or MobilePhone like '%" + keyWords + "%' or Email like '%" + keyWords + "%')";
}
if (!string.IsNullOrEmpty(departID))
{
whereSql += " and DepartID='" + departID + "'";
}
if (!string.IsNullOrEmpty(roleID))
{
whereSql += " and RoleID='" + roleID + "'";
}
DataTable dt = CommonBusiness.GetPagerData("Users", "*", whereSql, "AutoID", pageSize, pageIndex, out totalCount, out pageCount);
List <Users> list = new List <Users>();
Users model;
foreach (DataRow item in dt.Rows)
{
model = new Users();
model.FillData(item);
model.CreateUser = GetUserByUserID(model.CreateUserID, model.AgentID);
model.Department = GetDepartmentByID(model.DepartID, model.AgentID);
model.Role = GetRoleByIDCache(model.RoleID, model.AgentID);
list.Add(model);
}
return(list);
}