public List <NuomiServicesConfig> GetNuomiServicesConfig(string nuomiTitle, long nuomiId, string serviceId, int isValid, int pageIndex, int pageSize) { List <NuomiServicesConfig> result = new List <NuomiServicesConfig>(); try { dbScopeReadManager.Execute(conn => { result = DALNuomiService.SelectNuomiServicesConfig(conn, nuomiTitle, nuomiId, serviceId, isValid, pageIndex, pageSize); }); if (result != null && result.Any()) { var allShopServices = GetAllShopServices(); if (allShopServices != null && allShopServices.Any()) { result.ForEach(x => { x.ServiceName = allShopServices .Where(o => String.Equals(o.Key, x.ServiceId)) .Select(i => i.Value).FirstOrDefault(); }); } } } catch (Exception ex) { logger.Log(Level.Error, ex, "GetNuomiServicesConfig"); } return(result); }
public int AddNuomiServiceConfig(string nuomiTitle, long nuomiId, string serviceId, string userEmail, string remarks, string user) { var result = -1; try { dbScopeManager.Execute(conn => { if (DALNuomiService.SelectConfigByNuomiIdAndEmail(conn, nuomiId, userEmail) == null) { if (DALNuomiService.InsertNuomiServiceConfig(conn, nuomiTitle, nuomiId, serviceId, userEmail, remarks) > 0) { result = 1; } } else { result = 2; } }); } catch (Exception ex) { logger.Log(Level.Error, ex, "AddNuomiServiceConfig"); } var remark = $"NuomiTitle:{nuomiTitle},NuomiId:{nuomiId},ServiceId:{serviceId},UserEmail:{userEmail},Remarks:{remarks},Result:{result}"; InsertLog("AddNuomiServiceConfig", nuomiId.ToString(), remark, result == 1 ? "添加成功" : "添加失败", user, "NuomiServicesConfig", "", ""); return(result); }
public bool BatchSoleteConfig(string pkidStr, string user) { var result = false; try { result = dbScopeManager.Execute(conn => DALNuomiService.BatchSoleteConfig(conn, pkidStr)) > 0; } catch (Exception ex) { logger.Log(Level.Error, ex, "BatchSoleteConfig"); } if (result) { InsertLog("BatchSoleteConfig", "-1", $"PkidStr:{pkidStr}", "批量作废糯米团单配置", user, "NuomiServicesConfig", "", ""); } return(result); }
public bool BatchInsertNuomiConfig(List <NuomiServicesConfig> info, string user) { var result = false; try { dbScopeManager.Execute(conn => DALNuomiService.BatchInsertNuomiConfig(conn, info, Email)); result = true; } catch (Exception ex) { logger.Log(Level.Error, ex, "BatchInsertNuomiConfig"); } if (result) { InsertLog("BatchInsertNuomiConfig", "-1", JsonConvert.SerializeObject(info), "批量导入糯米团单配置", user, "NuomiServicesConfig", "", ""); } return(result); }
public bool EditNuomiServiceConfig(int pkid, string nuomiTitle, long nuomiId, string serviceId, string userEmail, string remarks, string user) { var result = false; try { dbScopeManager.Execute(conn => { result = DALNuomiService.UpdateNuomiServiceConfig(conn, pkid, nuomiTitle, serviceId, remarks) > 0; }); } catch (Exception ex) { logger.Log(Level.Error, ex, "EditNuomiServiceConfig"); } var remark = $"PKID:{pkid}NuomiTitle:{nuomiTitle},NuomiId:{nuomiId},ServiceId:{serviceId},UserEmail:{userEmail},Remarks:{remarks}"; InsertLog("EditNuomiServiceConfig", nuomiId.ToString(), remark, result ? "修改成功" : "修改失败", user, "NuomiServicesConfig", "", ""); return(result); }
public bool DelNuomiServiceConfig(int pkid, string user) { var result = false; NuomiServicesConfig data = null; try { dbScopeManager.Execute(conn => { data = DALNuomiService.SelectConfigByPKID(conn, pkid); if (data != null) { result = DALNuomiService.DelNuomiServiceConfig(conn, pkid) > 0; } }); } catch (Exception ex) { logger.Log(Level.Error, ex, "DelNuomiServiceConfig"); } InsertLog("DelNuomiServiceConfig", data != null ? data.NuomiId.ToString() : pkid.ToString(), JsonConvert.SerializeObject(data), result ? "删除成功" : "删除失败", user, "NuomiServicesConfig", "", ""); return(result); }
public Tuple <List <NuomiServicesConfig>, List <NuomiServicesConfig> > VerifyData(List <NuomiServicesConfig> data, IDictionary <string, string> allServices) { var success = new List <NuomiServicesConfig>(); var error = new List <NuomiServicesConfig>(); var flag = false; var msg = string.Empty; var serviceName = string.Empty; try { if (data != null && data.Any() && allServices != null && allServices.Any()) { data = data.GroupBy(_ => _.NuomiId).Select(x => x.FirstOrDefault()).ToList(); dbScopeManager.Execute(conn => { foreach (var item in data) { flag = false; msg = string.Empty; serviceName = string.Empty; flag = DALNuomiService.SelectConfigByNuomiId(conn, item.NuomiId) == null ? true : false; if (flag) { serviceName = allServices. Where(x => String.Equals(x.Key, item.ServiceId)) .Select(o => o.Value).FirstOrDefault(); if (!string.IsNullOrEmpty(serviceName)) { success.Add(new NuomiServicesConfig() { NuomiId = item.NuomiId, NuomiTitle = item.NuomiTitle, ServiceId = item.ServiceId, Email = item.Email, Remarks = item.Remarks }); } else { flag = false; msg = "服务Id无效"; } } else { flag = false; msg = "糯米Id已存在"; } if (!flag) { error.Add(new NuomiServicesConfig() { NuomiId = item.NuomiId, ServiceId = item.ServiceId, Remarks = msg }); } } }); } } catch (Exception ex) { logger.Log(Level.Error, ex, "VerifyData"); } return(Tuple.Create(success, error)); }