public EnumResultStatus UpdateDepartmentStatus(string departid, EnumStatus status, string operateid, string operateip, string clientid) { if (status == EnumStatus.Delete) { object count = CommonBusiness.Select("Users", "count(0)", "DepartID='" + departid + "' and Status=1"); if (Convert.ToInt32(count) > 0) { return(EnumResultStatus.Exists); } } if (CommonBusiness.Update("Department", "Status", (int)status, "DepartID='" + departid + "'")) { var model = GetDepartments(clientid).Where(d => d.DepartID == departid).FirstOrDefault(); model.Status = (int)status; return(EnumResultStatus.Success); } else { return(EnumResultStatus.Failed); } }
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"; if (!string.IsNullOrEmpty(keyWords)) { where += " and (Name like '%" + keyWords + "%' or Contact like '%" + keyWords + "%' or MobileTele like '%" + keyWords + "%')"; } 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 static StorageDoc GetStorageDetail(string docid, string clientid) { DataSet ds = StockDAL.GetStorageDetail(docid, clientid); StorageDoc model = new StorageDoc(); if (ds.Tables.Contains("Doc") && ds.Tables["Doc"].Rows.Count > 0) { model.FillData(ds.Tables["Doc"].Rows[0]); model.CreateUser = OrganizationBusiness.GetUserByUserID(model.CreateUserID, clientid); model.StatusStr = GetDocStatusStr(model.DocType, model.Status); model.DocTypeStr = CommonBusiness.GetEnumDesc <EnumDocType>((EnumDocType)model.DocType); if (!string.IsNullOrEmpty(model.ExpressID)) { model.Express = ExpressCompanyBusiness.GetExpressCompanyDetail(model.ExpressID); } model.WareHouse = SystemBusiness.BaseBusiness.GetWareByID(model.WareID, model.ClientID); model.Details = new List <StorageDetail>(); foreach (DataRow item in ds.Tables["Details"].Rows) { StorageDetail details = new StorageDetail(); details.FillData(item); if (!string.IsNullOrEmpty(details.UnitID)) { details.UnitName = new ProductsBusiness().GetUnitByID(details.UnitID).UnitName; } if (!string.IsNullOrEmpty(details.ProviderID)) { details.Providers = new ProvidersBusiness().GetProviderByID(details.ProviderID); } model.Details.Add(details); } } return(model); }
public static bool DeleteReply(EnumLogObjectType type, string replyid) { string tablename = ""; switch (type) { case EnumLogObjectType.Customer: tablename = "CustomerReply"; break; case EnumLogObjectType.OrderTask: tablename = "TaskReply"; break; case EnumLogObjectType.Orders: tablename = "OrderReply"; break; } bool bl = CommonBusiness.Update(tablename, "Status", 9, "ReplyID='" + replyid + "'"); return(bl); }
public static List <Users> GetUsers(string keyWords, string departID, string roleID, string clientid, int pageSize, int pageIndex, ref int totalCount, ref int pageCount) { string whereSql = "ClientID='" + clientid + "' 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 = GetUserCacheByUserID(model.CreateUserID, model.ClientID); model.Department = GetDepartmentByID(model.DepartID, model.ClientID); model.Role = GetRoleByIDCache(model.RoleID, model.ClientID); list.Add(model); } return(list); }
public bool DeleteContact(string contactid, string ip, string userid) { bool bl = CommonBusiness.Update("Contact", "Status", 9, "ContactID='" + contactid + "'"); return(bl); }
public Task <bool> SendWeiXinMPPush(WeiXinMPPushType pushType, string guid, string operateName = "") { string result = string.Empty; if (pushType == WeiXinMPPushType.SendTaskFinishPush) { TaskEntity task = TaskBusiness.GetPushTaskForFinishTask(guid); if (!string.IsNullOrEmpty(task.OpenID)) { string content = GetPushContent(pushType, task.OpenID, task.Title, task.GoodsName, task.OrderType, task.PreTitle, task.Owner.Name, null, task.TaskID, operateName); result = SendPush(content); ApiCloudPush.BasePush.SendPush("您的" + task.Title + "上级任务:" + task.PreTitle + "标记完成", task.OwnerID); } if (task.Order != null) { var order = task.Order; if (!string.IsNullOrEmpty(order.OpenID)) { pushType = WeiXinMPPushType.SendAllTaskFinishPush; string content = GetPushContent(pushType, order.OpenID, order.OrderCode, task.GoodsName, task.OrderType, string.Empty, CommonBusiness.GetEnumDesc((EnumOrderStageStatus)order.Status)); result = SendPush(content); } ApiCloudPush.BasePush.SendPush("您的" + task.GoodsName + "所有任务已完成", order.OwnerID); } } else if (pushType == WeiXinMPPushType.SendNewTaskPush) { List <TaskEntity> tasks = TaskBusiness.GetPushTasksForNewOrder(guid); if (tasks.Count > 0) { foreach (var task in tasks) { if (!string.IsNullOrEmpty(task.OpenID)) { string content = GetPushContent(pushType, task.OpenID, task.Title, task.GoodsName, task.OrderType, "", "", task.EndTime, task.TaskID); result = SendPush(content); } ApiCloudPush.BasePush.SendPush("您收到了一个新任务:" + task.Title, task.OwnerID); } } } else if (pushType == WeiXinMPPushType.SendChangeOrderOwnerPush) { TaskEntity task = TaskBusiness.GetPushTaskForChangeOrderOwner(guid); if (task != null) { if (!string.IsNullOrEmpty(task.OpenID)) { string content = GetPushContent(pushType, task.OpenID, task.Title, task.GoodsName, task.OrderType, "", "", task.EndTime, "", operateName); result = SendPush(content); } ApiCloudPush.BasePush.SendPush(operateName + "将您设为订单:" + task.GoodsName + "的负责人!", task.OwnerID); } } else if (pushType == WeiXinMPPushType.SendChangeTaskOwnerPush) { TaskEntity task = TaskBusiness.GetPushTaskForChangeTaskOwner(guid); if (task != null) { if (!string.IsNullOrEmpty(task.OpenID)) { string content = GetPushContent(pushType, task.OpenID, task.Title, task.GoodsName, task.OrderType, "", "", task.EndTime, guid, operateName); result = SendPush(content); } ApiCloudPush.BasePush.SendPush(operateName + "将您设为任务:" + task.Title + "的负责人!", task.OwnerID); } } return(Task.Run(() => { return !string.IsNullOrEmpty(result); })); }
public bool UpdateProductDetailsStatus(string productdetailid, EnumStatus status, string operateIP, string operateID) { return(CommonBusiness.Update("ProductDetail", "Status", (int)status, " ProductDetailID='" + productdetailid + "'")); }
public bool UpdateProductStatus(string productid, EnumStatus status, string operateIP, string operateID) { return(CommonBusiness.Update("Products", "Status", ((int)status).ToString(), " ProductID='" + productid + "'")); }
public Products GetProductByIDForDetails(string productid, string clientid) { var dal = new ProductsDAL(); DataSet ds = dal.GetProductByIDForDetails(productid, clientid); Products model = new Products(); if (ds.Tables.Contains("Product") && ds.Tables["Product"].Rows.Count > 0) { model.FillData(ds.Tables["Product"].Rows[0]); model.SmallUnit = GetUnitByID(model.UnitID); model.AttrLists = new List <ProductAttr>(); model.SaleAttrs = new List <ProductAttr>(); model.Providers = new ProvidersEntity(); if (!string.IsNullOrEmpty(model.ProviderID)) { model.Providers.FillData(ds.Tables["Providers"].Rows[0]); if (!string.IsNullOrEmpty(model.Providers.CityCode)) { var city = CommonBusiness.GetCityByCode(model.Providers.CityCode); model.Providers.Address = city.Description + model.Providers.Address; } } if (!string.IsNullOrEmpty(model.CategoryID)) { var category = GetCategoryByID(model.CategoryID); foreach (var attr in category.AttrLists) { ProductAttr attrModel = new ProductAttr(); attrModel.AttrName = attr.AttrName; attrModel.AttrValues = new List <AttrValue>(); foreach (var value in attr.AttrValues) { if (model.AttrValueList.IndexOf(value.ValueID) >= 0) { attrModel.AttrValues.Add(value); model.AttrLists.Add(attrModel); break; } } } model.SaleAttrs = category.SaleAttrs; } model.ProductDetails = new List <ProductDetail>(); foreach (DataRow item in ds.Tables["Details"].Rows) { ProductDetail detail = new ProductDetail(); detail.FillData(item); detail.DetailStocks = new List <ProductStock>(); foreach (var stocktr in ds.Tables["Stocks"].Select("ProductDetailID='" + detail.ProductDetailID + "'")) { ProductStock stock = new ProductStock(); stock.FillData(stocktr); detail.DetailStocks.Add(stock); } model.ProductDetails.Add(detail); } } return(model); }
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 static bool UpdateCartBatch(string autoid, string batch, string userid) { return(CommonBusiness.Update("ShoppingCart", "BatchCode", batch, "AutoID=" + autoid)); }
public bool UpdateProviderStatus(string providerid, EnumStatus status, string ip, string operateid) { return(CommonBusiness.Update("Providers", "Status", (int)status, "ProviderID='" + providerid + "'")); }