/// <summary>
/// 根据明道用户ID和网络ID获取云销用户信息（登录）
/// </summary>
/// <param name="mduserid"></param>
/// <param name="mdprojectid"></param>
/// <returns></returns>
public static Users GetUserByMDUserID(string mduserid, string mdprojectid, string operateip)
{
DataSet ds = new OrganizationDAL().GetUserByMDUserID(mduserid);
Users model = null;
if (ds.Tables.Contains("User") && ds.Tables["User"].Rows.Count > 0)
{
model = new Users();
model.FillData(ds.Tables["User"].Rows[0]);
model.Department = GetDepartmentByID(model.DepartID, model.AgentID);
model.Role = GetRoleByIDCache(model.RoleID, model.AgentID);
model.Menus = CommonBusiness.ClientMenus;
//处理缓存
if (!Users.ContainsKey(model.AgentID))
{
GetUsers(model.AgentID);
}
if (Users[model.AgentID].Where(u => u.MDUserID == mduserid).Count() == 0)
{
Users[model.AgentID].Add(model);
}
}
if (!string.IsNullOrEmpty(operateip))
{
//记录登录日志
LogBusiness.AddLoginLog(mduserid, model != null, CloudSalesEnum.EnumSystemType.Client, operateip);
}
return(model);
}
/// <summary>
/// 添加员工
/// </summary>
/// <param name="loginname">登录名</param>
/// <param name="loginpwd">密码</param>
/// <param name="name">姓名</param>
/// <param name="mobile">手机</param>
/// <param name="email">邮箱</param>
/// <param name="citycode">城市</param>
/// <param name="address">地址</param>
/// <param name="jobs">职位</param>
/// <param name="roleid">角色ID</param>
/// <param name="departid">部门ID</param>
/// <param name="parentid">上级ID</param>
/// <param name="agentid">代理商ID></param>
/// <param name="clientid">客户端ID</param>
/// <param name="mduserid">明道用户ID</param>
/// <param name="mdprojectid">明道网络ID</param>
/// <param name="isAppAdmin">是否应用管理员</param>
/// <param name="operateid">操作人</param>
/// <param name="result">返回结果 0 失败 1成功 2账号已存在 3人数达到限制</param>
/// <returns></returns>
public static Users CreateUser(string loginname, string loginpwd, string name, string mobile, string email, string citycode, string address, string jobs,
string roleid, string departid, string parentid, string agentid, string clientid, string mduserid, string mdprojectid, int isAppAdmin, string operateid, out int result)
{
string userid = Guid.NewGuid().ToString();
loginpwd = CloudSalesTool.Encrypt.GetEncryptPwd(loginpwd, loginname);
Users user = null;
DataTable dt = OrganizationDAL.BaseProvider.CreateUser(userid, loginname, loginpwd, name, mobile, email, citycode, address, jobs, roleid, departid, parentid, agentid, clientid, mduserid, mdprojectid, isAppAdmin, operateid, out result);
if (dt.Rows.Count > 0)
{
user = new Users();
user.FillData(dt.Rows[0]);
var cache = GetUsers(user.AgentID).Where(m => m.UserID == user.UserID).FirstOrDefault();
if (cache == null || string.IsNullOrEmpty(cache.UserID))
{
user.Role = GetRoleByID(user.RoleID, user.AgentID);
user.Department = GetDepartmentByID(user.DepartID, user.AgentID);
Users[user.AgentID].Add(user);
}
else
{
cache.Status = 1;
}
//日志
LogBusiness.AddActionLog(CloudSalesEnum.EnumSystemType.Client, CloudSalesEnum.EnumLogObjectType.User, EnumLogType.Create, "", operateid, agentid, clientid);
}
return(user);
}
/// <summary>
/// 新建活动
/// </summary>
/// <param name="name">活动名称</param>
/// <param name="poster">宣传海报</param>
/// <param name="begintime">开始时间</param>
/// <param name="endtime">结束时间</param>
/// <param name="address">地址</param>
/// <param name="ownerid">负责人（联系人）</param>
/// <param name="remark">描述</param>
/// <param name="userid">创建人</param>
/// <param name="agentid">代理商ID</param>
/// <param name="clientid">客户端ID</param>
/// <returns></returns>
public static string CreateActivity(string name, string poster, string begintime, string endtime, string address, string ownerid, string memberid, string remark, string userid, string agentid, string clientid)
{
string activityid = Guid.NewGuid().ToString();
if (!string.IsNullOrEmpty(poster))
{
if (poster.IndexOf("?") > 0)
{
poster = poster.Substring(0, poster.IndexOf("?"));
}
FileInfo file = new FileInfo(HttpContext.Current.Server.MapPath(poster));
poster = FilePath + file.Name;
if (file.Exists)
{
file.MoveTo(HttpContext.Current.Server.MapPath(poster));
}
}
bool bl = ActivityDAL.BaseProvider.CreateActivity(activityid, name, poster, begintime, endtime, address, ownerid, memberid, remark, userid, agentid, clientid);
if (!bl)
{
return("");
}
else
{
//日志
LogBusiness.AddActionLog(CloudSalesEnum.EnumSystemType.Client, CloudSalesEnum.EnumLogObjectType.Activity, EnumLogType.Create, "", userid, agentid, clientid);
}
return(activityid);
}
public bool UpdateUnit(string unitID, string unitName, string desciption, string operateID)
{
var dal = new ProductsDAL();
DataTable dt = dal.GetUnitByUnitID(unitID);
string message = "单位名称“" + dt.Rows[0]["unitName"].ToString() + "”变更为“" + unitName + "”；描述“" + dt.Rows[0]["Description"].ToString() + "”变更为“" + desciption + "”";
LogBusiness.AddOperateLog(operateID, "ProductsBusiness.UpdateUnit", EnumLogType.Update, EnumLogModules.Stock, EnumLogEntity.ProductUnit, unitID, message, "");
return(dal.UpdateUnit(unitID, unitName, desciption));
}
public bool ConfirmAgentOrderOut(string orderid, string wareid, int issend, string expressid, string expresscode, string userid, string agentid, string clientid, ref int result, ref string errinfo)
{
bool bl = AgentOrderDAL.BaseProvider.ConfirmAgentOrderOut(orderid, wareid, issend, expressid, expresscode, userid, agentid, clientid, ref result, ref errinfo);
if (bl)
{
LogBusiness.AddActionLog(CloudSalesEnum.EnumSystemType.Client, CloudSalesEnum.EnumLogObjectType.StockOut, EnumLogType.Create, "", userid, agentid, clientid);
}
return(bl);
}
public bool UpdateReturnQuantity(string orderid, string autoid, string name, int quantity, string operateid, string ip, string agentid, string clientid)
{
bool bl = OrdersDAL.BaseProvider.UpdateReturnQuantity(orderid, autoid, quantity, operateid, agentid, clientid);
if (bl)
{
string msg = "修改产品" + name + "退货数量：" + quantity;
LogBusiness.AddLog(orderid, EnumLogObjectType.Orders, msg, operateid, ip, autoid, agentid, clientid);
}
return(bl);
}
public bool EffectiveOrder(string orderid, string operateid, string ip, string agentid, string clientid, out int result)
{
bool bl = OrdersDAL.BaseProvider.EffectiveOrder(orderid, operateid, agentid, clientid, out result);
if (bl)
{
string msg = "审核订单";
LogBusiness.AddLog(orderid, EnumLogObjectType.Orders, msg, operateid, ip, "", agentid, clientid);
}
return(bl);
}
public bool EditOrder(string orderid, string personName, string mobileTele, string cityCode, string address, string postalcode, string typeid, int expresstype, string remark, string operateid, string ip, string agentid, string clientid)
{
bool bl = OrdersDAL.BaseProvider.EditOrder(orderid, personName, mobileTele, cityCode, address, postalcode, typeid, expresstype, remark, operateid, agentid, clientid);
if (bl)
{
string msg = "编辑收货信息";
LogBusiness.AddLog(orderid, EnumLogObjectType.Orders, msg, operateid, ip, operateid, agentid, clientid);
}
return(bl);
}
public bool DeleteOrder(string orderid, string operateid, string ip, string agentid, string clientid)
{
bool bl = OrdersDAL.BaseProvider.DeleteOrder(orderid, operateid, agentid, clientid);
if (bl)
{
string msg = "删除订单";
LogBusiness.AddLog(orderid, EnumLogObjectType.Orders, msg, operateid, ip, "", agentid, clientid);
}
return(bl);
}
public bool ApplyReturnProduct(string orderid, string operateid, string ip, string agentid, string clientid, out int result)
{
bool bl = OrdersDAL.BaseProvider.ApplyReturnProduct(orderid, operateid, agentid, clientid, out result);
if (bl)
{
string msg = "申请退货";
LogBusiness.AddLog(orderid, EnumLogObjectType.Orders, msg, operateid, ip, "", agentid, clientid);
}
return(bl);
}
/// <summary>
/// 出库按报损逻辑
/// </summary>
public bool SubmitHandOutDoc(string wareid, string remark, string userid, string operateip, string agentid, string clientid)
{
string guid = Guid.NewGuid().ToString();
bool bl = StockDAL.SubmitDamagedDoc(guid, (int)EnumDocType.SGCK, 0, remark, wareid, userid, operateip, clientid);
if (bl)
{
LogBusiness.AddActionLog(CloudSalesEnum.EnumSystemType.Client, CloudSalesEnum.EnumLogObjectType.StockOut, EnumLogType.Create, "", userid, agentid, clientid);
}
return(bl);
}
public bool UpdateCustomerMark(string customerid, int mark, string operateid, string ip, string agentid, string clientid)
{
bool bl = CommonBusiness.Update("Customer", "Mark", mark, "CustomerID='" + customerid + "'");
if (bl)
{
string msg = "标记客户颜色";
LogBusiness.AddLog(customerid, EnumLogObjectType.Customer, msg, operateid, ip, mark.ToString(), agentid, clientid);
}
return(bl);
}
public bool UpdateCustomer(string customerid, string name, int type, string industryid, int extent, string citycode, string address, string mobile, string officephone, string email, string jobs, string desc, string operateid, string ip, string agentid, string clientid)
{
bool bl = CustomDAL.BaseProvider.UpdateCustomer(customerid, name, type, industryid, extent, citycode, address, mobile, officephone, email, jobs, desc, operateid, agentid, clientid);
if (!bl)
{
string msg = "编辑客户信息";
LogBusiness.AddLog(customerid, EnumLogObjectType.Customer, msg, operateid, ip, "", agentid, clientid);
}
return(bl);
}
public bool UpdateOrderPrice(string orderid, string autoid, string name, decimal price, string operateid, string ip, string agentid, string clientid)
{
bool bl = OrdersDAL.BaseProvider.UpdateOrderPrice(orderid, autoid, price, operateid, agentid, clientid);
if (bl)
{
string msg = "修改产品" + name + "价格：" + price;
LogBusiness.AddLog(orderid, EnumLogObjectType.Orders, msg, operateid, ip, autoid, agentid, clientid);
}
return(bl);
}
public static bool CreateStorageDoc(string wareid, string providerid, string remark, string userid, string operateip, string agentid, string clientid)
{
string guid = Guid.NewGuid().ToString();
bool bl = StockDAL.AddStorageDoc(guid, (int)EnumDocType.RK, 0, providerid, remark, wareid, userid, operateip, clientid);
if (bl)
{
//日志
LogBusiness.AddActionLog(CloudSalesEnum.EnumSystemType.Client, CloudSalesEnum.EnumLogObjectType.StockIn, EnumLogType.Create, "", userid, agentid, clientid);
}
return(bl);
}
public bool UpdateCustomerStatus(string customerid, EnumCustomStatus status, string operateid, string ip, string agentid, string clientid)
{
bool bl = CommonBusiness.Update("Customer", "Status", (int)status, "CustomerID='" + customerid + "'");
if (bl)
{
var model = CommonBusiness.GetEnumDesc(status);
string msg = "客户状态更换为：" + model;
LogBusiness.AddLog(customerid, EnumLogObjectType.Customer, msg, operateid, ip, status.ToString(), agentid, clientid);
}
return(bl);
}
public bool UpdateCustomerOwner(string customerid, string userid, string operateid, string ip, string agentid, string clientid)
{
bool bl = CustomDAL.BaseProvider.UpdateCustomerOwner(customerid, userid, operateid, agentid, clientid);
if (bl)
{
var model = OrganizationBusiness.GetUserByUserID(userid, agentid);
string msg = "客户拥有者更换为：" + model.Name;
LogBusiness.AddLog(customerid, EnumLogObjectType.Customer, msg, operateid, ip, userid, agentid, clientid);
}
return(bl);
}
public bool UpdateCustomerStage(string customerid, string stageid, string operateid, string ip, string agentid, string clientid)
{
bool bl = CustomDAL.BaseProvider.UpdateCustomerStage(customerid, stageid, operateid, agentid, clientid);
if (bl)
{
var model = SystemBusiness.BaseBusiness.GetCustomStageByID(stageid, agentid, clientid);
string msg = "客户阶段更换为：" + model.StageName;
LogBusiness.AddLog(customerid, EnumLogObjectType.Customer, msg, operateid, ip, stageid, agentid, clientid);
}
return(bl);
}
public bool UpdateBrandStatus(string brandID, EnumStatus status, string operateIP, string operateID)
{
bool bl = CommonBusiness.Update("Brand", "Status", ((int)status).ToString(), " BrandID='" + brandID + "'");
if (bl)
{
string message = "编辑品牌状态为：" + CommonBusiness.GetEnumDesc(status);
LogBusiness.AddOperateLog(operateID, "ProductsBusiness.UpdateBrandStatus", EnumLogType.Update, EnumLogModules.Stock, EnumLogEntity.Brand, brandID, message, operateIP);
}
return(bl);
}
public bool UpdateOpportunityStage(string opportunityid, string stageid, string operateid, string ip, string agentid, string clientid)
{
bool bl = OrdersDAL.BaseProvider.UpdateOpportunityStage(opportunityid, stageid, operateid, agentid, clientid);
if (bl)
{
var model = SystemBusiness.BaseBusiness.GetOpportunityStageByID(stageid, agentid, clientid);
string msg = "机会阶段更换为：" + model.StageName;
LogBusiness.AddLog(opportunityid, EnumLogObjectType.Orders, msg, operateid, ip, stageid, agentid, clientid);
}
return(bl);
}
public bool SubmitOrder(string orderid, string operateid, string ip, string agentid, string clientid)
{
bool bl = OrdersDAL.BaseProvider.SubmitOrder(orderid, operateid, agentid, clientid);
if (bl)
{
string msg = "提交订单";
LogBusiness.AddLog(orderid, EnumLogObjectType.Orders, msg, operateid, ip, operateid, agentid, clientid);
//日志
LogBusiness.AddActionLog(CloudSalesEnum.EnumSystemType.Client, CloudSalesEnum.EnumLogObjectType.Orders, EnumLogType.Create, ip, operateid, agentid, clientid);
}
return(bl);
}
/// <summary>
/// 根据账号密码获取信息（登录）
/// </summary>
/// <param name="loginname">账号</param>
/// <param name="pwd">密码</param>
/// <returns></returns>
public static M_Users GetM_UserByUserName(string loginname, string pwd, string operateip)
{
pwd = CloudSalesTool.Encrypt.GetEncryptPwd(pwd);
DataTable dt = new M_UsersDAL().GetM_UserByUserName(loginname, pwd);
M_Users model = null;
if (dt.Rows.Count > 0)
{
model = new M_Users();
model.FillData(dt.Rows[0]);
}
//记录登录日志
LogBusiness.AddLoginLog(loginname, model != null, CloudSalesEnum.EnumSystemType.Manage, operateip);
return(model);
}
public string CreateCustomer(string name, int type, string sourceid, string activityid, string industryid, int extent, string citycode, string address,
string contactname, string mobile, string officephone, string email, string jobs, string desc, string ownerid, string operateid, string agentid, string clientid)
{
string id = Guid.NewGuid().ToString();
bool bl = CustomDAL.BaseProvider.CreateCustomer(id, name, type, sourceid, activityid, industryid, extent, citycode, address, contactname, mobile, officephone, email, jobs, desc, ownerid, operateid, agentid, clientid);
if (!bl)
{
id = "";
}
else
{
//日志
LogBusiness.AddActionLog(CloudSalesEnum.EnumSystemType.Client, CloudSalesEnum.EnumLogObjectType.Customer, EnumLogType.Create, "", operateid, agentid, clientid);
}
return(id);
}
/// <summary>
/// 根据用户名密码获取会员信息（登录）
/// </summary>
/// <param name="loginname">用户名</param>
/// <param name="pwd">密码</param>
/// <returns></returns>
public static Users GetUserByUserName(string loginname, string pwd, string operateip)
{
pwd = CloudSalesTool.Encrypt.GetEncryptPwd(pwd, loginname);
DataSet ds = new OrganizationDAL().GetUserByUserName(loginname, pwd);
Users model = null;
if (ds.Tables.Contains("User") && ds.Tables["User"].Rows.Count > 0)
{
model = new Users();
model.FillData(ds.Tables["User"].Rows[0]);
if (CommonCache.ClientMenus.ContainsKey(model.ClientID))
{
model.Menus = CommonCache.ClientMenus[model.ClientID];
}
else if (ds.Tables.Contains("Modules"))
{
List <Menu> list = new List <Menu>();
var modules = CommonCache.Modules;
foreach (DataRow dr in ds.Tables["Modules"].Rows)
{
Modules module = new Modules();
module.FillData(dr);
if (modules.ContainsKey(module.ModulesID))
{
foreach (var item in modules[module.ModulesID])
{
if (list.Where(m => m.MenuCode == item.MenuCode).Count() == 0)
{
list.Add(item);
}
}
}
}
list = list.OrderBy(m => m.Sort).ToList();
CommonCache.ClientMenus.Add(model.ClientID, list);
model.Menus = list;
}
}
//记录登录日志
LogBusiness.AddLoginLog(loginname, model != null, CloudSalesEnum.EnumSystemType.Client, operateip);
return(model);
}
public string CreateOrder(string customerid, string operateid, string agentid, string clientid)
{
string id = Guid.NewGuid().ToString();
string code = DateTime.Now.ToString("yyyyMMddHHmmssfff");
bool bl = OrdersDAL.BaseProvider.CreateOrder(id, code, customerid, operateid, agentid, clientid);
if (!bl)
{
return("");
}
else
{
//日志
LogBusiness.AddActionLog(CloudSalesEnum.EnumSystemType.Client, CloudSalesEnum.EnumLogObjectType.Opportunity, EnumLogType.Create, "", operateid, agentid, clientid);
}
return(id);
}
/// <summary>
/// 根据用户名密码获取会员信息（登录）
/// </summary>
/// <param name="loginname">用户名</param>
/// <param name="pwd">密码</param>
/// <returns></returns>
public static Users GetUserByUserName(string loginname, string pwd, string operateip)
{
pwd = CloudSalesTool.Encrypt.GetEncryptPwd(pwd);
DataSet ds = new OrganizationDAL().GetUserByUserName(loginname, pwd);
Users model = null;
if (ds.Tables.Contains("User") && ds.Tables["User"].Rows.Count > 0)
{
model = new Users();
model.FillData(ds.Tables["User"].Rows[0]);
model.Department = GetDepartmentByID(model.DepartID, model.AgentID);
model.Role = GetRoleByIDCache(model.RoleID, model.AgentID);
model.Menus = CommonBusiness.ClientMenus;
}
//记录登录日志
LogBusiness.AddLoginLog(loginname, model != null, CloudSalesEnum.EnumSystemType.Client, operateip);
return(model);
}
public string AddProduct(string productCode, string productName, string generalName, bool iscombineproduct, string brandid, string bigunitid, string smallunitid, int bigSmallMultiple,
string categoryid, int status, string attrlist, string valuelist, string attrvaluelist, decimal commonprice, decimal price, decimal weight, bool isnew,
bool isRecommend, int isallow, int isautosend, int effectiveDays, decimal discountValue, string productImg, string shapeCode, string description, List <ProductDetail> details, string operateid, string agentid, string clientid)
{
lock (SingleLock)
{
if (!string.IsNullOrEmpty(productImg))
{
if (productImg.IndexOf("?") > 0)
{
productImg = productImg.Substring(0, productImg.IndexOf("?"));
}
FileInfo file = new FileInfo(HttpContext.Current.Server.MapPath(productImg));
productImg = FILEPATH + file.Name;
if (file.Exists)
{
file.MoveTo(HttpContext.Current.Server.MapPath(productImg));
}
}
var dal = new ProductsDAL();
string pid = dal.AddProduct(productCode, productName, generalName, iscombineproduct, brandid, bigunitid, smallunitid, bigSmallMultiple, categoryid, status, attrlist,
valuelist, attrvaluelist, commonprice, price, weight, isnew, isRecommend, isallow, isautosend, effectiveDays, discountValue, productImg, shapeCode, description, operateid, clientid);
//产品添加成功添加子产品
if (!string.IsNullOrEmpty(pid))
{
//日志
LogBusiness.AddActionLog(CloudSalesEnum.EnumSystemType.Client, CloudSalesEnum.EnumLogObjectType.Product, EnumLogType.Create, "", operateid, agentid, clientid);
foreach (var model in details)
{
model.ImgS = "";
dal.AddProductDetails(pid, model.DetailsCode, model.ShapeCode, model.SaleAttr, model.AttrValue, model.SaleAttrValue, model.Price, model.Weight, model.BigPrice, model.ImgS, model.Description, operateid, clientid);
}
}
return(pid);
}
}
/// <summary>
/// 根据明道用户ID和网络ID获取云销用户信息（登录）
/// </summary>
/// <param name="mduserid"></param>
/// <param name="mdprojectid"></param>
/// <returns></returns>
public static Users GetUserByMDUserID(string mduserid, string mdprojectid, string operateip)
{
DataSet ds = new OrganizationDAL().GetUserByMDUserID(mduserid, mdprojectid);
Users model = null;
if (ds.Tables.Contains("User") && ds.Tables["User"].Rows.Count > 0)
{
model = new Users();
model.FillData(ds.Tables["User"].Rows[0]);
model.LogGUID = Guid.NewGuid().ToString();
model.Department = GetDepartmentByID(model.DepartID, model.AgentID);
model.Role = GetRoleByIDCache(model.RoleID, model.AgentID);
model.Client = Manage.ClientBusiness.GetClientDetail(model.ClientID);
//处理缓存
if (!Users.ContainsKey(model.AgentID))
{
GetUsers(model.AgentID);
}
if (Users[model.AgentID].Where(u => u.UserID == model.UserID).Count() == 0)
{
Users[model.AgentID].Add(model);
}
else
{
var user = Users[model.AgentID].Where(u => u.UserID == model.UserID).FirstOrDefault();
user.LogGUID = model.LogGUID;
}
//权限
if (model.Role.IsDefault == 1)
{
model.Menus = CommonBusiness.ClientMenus;
}
else
{
model.Menus = new List <Menu>();
foreach (DataRow dr in ds.Tables["Permission"].Rows)
{
Menu menu = new Menu();
menu.FillData(dr);
model.Menus.Add(menu);
}
}
}
if (string.IsNullOrEmpty(operateip))
{
operateip = "";
}
//记录登录日志
if (model != null)
{
LogBusiness.AddLoginLog(mduserid, true, Manage.ClientBusiness.GetClientDetail(model.ClientID).AgentID == model.AgentID ? CloudSalesEnum.EnumSystemType.Client : CloudSalesEnum.EnumSystemType.Agent, operateip, model.UserID, model.AgentID, model.ClientID);
}
else
{
LogBusiness.AddLoginLog(mduserid, false, CloudSalesEnum.EnumSystemType.Client, operateip, "", "", "");
}
return(model);
}
