/// <summary>
/// 编辑部门状态
/// </summary>
/// <param name="departid">部门ID</param>
/// <param name="status">状态</param>
/// <param name="operateid">操作人</param>
/// <param name="operateip">操作IP</param>
/// <returns></returns>
public EnumResultStatus UpdateDepartmentStatus(string departid, EnumStatus status, string operateid, string operateip, string agentid)
{
if (status == EnumStatus.Delete)
{
object count = CommonBusiness.Select("UserDepart", "count(0)", "DepartID='" + departid + "' and Status=1");
if (Convert.ToInt32(count) > 0)
{
return(EnumResultStatus.Exists);
}
}
if (CommonBusiness.Update("Department", "Status", (int)status, "DepartID='" + departid + "' and AgentID='" + agentid + "'"))
{
var model = GetDepartments(agentid).Where(d => d.DepartID == departid).FirstOrDefault();
model.Status = (int)status;
return(EnumResultStatus.Success);
}
else
{
return(EnumResultStatus.Failed);
}
}
/// <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);
}
public static bool UpdateCartBatch(string autoid, string batch, string userid)
{
return(CommonBusiness.Update("ShoppingCart", "BatchCode", batch, "AutoID=" + autoid));
}
public static int GetShoppingCartCount(EnumDocType ordertype, string guid)
{
object obj = CommonBusiness.Select("ShoppingCart", "count(0)", "ordertype=" + (int)ordertype + " and [GUID]='" + guid + "'");
return(Convert.ToInt32(obj));
}
public static bool DeleteClient(string clientID)
{
return(CommonBusiness.Update("Clients", "Status", 9, " ClientID='" + clientID + "'"));
}
/// <summary>
/// 作废单据
/// </summary>
/// <param name="docid"></param>
/// <param name="userid"></param>
/// <param name="operateip"></param>
/// <param name="clientid"></param>
/// <returns></returns>
public bool InvalidDoc(string docid, string userid, string operateip, string clientid)
{
return(CommonBusiness.Update("StorageDoc", "Status", (int)EnumDocStatus.Invalid, "DocID='" + docid + "' and status=" + (int)EnumDocStatus.Normal));
}
/// <summary>
/// 客户端账号是否存在
/// </summary>
/// <param name="loginName">账号</param>
/// <returns></returns>
public static bool IsExistLoginName(string loginName)
{
object count = CommonBusiness.Select("Users", "count(0)", "LoginName='" + loginName + "'");
return(Convert.ToInt32(count) > 0);
}
public bool UpdateProductDetailsStatus(string productdetailid, EnumStatus status, string operateIP, string operateID)
{
return(CommonBusiness.Update("ProductDetail", "Status", (int)status, " ProductDetailID='" + productdetailid + "'"));
}
public bool UpdateProductIsNew(string productid, bool isNew, string operateIP, string operateID)
{
return(CommonBusiness.Update("Products", "IsNew", isNew ? "1" : "0", " ProductID='" + productid + "'"));
}
/// <summary>
/// 编辑货位状态
/// </summary>
/// <param name="id"></param>
/// <param name="status"></param>
/// <param name="operateid"></param>
/// <param name="clientid"></param>
/// <returns></returns>
public bool UpdateDepotSeatStatus(string id, EnumStatus status, string operateid, string clientid)
{
return(CommonBusiness.Update("DepotSeat", "Status", (int)status, " DepotID='" + id + "'"));
}
/// <summary>
/// 编辑仓库状态
/// </summary>
/// <param name="id"></param>
/// <param name="status"></param>
/// <param name="operateid"></param>
/// <param name="clientid"></param>
/// <returns></returns>
public bool UpdateWareHouseStatus(string id, EnumStatus status, string operateid, string clientid)
{
return(CommonBusiness.Update("WareHouse", "Status", (int)status, " WareID='" + id + "'"));
}
public bool DeleteReply(string replyid)
{
bool bl = CommonBusiness.Update("CustomerReply", "Status", 9, "ReplyID='" + replyid + "'");
return(bl);
}
public bool DeleteContact(string contactid, string ip, string userid, string agentid)
{
bool bl = CommonBusiness.Update("Contact", "Status", 9, "ContactID='" + contactid + "'");
return(bl);
}
/// <summary>
/// 是否明道网络已注册
/// </summary>
/// <param name="projectid"></param>
/// <returns></returns>
public static bool IsExistsMDProject(string projectid)
{
var count = CommonBusiness.Select("Agents", "count(0)", "MDProjectID='" + projectid + "'");
return(Convert.ToInt32(count) > 0);
}
public bool IsExistProductCode(string code, string clientid)
{
object obj = CommonBusiness.Select("Products", " Count(0) ", "ClientID='" + clientid + "' and ProductCode='" + code + "'");
return(Convert.ToInt32(obj) > 0);
}
public bool UpdateProductStatus(string productid, EnumStatus status, string operateIP, string operateID)
{
return(CommonBusiness.Update("Products", "Status", ((int)status).ToString(), " ProductID='" + productid + "'"));
}
/// <summary>
/// 删除库别
/// </summary>
/// <param name="id">库别ID</param>
/// <param name="operateid">操作人</param>
/// <param name="clientid">客户端ID</param>
/// <returns></returns>
public bool DeleteWarehouseType(string id, string operateid, string clientid)
{
return(CommonBusiness.Update("WareHouseType", "Status", (int)CloudSalesEnum.EnumStatus.Delete, " TypeID='" + id + "'"));
}
public bool UpdateProductIsRecommend(string productid, bool isRecommend, string operateIP, string operateID)
{
return(CommonBusiness.Update("Products", "IsRecommend", isRecommend ? "1" : "0", " ProductID='" + productid + "'"));
}
/// <summary>
/// 编辑购物车产品数量
/// </summary>
/// <param name="autoid"></param>
/// <param name="quantity"></param>
/// <returns></returns>
public static bool UpdateCartQuantity(string autoid, int quantity, string userid, string clientid)
{
return(CommonBusiness.Update("ShoppingCart", "Quantity", quantity, "AutoID=" + autoid));
}
public bool UpdateProviderStatus(string providerid, EnumStatus status, string ip, string operateid)
{
return(CommonBusiness.Update("Providers", "Status", (int)status, "ProviderID='" + providerid + "'"));
}
/// <summary>
/// 删除购物车记录
/// </summary>
/// <param name="autoid"></param>
/// <param name="userid"></param>
/// <param name="clientid"></param>
/// <returns></returns>
public static bool DeleteCart(string autoid, string userid, string clientid)
{
return(CommonBusiness.Delete("ShoppingCart", "AutoID=" + autoid));
}