/// <summary> /// /// </summary> /// <param name="userId"></param> /// <param name="jsonObj"></param> /// <returns></returns> public bool AddUserPlanApp(int userId, dynamic jsonObj) { using (var db = DbInstance) { try { db.Ado.BeginTran(); WJ_T_UserPlan plan = new WJ_T_UserPlan() { UserId = userId, UserPlan_Name = jsonObj.PlanName.ToString(), UserPlan_Layout = jsonObj.PlanLayout.ToString(), UserPlan_State = 1, UserPlan_CreateTime = DateTime.Now, UserPlan_UseCount = 0 }; int planId = db.Insertable(plan).ExecuteReturnIdentity(); if (planId <= 0) { db.Ado.RollbackTran(); return(false); } List <WJ_T_UserPlanApp> userPlanAppList = new List <WJ_T_UserPlanApp>(); foreach (var item in jsonObj.AppList) { WJ_T_UserPlanApp userPlanApp = new WJ_T_UserPlanApp() { UserPlanId = planId, AppId = Convert.ToInt32(item.AppId), UserPlanApp_Location = item.AppLocation.ToString(), UserPlanApp_State = 1 }; userPlanAppList.Add(userPlanApp); } if (db.Insertable(userPlanAppList.ToArray()).ExecuteCommand() == userPlanAppList.Count) { db.Ado.CommitTran(); return(true); } else { db.Ado.RollbackTran(); return(false); } } catch (Exception ex) { LogHelper.DbServiceLog(ex.Message); db.Ado.RollbackTran(); return(false); } } }
/// <summary> /// /// </summary> /// <param name="userId"></param> /// <param name="jsonObj"></param> /// <returns></returns> public bool UpdateUserPlan(int userId, dynamic jsonObj) { using (var db = DbInstance) { try { db.Ado.BeginTran(); int userPlanId = Convert.ToInt32(jsonObj.PlanId); if (userPlanId <= 0) { db.RollbackTran(); return(false); } db.Deleteable <WJ_T_UserPlanApp>().Where(it => it.UserPlanId == userPlanId).ExecuteCommand();//删除所有方案应用 WJ_T_UserPlan plan = new WJ_T_UserPlan() { Id = userPlanId, UserId = userId, UserPlan_Name = jsonObj.PlanName.ToString(), UserPlan_Layout = jsonObj.PlanLayout.ToString() }; //db.Updateable(plan).Where(p => p.Id == userPlanId).ExecuteCommand();//更新用户方案信息 db.Updateable(plan).ExecuteCommand();//更新用户方案信息 List <WJ_T_UserPlanApp> userPlanAppList = new List <WJ_T_UserPlanApp>(); foreach (var item in jsonObj.AppList) { WJ_T_UserPlanApp userPlanApp = new WJ_T_UserPlanApp() { UserPlanId = userPlanId, AppId = Convert.ToInt32(item.AppId), UserPlanApp_Location = item.AppLocation.ToString(), UserPlanApp_State = 1 }; userPlanAppList.Add(userPlanApp); } if (db.Insertable(userPlanAppList.ToArray()).ExecuteCommand() == userPlanAppList.Count) { db.Ado.CommitTran(); return(true); } else { db.Ado.RollbackTran(); return(false); } } catch (Exception ex) { LogHelper.DbServiceLog(ex.Message); db.Ado.RollbackTran(); return(false); } } }