public static void Init()
{
string sql = "select a.*,b.dictkey as PDictKey from Dict_System a left join Dict_System b on a.pid=b.id";
var dbContext = DbContextFactory.CreateByModelNamespace(typeof(Dict_System).Namespace);
listDictSystem = dbContext.Database.SqlQuery <DictSystemModel>(sql).ToList();
}
// GET: UserManage
public ActionResult Index(string usertype = "1", string producttype = "0", string userlvl = "0")
{
ViewData["usertype"] = usertype;
GetProductTypes(producttype);
GetUserLvls(userlvl);
SqlParameter[] parameters = new SqlParameter[0];
string sql = "select * from Base_UserInfo where [State]=0 ";
sql = sql + " and UserType=@userType";
Array.Resize(ref parameters, parameters.Length + 1);
parameters[parameters.Length - 1] = new SqlParameter("@userType", usertype);
if (producttype != "0")
{
sql = sql + " and ProductType=@producttype";
Array.Resize(ref parameters, parameters.Length + 1);
parameters[parameters.Length - 1] = new SqlParameter("@producttype", producttype);
}
if (userlvl != "0")
{
sql = sql + " and UserLvl=@userlvl";
Array.Resize(ref parameters, parameters.Length + 1);
parameters[parameters.Length - 1] = new SqlParameter("@userlvl", userlvl);
}
var dbContext = DbContextFactory.CreateByModelNamespace(typeof(Base_UserInfo).Namespace);
var base_UserInfoList = dbContext.Database.SqlQuery <Base_UserInfo>(sql, parameters).ToList();
return(View(base_UserInfoList));
}
public object GetUserGroupList(Dictionary <string, object> dicParas)
{
try
{
string errMsg = string.Empty;
string logId = string.Empty;
int userId = (dicParas.ContainsKey("userId") && Utils.isNumber(dicParas["userId"])) ? Convert.ToInt32(dicParas["userId"]) : 0;
XCCloudUserTokenModel userTokenKeyModel = (XCCloudUserTokenModel)dicParas[Constant.XCCloudUserTokenModel];
if (userTokenKeyModel.LogType == (int)RoleType.MerchUser)
{
logId = userTokenKeyModel.DataModel.MerchID;
}
//EF左关联
var dbContext = DbContextFactory.CreateByModelNamespace(typeof(Base_UserGroup).Namespace);
var base_UserGroup = (from a in dbContext.Set <Base_UserGroup>()
join b in dbContext.Set <Base_UserInfo>().Where(p => p.UserID == userId) on a.ID equals b.UserGroupID into t
from b in t.DefaultIfEmpty()
where a.MerchID.Equals(logId, StringComparison.OrdinalIgnoreCase)
select new UserGroupModel
{
ID = a.ID,
GroupName = a.GroupName,
Note = a.Note,
UserState = (b.UserID > 0 ? 1 : 0)
}).ToList();
return(ResponseModelFactory.CreateSuccessModel(isSignKeyReturn, base_UserGroup));
}
catch (Exception e)
{
return(ResponseModelFactory.CreateReturnModel(isSignKeyReturn, Return_Code.F, e.Message));
}
}
// GET: BidManage
public ActionResult Index(string begin_time, string end_time, string producttype = "0")
{
if (string.IsNullOrEmpty(begin_time))
{
begin_time = DateTime.Now.AddDays(-3).ToString("yyyy-MM-dd");
}
if (string.IsNullOrEmpty(end_time))
{
end_time = DateTime.Now.ToString("yyyy-MM-dd");
}
ViewData["SelectedProductType"] = producttype;
GetProductTypes(producttype);
ViewData["begin_time"] = begin_time;
ViewData["end_time"] = end_time;
begin_time = begin_time + " 00:00:00";
end_time = end_time + " 23:59:59";
SqlParameter[] parameters = new SqlParameter[2];
parameters[0] = new SqlParameter("@begin_time", begin_time);
parameters[1] = new SqlParameter("@end_time", end_time);
string sql = "select * from Data_BidManage where BidDate > convert(datetime, @begin_time, 120) and BidDate < convert(datetime, @end_time, 120)";
if (producttype != "0")
{
sql = sql + " and ProductType=@producttype";
Array.Resize(ref parameters, parameters.Length + 1);
parameters[parameters.Length - 1] = new SqlParameter("@producttype", producttype);
}
var dbContext = DbContextFactory.CreateByModelNamespace(typeof(Data_BidManage).Namespace);
var bidManageList = dbContext.Database.SqlQuery <Data_BidManage>(sql, parameters).ToList();
return(View(bidManageList));
}
public string getMenu(int userId, string superName, int userType, string menuText, out int menuId)
{
menuId = 0;
SqlParameter[] parameters = new SqlParameter[3];
parameters[0] = new SqlParameter("@UserID", userId);
parameters[1] = new SqlParameter("@SuperName", superName);
parameters[2] = new SqlParameter("@UserType", userType);
string sql = "exec GetMenus @UserID,@SuperName,@UserType";
var dbContext = DbContextFactory.CreateByModelNamespace(typeof(Base_UserInfo).Namespace);
var menuList = dbContext.Database.SqlQuery <DictFunctionsModel>(sql, parameters).ToList();
if (menuList == null)
{
return("");
}
//用于获取主界面菜单ID
var menu = menuList.Where(p => p.FunctionName.Equals(menuText, StringComparison.OrdinalIgnoreCase)).FirstOrDefault() ?? new DictFunctionsModel();
menuId = menu.ID;
JavaScriptSerializer jss = new JavaScriptSerializer();
var js = jss.Serialize(menuList);
return(js);
}
public string SaveParameters(string json)
{
//开启EF事务
using (TransactionScope ts = new TransactionScope())
{
try
{
//var dictParams = new Dictionary<string, object>((IDictionary<string, object>)Utils.DeserializeObject(json), StringComparer.OrdinalIgnoreCase);
var dictParams = (Dictionary <string, object>)Utils.DeserializeObject(json);
var dbContext = DbContextFactory.CreateByModelNamespace(typeof(Data_Parameters).Namespace);
foreach (var item in dictParams)
{
var data_Parameter = dbContext.Set <Data_Parameters>().Where(p => p.ControlID.Equals(item.Key, StringComparison.OrdinalIgnoreCase)).FirstOrDefault();
data_Parameter.ParameterValue = item.Value.ToString();
dbContext.Entry(data_Parameter).State = System.Data.Entity.EntityState.Modified;
}
if (dbContext.SaveChanges() < 0)
{
return("保存失败");
}
ts.Complete();
}
catch (Exception ex)
{
return(ex.Message);
}
}
//更新缓存
DataParameterBusiness.Init();
return("保存成功");
}
// GET: NoticeManage
public ActionResult Index(string begin_time, string end_time, string noticetype = "0")
{
if (string.IsNullOrEmpty(begin_time))
{
begin_time = DateTime.Now.ToString("yyyy-MM-dd");
}
if (string.IsNullOrEmpty(end_time))
{
end_time = DateTime.Now.ToString("yyyy-MM-dd");
}
GetNoticeTypes(noticetype);
ViewData["begin_time"] = begin_time;
ViewData["end_time"] = end_time;
begin_time = begin_time + " 00:00:00";
end_time = end_time + " 23:59:59";
SqlParameter[] parameters = new SqlParameter[2];
parameters[0] = new SqlParameter("@begin_time", begin_time);
parameters[1] = new SqlParameter("@end_time", end_time);
string sql = "select * from Flw_BiddingNotice where PublishTime > convert(datetime, @begin_time, 120) and PublishTime < convert(datetime, @end_time, 120)";
if (noticetype != "0")
{
sql = sql + " and NoticeType=@noticetype";
Array.Resize(ref parameters, parameters.Length + 1);
parameters[parameters.Length - 1] = new SqlParameter("@noticetype", noticetype);
}
var dbContext = DbContextFactory.CreateByModelNamespace(typeof(Flw_BiddingNotice).Namespace);
var biddingNoticeList = dbContext.Database.SqlQuery <Flw_BiddingNotice>(sql, parameters).ToList();
return(View(biddingNoticeList));
}
// GET: SmsManage
public ActionResult Index(string begin_time, string end_time)
{
if (string.IsNullOrEmpty(begin_time))
{
begin_time = DateTime.Now.ToString("yyyy-MM-dd");
}
if (string.IsNullOrEmpty(end_time))
{
end_time = DateTime.Now.ToString("yyyy-MM-dd");
}
ViewData["begin_time"] = begin_time;
ViewData["end_time"] = end_time;
begin_time = begin_time + " 00:00:00";
end_time = end_time + " 23:59:59";
SqlParameter[] parameters = new SqlParameter[2];
parameters[0] = new SqlParameter("@begin_time", begin_time);
parameters[1] = new SqlParameter("@end_time", end_time);
string sql = "select * from Data_SmsManage where CreateTime > convert(datetime, @begin_time, 120) and CreateTime < convert(datetime, @end_time, 120)";
var dbContext = DbContextFactory.CreateByModelNamespace(typeof(Data_SmsManage).Namespace);
var dataSmsMangeList = dbContext.Database.SqlQuery <Data_SmsManage>(sql, parameters).ToList();
return(View(dataSmsMangeList));
}
public static void Init()
{
string sql = "select ID, ProductName from Base_ProductInfo";
var dbContext = DbContextFactory.CreateByModelNamespace(typeof(Base_ProductInfo).Namespace);
listProductInfo = dbContext.Database.SqlQuery <Base_ProductInfo>(sql).ToList();
}
public ActionResult CreateProduct(string productName)
{
string errMsg = "添加成功";
if (string.IsNullOrEmpty(productName))
{
errMsg = "产品名称不能为空";
return(RedirectToAction("Index", "ProductInfoManage", new { errMsg = errMsg }));
}
//开启EF事务
using (TransactionScope ts = new TransactionScope())
{
try
{
IBase_ProductInfoService base_ProductInfoService = BLLContainer.Resolve <IBase_ProductInfoService>();
if (base_ProductInfoService.GetCount(p => p.ProductName.Equals(productName, StringComparison.OrdinalIgnoreCase)) > 0)
{
errMsg = "该产品名称已存在";
return(RedirectToAction("Index", "ProductInfoManage", new { errMsg = errMsg }));
}
var base_ProductInfo = new Base_ProductInfo();
base_ProductInfo.ProductName = productName;
if (!base_ProductInfoService.Add(base_ProductInfo))
{
errMsg = "数据库更新失败";
return(RedirectToAction("Index", "ProductInfoManage", new { errMsg = errMsg }));
}
var dbContext = DbContextFactory.CreateByModelNamespace(typeof(Base_ProductInfo).Namespace);
var userLvls = DictSystemBusiness.GetDicts("客户等级");
foreach (var model in userLvls)
{
var base_ProductInfo_Detail = new Base_ProductInfo_Detail();
base_ProductInfo_Detail.UserLvl = Convert.ToInt32(model.DictValue);
base_ProductInfo_Detail.ProductType = base_ProductInfo.ID;
dbContext.Entry(base_ProductInfo_Detail).State = EntityState.Added;
}
if (dbContext.SaveChanges() < 0)
{
errMsg = "数据库更新失败";
return(RedirectToAction("Index", "ProductInfoManage", new { errMsg = errMsg }));
}
ts.Complete();
}
catch (Exception ex)
{
return(RedirectToAction("Index", "ProductInfoManage", new { errMsg = ex.Message }));
}
}
//更新缓存
ProductTypeBusiness.Init();
return(RedirectToAction("Index", "ProductInfoManage", new { errMsg = errMsg }));
}
public object GetBindDeviceList(Dictionary <string, object> dicParas)
{
try
{
XCCloudUserTokenModel userTokenKeyModel = (XCCloudUserTokenModel)dicParas[Constant.XCCloudUserTokenModel];
string storeId = (userTokenKeyModel.DataModel as UserDataModel).StoreID;
string errMsg = string.Empty;
string type = dicParas.ContainsKey("type") ? (dicParas["type"] + "") : string.Empty;
string mcuId = dicParas.ContainsKey("mcuId") ? (dicParas["mcuId"] + "") : string.Empty;
var bindDeviceIDs = dicParas.ContainsKey("bindDeviceIDs") ? ((object[])dicParas["bindDeviceIDs"]).Cast <int>() : null;
if (!string.IsNullOrEmpty(type) && !Utils.isNumber(type))
{
errMsg = "设备类型格式不正确";
return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg));
}
var dbContext = DbContextFactory.CreateByModelNamespace(typeof(Base_UserInfo).Namespace);
var data_Project_Device = from a in dbContext.Set <Data_Project_Device>()
join b in dbContext.Set <Data_ProjectInfo>() on a.ProjectID equals b.ID
where b.ProjectStatus == 1
select a.DeviceID;
var base_DeviceInfo = dbContext.Set <Base_DeviceInfo>().Where(p => p.DeviceStatus == (int)DeviceStatus.Normal && p.StoreID.Equals(storeId, StringComparison.OrdinalIgnoreCase) && !data_Project_Device.Contains(p.ID));
if (!string.IsNullOrEmpty(type))
{
int iType = Convert.ToInt32(type);
base_DeviceInfo = base_DeviceInfo.Where(w => w.type == iType);
}
if (!string.IsNullOrEmpty(mcuId))
{
base_DeviceInfo = base_DeviceInfo.Where(w => w.MCUID.Contains(mcuId));
}
if (bindDeviceIDs != null)
{
base_DeviceInfo = base_DeviceInfo.Where(w => !bindDeviceIDs.Contains(w.ID));
}
int DeviceTypeId = dbContext.Set <Dict_System>().Where(p => p.DictKey.Equals("设备类型")).FirstOrDefault().ID;
var linq = from a in base_DeviceInfo
join b in dbContext.Set <Dict_System>().Where(p => p.PID == DeviceTypeId) on(a.type + "") equals b.DictValue into b1
from b in b1.DefaultIfEmpty()
select new
{
ID = a.ID,
DeviceName = a.DeviceName,
typeStr = b != null ? b.DictKey : string.Empty,
MCUID = a.MCUID
};
return(ResponseModelFactory.CreateSuccessModel(isSignKeyReturn, linq.ToList()));
}
catch (Exception e)
{
return(ResponseModelFactory.CreateReturnModel(isSignKeyReturn, Return_Code.F, e.Message));
}
}
public object DelStoreWeight(Dictionary <string, object> dicParas)
{
try
{
string errMsg = string.Empty;
string id = dicParas.ContainsKey("id") ? (dicParas["id"] + "") : string.Empty;
#region 验证参数
if (string.IsNullOrEmpty(id))
{
errMsg = "门店权重ID不能为空";
return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg));
}
#endregion
//开启EF事务
using (TransactionScope ts = new TransactionScope())
{
try
{
IBase_StoreWeightService base_StoreWeightService = BLLContainer.Resolve <IBase_StoreWeightService>();
int iId = Convert.ToInt32(id);
var base_StoreWeight = base_StoreWeightService.GetModels(p => p.ID == iId).FirstOrDefault();
if (!base_StoreWeightService.Delete(base_StoreWeight))
{
errMsg = "删除门店权重信息失败";
return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg));
}
var dbContext = DbContextFactory.CreateByModelNamespace(typeof(Base_StoreWeight_Game).Namespace);
var base_StoreWeight_Game = dbContext.Set <Base_StoreWeight_Game>().Where(p => p.WeightID == iId).ToList();
foreach (var model in base_StoreWeight_Game)
{
dbContext.Entry(model).State = EntityState.Deleted;
}
if (dbContext.SaveChanges() < 0)
{
errMsg = "删除门店权重游戏机信息失败";
return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg));
}
ts.Complete();
}
catch (Exception ex)
{
return(ResponseModelFactory.CreateReturnModel(isSignKeyReturn, Return_Code.F, ex.Message));
}
}
return(ResponseModelFactory.CreateSuccessModel(isSignKeyReturn));
}
catch (Exception e)
{
return(ResponseModelFactory.CreateReturnModel(isSignKeyReturn, Return_Code.F, e.Message));
}
}
// GET: ProductInfoManage
public ActionResult Index()
{
var dbContext = DbContextFactory.CreateByModelNamespace(typeof(ProductInfoDetailModel).Namespace);
var productInfoModel = dbContext.Set <ProductInfoModel>().Include(m => m.ProductInfoDetails).ToList();
//string sql = "select * from Base_ProductInfo a left join Base_ProductInfo_Detail b on a.ID=b.ProductType";
//var productInfoModel = dbContext.Database.SqlQuery<ProductInfoModel>(sql).ToList();
return(View(productInfoModel ?? new List <ProductInfoModel>()));
}
private List <Flw_BiddingInfo> getFlw_BiddingInfoList(int id)
{
var dbContext = DbContextFactory.CreateByModelNamespace(typeof(Data_BidManage).Namespace);
return((from a in dbContext.Set <Flw_BiddingInfo>().Where(p => p.BidID == id)
join b in dbContext.Set <Base_UserInfo>() on a.UserID equals b.ID
orderby a.BidPrice descending, b.UserLvl, a.BidAmount descending, a.BidTime
select a).ToList());
}
public object DeleteRoot(Dictionary <string, object> dicParas)
{
try
{
string errMsg = string.Empty;
int id = (dicParas.ContainsKey("id") && Utils.isNumber(dicParas["id"])) ? Convert.ToInt32(dicParas["id"]) : 0;
if (id == 0)
{
errMsg = "选中节点id不能为空";
return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg));
}
//开启EF事务
using (TransactionScope ts = new TransactionScope())
{
try
{
var dbContext = DbContextFactory.CreateByModelNamespace(typeof(Dict_System).Namespace);
if (!dbContext.Set <Dict_System>().Any(p => p.ID == id))
{
errMsg = "选中节点数据库不存在";
return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg));
}
var dict_System = dbContext.Set <Dict_System>().Where(p => p.PID == id).ToList();
foreach (var item in dict_System)
{
dbContext.Entry(item).State = EntityState.Deleted;
}
var dict_SystemModel = dbContext.Set <Dict_System>().Where(p => p.ID == id).FirstOrDefault();
dbContext.Entry(dict_SystemModel).State = EntityState.Deleted;
if (dbContext.SaveChanges() < 0)
{
errMsg = "更新数据库失败";
return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg));
}
ts.Complete();
}
catch (Exception ex)
{
return(ResponseModelFactory.CreateReturnModel(isSignKeyReturn, Return_Code.F, ex.Message));
}
}
return(ResponseModelFactory.CreateSuccessModel(isSignKeyReturn));
}
catch (Exception e)
{
return(ResponseModelFactory.CreateReturnModel(isSignKeyReturn, Return_Code.F, e.Message));
}
}
public object GetMerchList(Dictionary <string, object> dicParas)
{
try
{
string errMsg = string.Empty;
object[] conditions = dicParas.ContainsKey("conditions") ? (object[])dicParas["conditions"] : null;
XCCloudUserTokenModel userTokenKeyModel = (XCCloudUserTokenModel)dicParas[Constant.XCCloudUserTokenModel];
//代理商仅能查所属商户，普通商户或大客户只能查自己，莘宸管理员可以查所有商户
SqlParameter[] parameters = new SqlParameter[0];
string sqlWhere = string.Empty;
if (userTokenKeyModel.LogType == (int)RoleType.MerchUser)
{
var merchIdDataModel = userTokenKeyModel.DataModel as MerchDataModel;
Array.Resize(ref parameters, parameters.Length + 1);
if (merchIdDataModel.MerchType == (int)MerchType.Agent)
{
parameters[parameters.Length - 1] = new SqlParameter("@logId", userTokenKeyModel.LogId);
sqlWhere = sqlWhere + " and a.CreateUserID=@logId";
}
else
{
parameters[parameters.Length - 1] = new SqlParameter("@merchId", merchIdDataModel.MerchID);
sqlWhere = sqlWhere + " and a.MerchID=@merchId";
}
}
if (conditions != null && conditions.Length > 0)
{
if (!QueryBLL.GenDynamicSql(conditions, "a.", ref sqlWhere, ref parameters, out errMsg))
{
return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg));
}
}
string sql = @"select a.MerchID, a.MerchName, a.Mobil, b.DictKey as MerchTypeStr, a.MerchAccount, d.DictKey as AllowCreateSubStr, a.AllowCreateCount, c.DictKey as MerchStatusStr from Base_MerchantInfo a " +
" left join (select b.* from Dict_System a inner join Dict_System b on a.ID=b.PID where a.DictKey='商户类别' and a.PID=0) b on convert(varchar, a.MerchType)=b.DictValue " +
" left join (select b.* from Dict_System a inner join Dict_System b on a.ID=b.PID where a.DictKey='商户状态' and a.PID=0) c on convert(varchar, a.MerchStatus)=c.DictValue " +
" left join (select b.* from Dict_System a inner join Dict_System b on a.ID=b.PID where a.DictKey='创建子账号' and a.PID=0) d on convert(varchar, a.AllowCreateSub)=d.DictValue " +
" where 1=1 ";
sql = sql + sqlWhere;
var dbContext = DbContextFactory.CreateByModelNamespace(typeof(Base_MerchantInfo).Namespace);
var base_MerchantInfo = dbContext.Database.SqlQuery <Base_MerchantInfoListModel>(sql, parameters).ToList();
return(ResponseModelFactory.CreateSuccessModel(isSignKeyReturn, base_MerchantInfo));
}
catch (Exception e)
{
return(ResponseModelFactory.CreateReturnModel(isSignKeyReturn, Return_Code.F, e.Message));
}
}
public ActionResult DeleteProduct(int id)
{
string errMsg = "删除成功";
//开启EF事务
using (TransactionScope ts = new TransactionScope())
{
try
{
IBase_ProductInfoService base_ProductInfoService = BLLContainer.Resolve <IBase_ProductInfoService>();
if (base_ProductInfoService.GetCount(p => p.ID == id) == 0)
{
errMsg = "该产品信息不存在";
return(RedirectToAction("Index", "ProductInfoManage", new { errMsg = errMsg }));
}
var base_ProductInfo = base_ProductInfoService.GetModels(p => p.ID == id).FirstOrDefault();
if (!base_ProductInfoService.Delete(base_ProductInfo))
{
errMsg = "数据库更新失败";
return(RedirectToAction("Index", "ProductInfoManage", new { errMsg = errMsg }));
}
IBase_ProductInfo_DetailService base_ProductInfo_DetailService = BLLContainer.Resolve <IBase_ProductInfo_DetailService>();
var dbContext = DbContextFactory.CreateByModelNamespace(typeof(Base_ProductInfo_Detail).Namespace);
var base_ProductInfo_Details = base_ProductInfo_DetailService.GetModels(p => p.ProductType == base_ProductInfo.ID).ToList();
foreach (var item in base_ProductInfo_Details)
{
dbContext.Entry(item).State = System.Data.Entity.EntityState.Deleted;
}
if (dbContext.SaveChanges() < 0)
{
errMsg = "数据库更新失败";
return(RedirectToAction("Index", "ProductInfoManage", new { errMsg = errMsg }));
}
ts.Complete();
}
catch (Exception ex)
{
return(RedirectToAction("Index", "ProductInfoManage", new { errMsg = ex.Message }));
}
}
//更新缓存
ProductTypeBusiness.Init();
return(RedirectToAction("Index", "ProductInfoManage", new { errMsg = errMsg }));
}
public ActionResult UpdateLevel(List <ProductInfoDetailModel> productInfoDetails)
{
string errMsg = "更新等级成功";
if (productInfoDetails == null)
{
errMsg = "上传数据不能为空";
return(RedirectToAction("Index", "ProductInfoManage", new { errMsg = errMsg }));
}
try
{
var dbContext = DbContextFactory.CreateByModelNamespace(typeof(ProductInfoDetailModel).Namespace);
foreach (var item in productInfoDetails)
{
if (!item.CustomerUpper.HasValue)
{
errMsg = "客户上限不能为空";
return(RedirectToAction("Index", "ProductInfoManage", new { errMsg = errMsg }));
}
//if (!item.AreaUpper.HasValue)
//{
// errMsg = "区域上限不能为空";
// return RedirectToAction("Index", "ProductInfoManage", new { errMsg = errMsg });
//}
if (item.ID <= 0)
{
errMsg = "产品信息ID不能为空";
return(RedirectToAction("Index", "ProductInfoManage", new { errMsg = errMsg }));
}
dbContext.Entry(item).State = EntityState.Modified;
}
if (dbContext.SaveChanges() < 0)
{
errMsg = "数据库更新失败";
return(RedirectToAction("Index", "ProductInfoManage", new { errMsg = errMsg }));
}
}
catch (Exception ex)
{
return(RedirectToAction("Index", "ProductInfoManage", new { errMsg = ex.Message }));
}
return(RedirectToAction("Index", "ProductInfoManage", new { errMsg = errMsg }));
}
public object GetOrders(Dictionary <string, object> dicParas)
{
try
{
string errMsg = string.Empty;
object[] conditions = dicParas.ContainsKey("conditions") ? (object[])dicParas["conditions"] : null;
XCCloudUserTokenModel userTokenKeyModel = (XCCloudUserTokenModel)dicParas[Constant.XCCloudUserTokenModel];
string merchId = userTokenKeyModel.DataModel.MerchID;
SqlParameter[] parameters = new SqlParameter[1];
parameters[0] = new SqlParameter("@merchId", merchId);
string sqlWhere = string.Empty;
if (conditions != null && conditions.Length > 0)
{
if (!QueryBLL.GenDynamicSql(conditions, "b.", ref sqlWhere, ref parameters, out errMsg))
{
return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg));
}
}
string sql = @"select b.ID, a.StoreID, a.StoreName, b.OrderID, b.FoodCount, b.OrderSource, b.CreateTime, b.PayType, b.OrderStatus," +
" c.DictKey as OrderSourceStr, d.DictKey as PayTypeStr, e.DictKey as OrderStatusStr, f.FoodName from Base_StoreInfo a " +
" inner join Flw_Order b on a.StoreID=b.StoreID " +
" left join (select b.* from Dict_System a inner join Dict_System b on a.ID=b.PID where a.DictKey='订单来源' and a.PID=0) c on convert(varchar, b.OrderSource)=c.DictValue " +
" left join (select b.* from Dict_System a inner join Dict_System b on a.ID=b.PID where a.DictKey='支付通道' and a.PID=0) d on convert(varchar, b.PayType)=d.DictValue " +
" left join (select b.* from Dict_System a inner join Dict_System b on a.ID=b.PID where a.DictKey='订单状态' and a.PID=0) e on convert(varchar, b.OrderStatus)=e.DictValue " +
" left join (select top 1 a.ID as OrderFlwID, d.FoodName from Flw_Order a inner join Flw_Order_Detail b on a.ID=b.OrderFlwID " +
" inner join Flw_Food_Sale c on b.FoodFlwID=c.ID " +
" inner join Data_FoodInfo d on c.FoodID=d.FoodID) f on b.ID=f.OrderFlwID " +
" where a.MerchID=@merchId ";
sql = sql + sqlWhere;
var dbContext = DbContextFactory.CreateByModelNamespace(typeof(Flw_Order).Namespace);
var flw_Orders = dbContext.Database.SqlQuery <Flw_OrdersModel>(sql, parameters).ToList();
return(ResponseModelFactory.CreateSuccessModel(isSignKeyReturn, flw_Orders));
}
catch (Exception e)
{
return(ResponseModelFactory.CreateReturnModel(isSignKeyReturn, Return_Code.F, e.Message));
}
}
public object GetOrdersCheck(Dictionary <string, object> dicParas)
{
try
{
string errMsg = string.Empty;
string checkDate = dicParas.ContainsKey("checkDate") ? dicParas["checkDate"].ToString() : string.Empty;
XCCloudUserTokenModel userTokenKeyModel = (XCCloudUserTokenModel)dicParas[Constant.XCCloudUserTokenModel];
string merchId = userTokenKeyModel.DataModel.MerchID;
string sql = " exec GetOrdersCheck @CheckDate,@MerchId ";
var parameters = new SqlParameter[2];
parameters[0] = new SqlParameter("@CheckDate", checkDate);
parameters[1] = new SqlParameter("@MerchId", merchId);
var dbContext = DbContextFactory.CreateByModelNamespace(typeof(Flw_CheckDate).Namespace);
var flw_OrderCheck = dbContext.Database.SqlQuery <Flw_OrderCheckModel>(sql, parameters).ToList();
return(ResponseModelFactory.CreateSuccessModel(isSignKeyReturn, flw_OrderCheck));
}
catch (Exception e)
{
return(ResponseModelFactory.CreateReturnModel(isSignKeyReturn, Return_Code.F, e.Message));
}
}
public object GetOrdersDetails(Dictionary <string, object> dicParas)
{
try
{
string errMsg = string.Empty;
int orderFlwId = (dicParas.ContainsKey("id") && Utils.isNumber(dicParas["id"])) ? Convert.ToInt32(dicParas["id"]) : 0;
IFlw_OrderService flw_OrderService = BLLContainer.Resolve <IFlw_OrderService>();
if (!flw_OrderService.Any(p => p.ID == orderFlwId))
{
errMsg = "该订单不存在";
return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg));
}
SqlParameter[] parameters = new SqlParameter[1];
parameters[0] = new SqlParameter("@id", orderFlwId);
string sql = @"select d.*, e.StoreName, f.DictKey as FoodTypeStr, g.DictKey as RechargeTypeStr, h.DictKey as FoodStateStr from Flw_Order a" +
" inner join Flw_Order_Detail b on a.ID=b.OrderFlwID " +
" inner join Flw_Food_Sale c on b.FoodFlwID=c.ID " +
" inner join Data_FoodInfo d on c.FoodID=d.FoodID " +
" left join Base_StoreInfo e on d.StoreID=e.StoreID " +
" left join (select b.* from Dict_System a inner join Dict_System b on a.ID=b.PID where a.DictKey='套餐类别' and a.PID=0) f on convert(varchar, d.FoodType)=f.DictValue " +
" left join (select b.* from Dict_System a inner join Dict_System b on a.ID=b.PID where a.DictKey='充值方式' and a.PID=0) g on convert(varchar, d.RechargeType)=g.DictValue " +
" left join (select b.* from Dict_System a inner join Dict_System b on a.ID=b.PID where a.DictKey='套餐状态' and a.PID=0) h on convert(varchar, d.FoodState)=h.DictValue " +
" where a.ID=@id ";
var dbContext = DbContextFactory.CreateByModelNamespace(typeof(Data_FoodInfo).Namespace);
var data_FoodInfo = dbContext.Database.SqlQuery <Data_FoodInfoModel>(sql, parameters).ToList();
return(ResponseModelFactory.CreateSuccessModel(isSignKeyReturn, data_FoodInfo));
}
catch (Exception e)
{
return(ResponseModelFactory.CreateReturnModel(isSignKeyReturn, Return_Code.F, e.Message));
}
}
public object SaveStoreWeightUserGameInfo(Dictionary <string, object> dicParas)
{
try
{
string errMsg = string.Empty;
string storeId = dicParas.ContainsKey("storeId") ? (dicParas["storeId"] + "") : string.Empty;
string userId = dicParas.ContainsKey("userId") ? (dicParas["userId"] + "") : string.Empty;
string weightType = dicParas.ContainsKey("weightType") ? (dicParas["weightType"] + "") : string.Empty;
var gameIDs = dicParas.ContainsKey("gameIDs") ? ((object[])dicParas["gameIDs"]).Cast <int>() : null;
#region 验证参数
if (string.IsNullOrEmpty(storeId))
{
errMsg = "门店ID不能为空";
return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg));
}
if (string.IsNullOrEmpty(userId))
{
errMsg = "门店老板ID不能为空";
return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg));
}
if (string.IsNullOrEmpty(weightType))
{
errMsg = "门店权重类别不能为空";
return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg));
}
#endregion
//开启EF事务
using (TransactionScope ts = new TransactionScope())
{
try
{
IBase_StoreWeightService base_StoreWeightService = BLLContainer.Resolve <IBase_StoreWeightService>();
int iWeightType = Convert.ToInt32(weightType);
int iUserId = Convert.ToInt32(userId);
if (!base_StoreWeightService.Any(a => a.StoreID.Equals(storeId, StringComparison.OrdinalIgnoreCase) && a.BossID == iUserId))
{
errMsg = "请先分配权重";
return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg));
}
var base_StoreWeight = base_StoreWeightService.GetModels(p => p.StoreID.Equals(storeId, StringComparison.OrdinalIgnoreCase) && p.BossID == iUserId).FirstOrDefault();
base_StoreWeight.WeightType = iWeightType;
if (!base_StoreWeightService.Update(base_StoreWeight))
{
errMsg = "保存权重用户游戏机信息失败";
return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg));
}
if (iWeightType == (int)ChainStoreWeightType.Game)
{
if (gameIDs == null)
{
errMsg = "选择的游戏机列表不能为空";
return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg));
}
//先删除后添加
int iId = base_StoreWeight.ID;
var dbContext = DbContextFactory.CreateByModelNamespace(typeof(Base_StoreWeight_Game).Namespace);
var base_StoreWeight_Game = dbContext.Set <Base_StoreWeight_Game>().Where(p => p.WeightID == iId).ToList();
foreach (var model in base_StoreWeight_Game)
{
dbContext.Entry(model).State = EntityState.Deleted;
}
foreach (var gId in gameIDs)
{
var base_StoreWeight_GameModel = new Base_StoreWeight_Game();
base_StoreWeight_GameModel.WeightID = iId;
base_StoreWeight_GameModel.GameID = gId;
dbContext.Entry(base_StoreWeight_GameModel).State = EntityState.Added;
}
if (dbContext.SaveChanges() < 0)
{
errMsg = "保存权重用户游戏机信息失败";
return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg));
}
}
ts.Complete();
}
catch (Exception ex)
{
errMsg = ex.Message;
return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg));
}
}
return(ResponseModelFactory.CreateSuccessModel(isSignKeyReturn));
}
catch (Exception e)
{
return(ResponseModelFactory.CreateReturnModel(isSignKeyReturn, Return_Code.F, e.Message));
}
}
public BaseDAL()
{
dbContext = DbContextFactory.CreateByModelNamespace(typeof(T).Namespace);
}
public object SaveUserInfo(Dictionary <string, object> dicParas)
{
string errMsg = string.Empty;
int userId, authorId;
string workId = dicParas.ContainsKey("workId") ? dicParas["workId"].ToString() : string.Empty;
string state = dicParas.ContainsKey("state") ? dicParas["state"].ToString() : string.Empty;
string switchable = dicParas.ContainsKey("switchable") ? dicParas["switchable"].ToString() : string.Empty;
string userType = dicParas.ContainsKey("userType") ? dicParas["userType"].ToString() : string.Empty;
string reason = dicParas.ContainsKey("reason") ? dicParas["reason"].ToString() : string.Empty;
string isAdmin = dicParas.ContainsKey("isAdmin") ? dicParas["isAdmin"].ToString() : string.Empty;
if (string.IsNullOrEmpty(state))
{
errMsg = "审核状态state参数不能为空";
return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg));
}
if (string.IsNullOrEmpty(userType))
{
errMsg = "用户类型userType参数不能为空";
return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg));
}
int iUserType = Convert.ToInt32(userType);
if (state == ((int)WorkState.Pass).ToString()) //审核通过
{
if (!dicParas.ContainsKey("userGroup") || dicParas["userGroup"] == null)
{
errMsg = "工作组userGroup参数不能为空";
return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg));
}
if (!dicParas.ContainsKey("userGrant") || dicParas["userGrant"] == null)
{
errMsg = "授权功能列表userGrant参数不能为空";
return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg));
}
}
if (!checkParas(dicParas, out userId, out authorId, out errMsg))
{
LogHelper.SaveLog("错误:" + errMsg);
return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg));
}
//开启EF事务
using (TransactionScope ts = new TransactionScope())
{
try
{
if (state == ((int)WorkState.Pass).ToString()) //审核通过
{
//修改用户信息
Dictionary <string, object> userGroup = new Dictionary <string, object>((IDictionary <string, object>)dicParas["userGroup"], StringComparer.OrdinalIgnoreCase);
IBase_UserGroupService base_UserGroupService = BLLContainer.Resolve <IBase_UserGroupService>();
int ugid = Convert.ToInt32(userGroup["id"]);
if (!base_UserGroupService.Any(w => w.ID.Equals(ugid)))
{
errMsg = "工作组" + userGroup["groupName"] + "不存在";
return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg));
}
IBase_UserInfoService userInfoService = BLLContainer.Resolve <IBase_UserInfoService>();
var base_UserInfo = userInfoService.GetModels(p => p.UserID.Equals(userId)).FirstOrDefault <Base_UserInfo>();
base_UserInfo.UserGroupID = ugid;
base_UserInfo.Auditor = authorId;
base_UserInfo.AuditorTime = DateTime.Now;
base_UserInfo.Status = (int)UserStatus.Pass;
base_UserInfo.IsAdmin = !string.IsNullOrEmpty(isAdmin) ? Convert.ToInt32(isAdmin) : (int?)null;
base_UserInfo.UserType = Convert.ToInt32(userType);
base_UserInfo.Switchable = !string.IsNullOrEmpty(switchable) ? Convert.ToInt32(switchable) : (int?)null;
string storeId = base_UserInfo.StoreID;
if (base_UserInfo.IsAdmin == 1 && userInfoService.Any(a => a.UserID != userId && a.IsAdmin == 1 && a.StoreID.Equals(storeId, StringComparison.OrdinalIgnoreCase)))
{
errMsg = "同一个门店只能有一个管理员";
return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg));
}
if (!userInfoService.Update(base_UserInfo))
{
errMsg = "修改用户信息失败";
return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg));
}
//添加或修改授权功能表
var dbContext = DbContextFactory.CreateByModelNamespace(typeof(Base_UserGrant).Namespace);
var userGrant = (object[])dicParas["userGrant"];
foreach (IDictionary <string, object> iUgr in userGrant)
{
if (iUgr != null)
{
var ugr = new Dictionary <string, object>(iUgr, StringComparer.OrdinalIgnoreCase);
int ugrid = Convert.ToInt32(ugr["id"]);
if (!dbContext.Set <Base_UserGrant>().Any(w => w.GrantID.Value.Equals(ugrid) && w.UserID.Value.Equals(userId)))
{
var base_UserGrant = new Base_UserGrant();
base_UserGrant.GrantID = ugrid;
base_UserGrant.UserID = userId;
base_UserGrant.GrantEN = Convert.ToInt32(ugr["grantEn"]);
dbContext.Entry(base_UserGrant).State = EntityState.Added;
}
else
{
var base_UserGrant = dbContext.Set <Base_UserGrant>().Where(p => p.GrantID == ugrid && p.UserID == userId).FirstOrDefault();
base_UserGrant.GrantEN = Convert.ToInt32(ugr["grantEn"]);
dbContext.Entry(base_UserGrant).State = EntityState.Modified;
}
}
}
if (dbContext.SaveChanges() < 0)
{
errMsg = "保存授权功能失败";
return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg));
}
//修改工单
IXC_WorkInfoService xC_WorkInfoService = BLLContainer.Resolve <IXC_WorkInfoService>();
var xC_WorkInfo = xC_WorkInfoService.GetModels(p => p.WorkID.ToString().Equals(workId, StringComparison.OrdinalIgnoreCase)).FirstOrDefault <XC_WorkInfo>();
xC_WorkInfo.AuditorID = authorId;
xC_WorkInfo.AuditTime = DateTime.Now;
xC_WorkInfo.WorkState = (int)WorkState.Pass;
xC_WorkInfo.AuditBody = "审核通过";
xC_WorkInfo.WorkType = (int)WorkType.UserCheck;
if (!xC_WorkInfoService.Update(xC_WorkInfo))
{
errMsg = "修改工单失败";
return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg));
}
//添加日志
ILog_OperationService log_OperationService = BLLContainer.Resolve <ILog_OperationService>();
var log_Operation = new Log_Operation();
log_Operation.UserID = userId;
log_Operation.AuthorID = authorId;
log_Operation.Content = "审核通过";
if (!log_OperationService.Add(log_Operation))
{
errMsg = "添加日志失败";
return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg));
}
}
else if (state == ((int)WorkState.Reject).ToString()) //审核拒绝
{
//修改工单
IXC_WorkInfoService xC_WorkInfoService = BLLContainer.Resolve <IXC_WorkInfoService>();
var xC_WorkInfo = xC_WorkInfoService.GetModels(p => p.WorkID.ToString().Equals(workId, StringComparison.OrdinalIgnoreCase)).FirstOrDefault <XC_WorkInfo>();
xC_WorkInfo.AuditorID = authorId;
xC_WorkInfo.AuditTime = DateTime.Now;
xC_WorkInfo.WorkState = (int)WorkState.Reject;
xC_WorkInfo.AuditBody = "拒绝理由：" + reason;
xC_WorkInfo.WorkType = (int)WorkType.UserCheck;
if (!xC_WorkInfoService.Update(xC_WorkInfo))
{
errMsg = "修改工单失败";
return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg));
}
//添加日志
ILog_OperationService log_OperationService = BLLContainer.Resolve <ILog_OperationService>();
var log_Operation = new Log_Operation();
log_Operation.UserID = userId;
log_Operation.AuthorID = authorId;
log_Operation.Content = "拒绝理由：" + reason;
if (!log_OperationService.Add(log_Operation))
{
errMsg = "添加日志失败";
return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg));
}
}
else
{
errMsg = "不明确的审核状态";
return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg));
}
ts.Complete();
return(ResponseModelFactory.CreateSuccessModel(isSignKeyReturn));
}
catch (Exception ex)
{
LogHelper.SaveLog("错误:" + ex.Message);
return(ResponseModelFactory.CreateReturnModel(isSignKeyReturn, Return_Code.F, ex.Message));
}
}
}
public object DeleteUserGroup(Dictionary <string, object> dicParas)
{
try
{
string errMsg = string.Empty;
string groupId = dicParas.ContainsKey("groupId") ? dicParas["groupId"].ToString() : string.Empty;
//验证参数
if (string.IsNullOrEmpty(groupId))
{
errMsg = "工作组Id不能为空";
return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg));
}
//开启EF事务
using (TransactionScope ts = new TransactionScope())
{
try
{
IBase_UserGroupService base_UserGroupService = BLLContainer.Resolve <IBase_UserGroupService>();
var base_UserGroup = base_UserGroupService.GetModels(p => p.ID.ToString().Equals(groupId, StringComparison.OrdinalIgnoreCase)).FirstOrDefault <Base_UserGroup>();
if (base_UserGroup == null)
{
errMsg = "该工作组不存在";
return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg));
}
if (!base_UserGroupService.Delete(base_UserGroup))
{
errMsg = "更新数据库失败";
return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg));
}
var dbContext = DbContextFactory.CreateByModelNamespace(typeof(Base_UserGroup_Grant).Namespace);
var base_UserGroup_Grants = dbContext.Set <Base_UserGroup_Grant>().Where(p => p.GroupID.ToString().Equals(groupId, StringComparison.OrdinalIgnoreCase)).ToList();
foreach (var base_UserGroup_Grant in base_UserGroup_Grants)
{
dbContext.Entry(base_UserGroup_Grant).State = EntityState.Deleted;
}
if (dbContext.SaveChanges() < 0)
{
errMsg = "更新数据库失败";
return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg));
}
ts.Complete();
}
catch (Exception ex)
{
return(ResponseModelFactory.CreateReturnModel(isSignKeyReturn, Return_Code.F, ex.Message));
}
}
return(ResponseModelFactory.CreateSuccessModel(isSignKeyReturn));
}
catch (Exception e)
{
return(ResponseModelFactory.CreateReturnModel(isSignKeyReturn, Return_Code.F, e.Message));
}
}
public object EditUserGroup(Dictionary <string, object> dicParas)
{
try
{
string errMsg = string.Empty;
string groupId = dicParas.ContainsKey("groupId") ? dicParas["groupId"].ToString() : string.Empty;
string groupName = dicParas.ContainsKey("groupName") ? dicParas["groupName"].ToString() : string.Empty;
string note = dicParas.ContainsKey("note") ? dicParas["note"].ToString() : string.Empty;
object[] userGroupGrants = dicParas.ContainsKey("userGroupGrants") ? (object[])dicParas["userGroupGrants"] : null;
//验证参数
if (string.IsNullOrEmpty(groupId))
{
errMsg = "工作组Id不能为空";
return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg));
}
if (string.IsNullOrEmpty(groupName))
{
errMsg = "工作组名称不能为空";
return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg));
}
if (!string.IsNullOrEmpty(groupName) && groupName.Length > 50)
{
errMsg = "工作组名称不能超过50字";
return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg));
}
if (!string.IsNullOrEmpty(note) && note.Length > 500)
{
errMsg = "工作组描述不能超过500字";
return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg));
}
//开启EF事务
using (TransactionScope ts = new TransactionScope())
{
try
{
IBase_UserGroupService base_UserGroupService = BLLContainer.Resolve <IBase_UserGroupService>();
var base_UserGroup = base_UserGroupService.GetModels(p => p.ID.ToString().Equals(groupId, StringComparison.OrdinalIgnoreCase)).FirstOrDefault <Base_UserGroup>();
if (base_UserGroup == null)
{
errMsg = "该工作组不存在";
return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg));
}
base_UserGroup.GroupName = groupName;
base_UserGroup.Note = note;
if (!base_UserGroupService.Update(base_UserGroup))
{
errMsg = "更新数据库失败";
return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg));
}
if (userGroupGrants != null && userGroupGrants.Count() >= 0)
{
var dbContext = DbContextFactory.CreateByModelNamespace(typeof(Base_UserGroup_Grant).Namespace);
var base_UserGroup_Grants = dbContext.Set <Base_UserGroup_Grant>().Where(p => p.GroupID.ToString().Equals(groupId, StringComparison.OrdinalIgnoreCase)).ToList();
foreach (var base_UserGroup_Grant in base_UserGroup_Grants)
{
dbContext.Entry(base_UserGroup_Grant).State = EntityState.Deleted;
}
foreach (IDictionary <string, object> el in userGroupGrants)
{
if (el != null)
{
var dicPara = new Dictionary <string, object>(el, StringComparer.OrdinalIgnoreCase);
string functionId = dicPara.ContainsKey("functionId") ? dicPara["functionId"].ToString() : string.Empty;
string isAllow = dicPara.ContainsKey("isAllow") ? dicPara["isAllow"].ToString() : string.Empty;
var base_UserGroup_Grant = new Base_UserGroup_Grant();
base_UserGroup_Grant.FunctionID = Convert.ToInt32(functionId);
base_UserGroup_Grant.GroupID = Convert.ToInt32(groupId);
base_UserGroup_Grant.IsAllow = Convert.ToInt32(isAllow);
dbContext.Entry(base_UserGroup_Grant).State = EntityState.Added;
}
else
{
errMsg = "提交数据包含空对象";
return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg));
}
}
if (dbContext.SaveChanges() < 0)
{
errMsg = "更新数据库失败";
return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg));
}
}
ts.Complete();
}
catch (Exception ex)
{
return(ResponseModelFactory.CreateReturnModel(isSignKeyReturn, Return_Code.F, ex.Message));
}
}
return(ResponseModelFactory.CreateSuccessModel(isSignKeyReturn));
}
catch (Exception e)
{
return(ResponseModelFactory.CreateReturnModel(isSignKeyReturn, Return_Code.F, e.Message));
}
}
public object AddUserGroup(Dictionary <string, object> dicParas)
{
try
{
string errMsg = string.Empty;
string logId = string.Empty;
XCCloudUserTokenModel userTokenKeyModel = (XCCloudUserTokenModel)dicParas[Constant.XCCloudUserTokenModel];
if (userTokenKeyModel.LogType == (int)RoleType.MerchUser)
{
logId = userTokenKeyModel.DataModel.MerchID;
}
string groupName = dicParas.ContainsKey("groupName") ? dicParas["groupName"].ToString() : string.Empty;
string note = dicParas.ContainsKey("note") ? dicParas["note"].ToString() : string.Empty;
object[] userGroupGrants = dicParas.ContainsKey("userGroupGrants") ? (object[])dicParas["userGroupGrants"] : null;
//验证参数
if (string.IsNullOrEmpty(groupName))
{
errMsg = "工作组名称不能为空";
return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg));
}
if (!string.IsNullOrEmpty(groupName) && groupName.Length > 50)
{
errMsg = "工作组名称不能超过50字";
return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg));
}
if (!string.IsNullOrEmpty(note) && note.Length > 500)
{
errMsg = "工作组描述不能超过500字";
return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg));
}
//开启EF事务
using (TransactionScope ts = new TransactionScope())
{
try
{
IBase_UserGroupService base_UserGroupService = BLLContainer.Resolve <IBase_UserGroupService>();
var base_UserGroup = new Base_UserGroup {
GroupName = groupName, MerchID = logId, Note = note
};
if (!base_UserGroupService.Add(base_UserGroup))
{
errMsg = "更新数据库失败";
return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg));
}
if (userGroupGrants != null && userGroupGrants.Count() > 0)
{
var dbContext = DbContextFactory.CreateByModelNamespace(typeof(Base_UserGroup_Grant).Namespace);
foreach (IDictionary <string, object> el in userGroupGrants)
{
if (el != null)
{
var dicPara = new Dictionary <string, object>(el, StringComparer.OrdinalIgnoreCase);
string functionId = dicPara.ContainsKey("functionId") ? dicPara["functionId"].ToString() : string.Empty;
string isAllow = dicPara.ContainsKey("isAllow") ? dicPara["isAllow"].ToString() : string.Empty;
var base_UserGroup_Grant = new Base_UserGroup_Grant {
FunctionID = Convert.ToInt32(functionId), GroupID = base_UserGroup.ID, IsAllow = !string.IsNullOrEmpty(isAllow) ? Convert.ToInt32(isAllow) : default(int?)
};
dbContext.Entry(base_UserGroup_Grant).State = EntityState.Added;
}
else
{
errMsg = "提交数据包含空对象";
return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg));
}
}
if (dbContext.SaveChanges() < 0)
{
errMsg = "更新数据库失败";
return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg));
}
}
ts.Complete();
}
catch (Exception ex)
{
return(ResponseModelFactory.CreateReturnModel(isSignKeyReturn, Return_Code.F, ex.Message));
}
}
return(ResponseModelFactory.CreateSuccessModel(isSignKeyReturn));
}
catch (Exception e)
{
return(ResponseModelFactory.CreateReturnModel(isSignKeyReturn, Return_Code.F, e.Message));
}
}
public object SaveProjectInfo(Dictionary <string, object> dicParas)
{
try
{
XCCloudUserTokenModel userTokenKeyModel = (XCCloudUserTokenModel)dicParas[Constant.XCCloudUserTokenModel];
string storeId = (userTokenKeyModel.DataModel as UserDataModel).StoreID;
string errMsg = string.Empty;
string id = dicParas.ContainsKey("id") ? (dicParas["id"] + "") : string.Empty;
string projectName = dicParas.ContainsKey("projectName") ? (dicParas["projectName"] + "") : string.Empty;
string projectStatus = dicParas.ContainsKey("projectStatus") ? (dicParas["projectStatus"] + "") : string.Empty;
string feeType = dicParas.ContainsKey("feeType") ? (dicParas["feeType"] + "") : string.Empty;
string feeCycle = dicParas.ContainsKey("feeCycle") ? (dicParas["feeCycle"] + "") : string.Empty;
string feeDeposit = dicParas.ContainsKey("feeDeposit") ? (dicParas["feeDeposit"] + "") : string.Empty;
string signOutEn = dicParas.ContainsKey("signOutEn") ? (dicParas["signOutEn"] + "") : string.Empty;
string whenLock = dicParas.ContainsKey("whenLock") ? (dicParas["whenLock"] + "") : string.Empty;
string regretTime = dicParas.ContainsKey("regretTime") ? (dicParas["regretTime"] + "") : string.Empty;
string note = dicParas.ContainsKey("note") ? (dicParas["note"] + "") : string.Empty;
object[] bandPrices = dicParas.ContainsKey("bandPrices") ? (object[])dicParas["bandPrices"] : null;
object[] projectDevices = dicParas.ContainsKey("projectDevices") ? (object[])dicParas["projectDevices"] : null;
int iId = 0;
int.TryParse(id, out iId);
#region 验证参数
if (string.IsNullOrEmpty(projectName))
{
errMsg = "项目名称不能为空";
return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg));
}
if (string.IsNullOrEmpty(projectStatus))
{
errMsg = "项目状态不能为空";
return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg));
}
if (string.IsNullOrEmpty(feeType))
{
errMsg = "计费方式不能为空";
return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg));
}
if (feeType == FeeType.Time.ToString())
{
if (string.IsNullOrEmpty(feeCycle))
{
errMsg = "计费周期不能为空";
return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg));
}
if (string.IsNullOrEmpty(feeDeposit))
{
errMsg = "预收押金不能为空";
return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg));
}
if (Convert.ToInt32(feeCycle) < 0)
{
errMsg = "计费周期不能为负数";
return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg));
}
if (Convert.ToInt32(feeDeposit) < 0)
{
errMsg = "预收押金不能为负数";
return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg));
}
}
if (string.IsNullOrEmpty(signOutEn))
{
errMsg = "是否需要签出不能为空";
return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg));
}
if (string.IsNullOrEmpty(whenLock))
{
errMsg = "入场锁定不能为空";
return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg));
}
if (!string.IsNullOrEmpty(regretTime) && Convert.ToInt32(regretTime) < 0)
{
errMsg = "后悔时间不能为负数";
return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg));
}
#endregion
//开启EF事务
using (TransactionScope ts = new TransactionScope())
{
try
{
IData_ProjectInfoService data_ProjectInfoService = BLLContainer.Resolve <IData_ProjectInfoService>();
if (data_ProjectInfoService.Any(a => a.StoreID.Equals(storeId, StringComparison.OrdinalIgnoreCase) &&
a.ProjectName.Equals(projectName, StringComparison.OrdinalIgnoreCase) && a.ID != iId))
{
errMsg = "该项目名称已存在";
return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg));
}
var data_ProjectInfo = new Data_ProjectInfo();
data_ProjectInfo.ID = iId;
data_ProjectInfo.ProjectName = projectName;
data_ProjectInfo.ProjectStatus = Convert.ToInt32(projectStatus);
data_ProjectInfo.FeeType = Convert.ToInt32(feeType);
data_ProjectInfo.FeeCycle = !string.IsNullOrEmpty(feeCycle) ? Convert.ToInt32(feeCycle) : (int?)null;
data_ProjectInfo.FeeDeposit = !string.IsNullOrEmpty(feeDeposit) ? Convert.ToInt32(feeDeposit) : (int?)null;
data_ProjectInfo.RegretTime = !string.IsNullOrEmpty(regretTime) ? Convert.ToInt32(regretTime) : (int?)null;
data_ProjectInfo.SignOutEN = Convert.ToInt32(signOutEn);
data_ProjectInfo.WhenLock = Convert.ToInt32(whenLock);
data_ProjectInfo.Note = note;
data_ProjectInfo.StoreID = storeId;
if (!data_ProjectInfoService.Any(a => a.ID == iId))
{
//新增
if (!data_ProjectInfoService.Add(data_ProjectInfo))
{
errMsg = "添加门票项目信息失败";
return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg));
}
}
else
{
//修改
if (!data_ProjectInfoService.Update(data_ProjectInfo))
{
errMsg = "修改门票项目信息失败";
return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg));
}
}
iId = data_ProjectInfo.ID;
if (bandPrices != null && bandPrices.Count() >= 0)
{
//先删除已有数据，后添加
var dbContext = DbContextFactory.CreateByModelNamespace(typeof(Data_Project_BandPrice).Namespace);
var data_Project_BandPrice = dbContext.Set <Data_Project_BandPrice>().Where(p => p.ProjectID == iId).ToList();
foreach (var model in data_Project_BandPrice)
{
dbContext.Entry(model).State = EntityState.Deleted;
}
foreach (IDictionary <string, object> el in bandPrices)
{
if (el != null)
{
var dicPara = new Dictionary <string, object>(el, StringComparer.OrdinalIgnoreCase);
string memberLevelIDs = dicPara.ContainsKey("memberLevelIDs") ? dicPara["memberLevelIDs"].ToString() : string.Empty;
string bandType = dicPara.ContainsKey("bandType") ? dicPara["bandType"].ToString() : string.Empty;
string bandCount = dicPara.ContainsKey("bandCount") ? dicPara["bandCount"].ToString() : string.Empty;
string bandPrice = dicPara.ContainsKey("bandPrice") ? dicPara["bandPrice"].ToString() : string.Empty;
if (string.IsNullOrEmpty(memberLevelIDs))
{
errMsg = "会员级别ID列表不能为空";
return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg));
}
if (!Utils.isNumber(bandType))
{
errMsg = "档位类别格式不正确";
return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg));
}
if (Convert.ToInt32(bandCount) < 0)
{
errMsg = "档位数量不能为负数";
return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg));
}
if (Convert.ToInt32(bandPrice) < 0)
{
errMsg = "档位价格不能为负数";
return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg));
}
List <string> memberLevelIDList = memberLevelIDs.Split('|').ToList();
foreach (var memberLevelID in memberLevelIDList)
{
var data_Project_BandPriceModel = new Data_Project_BandPrice();
data_Project_BandPriceModel.ProjectID = iId;
data_Project_BandPriceModel.MemberLevelID = Convert.ToInt32(memberLevelID);
data_Project_BandPriceModel.BandType = Convert.ToInt32(bandType);
data_Project_BandPriceModel.BandCount = Convert.ToInt32(bandCount);
data_Project_BandPriceModel.BandPrice = Convert.ToInt32(bandPrice);
dbContext.Entry(data_Project_BandPriceModel).State = EntityState.Added;
}
}
else
{
errMsg = "提交数据包含空对象";
return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg));
}
}
if (dbContext.SaveChanges() < 0)
{
errMsg = "保存项目波段信息失败";
return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg));
}
}
if (projectDevices != null && projectDevices.Count() >= 0)
{
//先删除已有数据，后添加
var dbContext = DbContextFactory.CreateByModelNamespace(typeof(Data_Project_Device).Namespace);
var data_Project_Device = dbContext.Set <Data_Project_Device>().Where(p => p.ProjectID == iId).ToList();
foreach (var model in data_Project_Device)
{
dbContext.Entry(model).State = EntityState.Deleted;
}
foreach (IDictionary <string, object> el in projectDevices)
{
if (el != null)
{
var dicPara = new Dictionary <string, object>(el, StringComparer.OrdinalIgnoreCase);
string deviceId = dicPara.ContainsKey("deviceId") ? dicPara["deviceId"].ToString() : string.Empty;
string bindType = dicPara.ContainsKey("bindType") ? dicPara["bindType"].ToString() : string.Empty;
if (string.IsNullOrEmpty(deviceId))
{
errMsg = "设备ID不能为空";
return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg));
}
if (string.IsNullOrEmpty(bindType))
{
errMsg = "绑定类型不能为空";
return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg));
}
if (!Utils.isNumber(bindType))
{
errMsg = "绑定类型格式不正确";
return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg));
}
var data_Project_DeviceModel = new Data_Project_Device();
data_Project_DeviceModel.DeviceID = Convert.ToInt32(deviceId);
data_Project_DeviceModel.BindType = Convert.ToInt32(bindType);
data_Project_DeviceModel.ProjectID = iId;
dbContext.Entry(data_Project_DeviceModel).State = EntityState.Added;
}
else
{
errMsg = "提交数据包含空对象";
return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg));
}
}
if (dbContext.SaveChanges() < 0)
{
errMsg = "保存项目设备绑定信息失败";
return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg));
}
}
//如果不需要签出，解绑签出设备
if (data_ProjectInfo.SignOutEN == 0)
{
var dbContext = DbContextFactory.CreateByModelNamespace(typeof(Data_Project_Device).Namespace);
var data_Project_Device = dbContext.Set <Data_Project_Device>().Where(p => p.ProjectID == iId && p.BindType == (int)DeviceBindType.Out).ToList();
foreach (var model in data_Project_Device)
{
dbContext.Entry(model).State = EntityState.Deleted;
}
if (dbContext.SaveChanges() < 0)
{
errMsg = "解绑签出设备失败";
return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg));
}
}
ts.Complete();
}
catch (Exception ex)
{
errMsg = ex.Message;
return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg));
}
}
return(ResponseModelFactory.CreateSuccessModel(isSignKeyReturn));
}
catch (Exception e)
{
return(ResponseModelFactory.CreateReturnModel(isSignKeyReturn, Return_Code.F, e.Message));
}
}
public object EditMerch(Dictionary <string, object> dicParas)
{
try
{
string errMsg = string.Empty;
string merchId = dicParas.ContainsKey("merchId") ? dicParas["merchId"].ToString() : string.Empty;
string merchType = dicParas.ContainsKey("merchType") ? dicParas["merchType"].ToString() : string.Empty;
string merchTag = dicParas.ContainsKey("merchTag") ? dicParas["merchTag"].ToString() : string.Empty;
string merchStatus = dicParas.ContainsKey("merchStatus") ? dicParas["merchStatus"].ToString() : string.Empty;
string merchAccount = dicParas.ContainsKey("merchAccount") ? dicParas["merchAccount"].ToString() : string.Empty;
string merchName = dicParas.ContainsKey("merchName") ? dicParas["merchName"].ToString() : string.Empty;
string openId = dicParas.ContainsKey("openId") ? dicParas["openId"].ToString() : string.Empty;
string mobil = dicParas.ContainsKey("mobil") ? dicParas["mobil"].ToString() : string.Empty;
string allowCreateSub = dicParas.ContainsKey("allowCreateSub") ? dicParas["allowCreateSub"].ToString() : string.Empty;
string allowCreateCount = dicParas.ContainsKey("allowCreateCount") ? dicParas["allowCreateCount"].ToString() : string.Empty;
string comment = dicParas.ContainsKey("comment") ? dicParas["comment"].ToString() : string.Empty;
object[] merchFunction = dicParas.ContainsKey("merchFunction") ? (object[])dicParas["merchFunction"] : null;
XCCloudUserTokenModel userTokenKeyModel = (XCCloudUserTokenModel)dicParas[Constant.XCCloudUserTokenModel];
string createUserId = userTokenKeyModel.LogId;
int logType = userTokenKeyModel.LogType;
#region 验证参数
if (string.IsNullOrEmpty(merchId))
{
errMsg = "商户编号不能为空";
return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg));
}
if (string.IsNullOrWhiteSpace(merchType))
{
errMsg = "商户类型不能为空";
return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg));
}
if (!Utils.isNumber(merchType))
{
errMsg = "商户类别不是Int类型";
return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg));
}
if (string.IsNullOrWhiteSpace(merchStatus))
{
errMsg = "商户状态不能为空";
return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg));
}
if (!Utils.isNumber(merchStatus))
{
errMsg = "商户状态不是Int类型";
return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg));
}
if (string.IsNullOrEmpty(merchTag))
{
errMsg = "商户标签不能为空";
return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg));
}
if (!Utils.isNumber(merchTag))
{
errMsg = "商户标签不是Int类型";
return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg));
}
if (string.IsNullOrWhiteSpace(merchAccount))
{
errMsg = "商户账号不能为空";
return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg));
}
if (merchAccount.Length > 100)
{
errMsg = "商户账号不能超过100个字符";
return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg));
}
if (string.IsNullOrWhiteSpace(merchName))
{
errMsg = "负责人不能为空";
return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg));
}
if (merchName.Length > 50)
{
errMsg = "负责人名称不能超过50个字符";
return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg));
}
if (string.IsNullOrWhiteSpace(openId))
{
errMsg = "请选择微信昵称";
return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg));
}
if (string.IsNullOrWhiteSpace(mobil))
{
errMsg = "手机号不能为空";
return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg));
}
if (!Utils.CheckMobile(mobil))
{
errMsg = "手机号不正确";
return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg));
}
if (!string.IsNullOrEmpty(allowCreateSub) && !Utils.isNumber(allowCreateSub))
{
errMsg = "是否允许创建子账号不是Int类型";
return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg));
}
if (!string.IsNullOrEmpty(allowCreateCount) && !Utils.isNumber(allowCreateCount))
{
errMsg = "账号数量不是Int类型";
return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg));
}
if (!string.IsNullOrEmpty(comment) && comment.Length > 500)
{
errMsg = "备注不能超过500个字符";
return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg));
}
//获取用户基本信息
string unionId = string.Empty;
if (!TokenMana.GetUnionId(openId, out unionId, out errMsg))
{
return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg));
}
#endregion
//开启EF事务
using (TransactionScope ts = new TransactionScope())
{
try
{
IBase_MerchantInfoService base_MerchantInfoService = BLLContainer.Resolve <IBase_MerchantInfoService>();
if (base_MerchantInfoService.GetCount(p => !p.MerchID.Equals(merchId) && p.MerchAccount.Equals(merchAccount, StringComparison.OrdinalIgnoreCase)) > 0)
{
errMsg = "该商户账号名称已存在";
return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg));
}
var base_MerchantInfo = base_MerchantInfoService.GetModels(p => p.MerchID.Equals(merchId)).FirstOrDefault();
base_MerchantInfo.MerchType = Convert.ToInt32(merchType);
base_MerchantInfo.MerchStatus = Convert.ToInt32(merchStatus);
base_MerchantInfo.MerchAccount = merchAccount;
base_MerchantInfo.MerchName = merchName;
base_MerchantInfo.Mobil = mobil;
base_MerchantInfo.WxOpenID = openId;
base_MerchantInfo.WxUnionID = unionId;
base_MerchantInfo.AllowCreateSub = !string.IsNullOrEmpty(allowCreateSub) ? Convert.ToInt32(allowCreateSub) : default(int?);
base_MerchantInfo.AllowCreateCount = !string.IsNullOrEmpty(allowCreateCount) ? Convert.ToInt32(allowCreateCount) : default(int?);
base_MerchantInfo.CreateUserID = createUserId;
base_MerchantInfo.CreateType = (logType == (int)RoleType.XcUser || logType == (int)RoleType.XcAdmin) ? (int)CreateType.Xc : (logType == (int)RoleType.MerchUser ? (int)CreateType.Agent : 0);
base_MerchantInfo.Comment = comment;
base_MerchantInfo.MerchTag = Convert.ToInt32(merchTag);
if (!base_MerchantInfoService.Update(base_MerchantInfo))
{
errMsg = "修改商户信息失败";
return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg));
}
IBase_UserInfoService base_UserInfoService = BLLContainer.Resolve <IBase_UserInfoService>();
var base_UserInfo = base_UserInfoService.GetModels(p => p.OpenID.Equals(openId, StringComparison.OrdinalIgnoreCase)).FirstOrDefault();
if (base_UserInfo == null)
{
base_UserInfo = new Base_UserInfo();
base_UserInfo.OpenID = openId;
base_UserInfo.UserType = Convert.ToInt32(merchType);
if (!base_UserInfoService.Add(base_UserInfo))
{
errMsg = "添加商户负责人信息失败";
return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg));
}
}
if (merchFunction != null && merchFunction.Count() >= 0)
{
//先删除已有数据，后添加
var dbContext = DbContextFactory.CreateByModelNamespace(typeof(Base_MerchFunction).Namespace);
var base_MerchFunctionList = dbContext.Set <Base_MerchFunction>().Where(p => p.MerchID.Equals(merchId, StringComparison.OrdinalIgnoreCase)).ToList();
foreach (var base_MerchFunction in base_MerchFunctionList)
{
dbContext.Entry(base_MerchFunction).State = EntityState.Deleted;
}
foreach (IDictionary <string, object> el in merchFunction)
{
if (el != null)
{
var dicPara = new Dictionary <string, object>(el, StringComparer.OrdinalIgnoreCase);
string functionId = dicPara.ContainsKey("functionId") ? dicPara["functionId"].ToString() : string.Empty;
string functionEn = dicPara.ContainsKey("functionEn") ? dicPara["functionEn"].ToString() : string.Empty;
if (string.IsNullOrEmpty(functionId))
{
errMsg = "功能编号不能为空";
return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg));
}
if (!Utils.isNumber(functionId))
{
errMsg = "功能编号不是Int类型";
return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg));
}
if (!string.IsNullOrEmpty(functionEn) && !Utils.isNumber(functionEn))
{
errMsg = "功能启停不是Int类型";
return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg));
}
var base_MerchFunction = new Base_MerchFunction();
base_MerchFunction.MerchID = merchId;
base_MerchFunction.FunctionID = Convert.ToInt32(functionId);
base_MerchFunction.FunctionEN = !string.IsNullOrEmpty(functionEn) ? Convert.ToInt32(functionEn) : default(int?);
dbContext.Entry(base_MerchFunction).State = EntityState.Added;
}
else
{
errMsg = "提交数据包含空对象";
return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg));
}
}
if (dbContext.SaveChanges() < 0)
{
errMsg = "保存商户功能菜单信息失败";
return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg));
}
}
ts.Complete();
}
catch (Exception ex)
{
errMsg = ex.Message;
return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg));
}
}
//更新缓存
MerchBusiness.Init();
return(ResponseModelFactory.CreateSuccessModel(isSignKeyReturn));
}
catch (Exception e)
{
return(ResponseModelFactory.CreateReturnModel(isSignKeyReturn, Return_Code.F, e.Message));
}
}
public object DeleteProjectInfo(Dictionary <string, object> dicParas)
{
try
{
XCCloudUserTokenModel userTokenKeyModel = (XCCloudUserTokenModel)dicParas[Constant.XCCloudUserTokenModel];
string storeId = (userTokenKeyModel.DataModel as UserDataModel).StoreID;
string errMsg = string.Empty;
string projectIds = dicParas.ContainsKey("projectIds") ? (dicParas["projectIds"] + "") : string.Empty;
if (string.IsNullOrEmpty(projectIds))
{
errMsg = "项目ID不能为空";
return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg));
}
//开启EF事务
using (TransactionScope ts = new TransactionScope())
{
try
{
var dbContext = DbContextFactory.CreateByModelNamespace(typeof(Data_ProjectInfo).Namespace);
List <string> projectIdList = projectIds.Split('|').ToList();
foreach (var projectId in projectIdList)
{
if (string.IsNullOrEmpty(projectId))
{
errMsg = "项目ID不能为空";
return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg));
}
if (!Utils.isNumber(projectId))
{
errMsg = "项目ID格式不正确";
return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg));
}
int iProjectId = Convert.ToInt32(projectId);
var data_ProjectInfoModel = dbContext.Set <Data_ProjectInfo>().Where(p => p.ID == iProjectId).FirstOrDefault();
if (data_ProjectInfoModel == null)
{
errMsg = "项目ID" + projectId + "不存在";
return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg));
}
data_ProjectInfoModel.ProjectStatus = 0; //停用
dbContext.Entry(data_ProjectInfoModel).State = EntityState.Modified;
}
if (dbContext.SaveChanges() < 0)
{
errMsg = "删除项目失败";
return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg));
}
ts.Complete();
}
catch (Exception ex)
{
errMsg = ex.Message;
return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg));
}
}
return(ResponseModelFactory.CreateSuccessModel(isSignKeyReturn));
}
catch (Exception e)
{
return(ResponseModelFactory.CreateReturnModel(isSignKeyReturn, Return_Code.F, e.Message));
}
}