/// <summary>
///
/// </summary>
/// <param name="userId"></param>
/// <param name="jsonObj"></param>
/// <returns></returns>
public bool AddUserPlan(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);
}
}
}
