public ActionResult SaveBigModule(tal_newappsetdata_v2 model, int id = 0)
{
bool result = false;
if (id == 0)
{
model.isparent = true;
result = GetManager.AddTal_newappsetdata_v2(model);
if (result)
{
LoggerManager.InsertOplog(User.Identity.Name, ObjectType, model.id, "添加大渠道" + model.modelname);
}
}
else
{
model.updatetime = DateTime.Now;
model.isparent = true;
result = GetManager.UpdateTal_newappsetdata_v2(model);
if (result)
{
LoggerManager.InsertOplog(User.Identity.Name, ObjectType, model.id, "修改大渠道" + model.modelname);
}
}
return(RedirectToAction("Index"));
}
/// <summary>
/// 修改大渠道
/// </summary>
/// <param name="sqlconnection"></param>
/// <param name="model"></param>
/// <returns></returns>
public static bool UpdateTal_newappsetdata_v2(SqlConnection sqlconnection, tal_newappsetdata_v2 model)
{
string sql = @"
update Gungnir..[tal_newappsetdata_V2]
set isparent=@isparent,
areatype=@areatype,
modelname=@modelname,
apptype=@apptype,
version=@version,
showorder=@showorder,
showstatic=@showstatic,
isothercity=@isothercity,
isproduct=@isproduct
where id=@id";
var sqlpara = new SqlParameter[] {
new SqlParameter("@isparent", model.isparent),
new SqlParameter("@areatype", model.areatype),
new SqlParameter("@modelname", model.modelname),
new SqlParameter("@apptype", model.apptype),
new SqlParameter("@version", model.version),
new SqlParameter("@showorder", model.showorder),
new SqlParameter("@showstatic", model.showstatic),
new SqlParameter("@isothercity", model.isothercity),
new SqlParameter("@isproduct", model.isproduct),
new SqlParameter("@id", model.id)
};
return(SqlHelper.ExecuteNonQuery(sqlconnection, CommandType.Text, sql, sqlpara) > 0 ? true : false);
}
/// <summary>
/// 添加子级
/// </summary>
/// <param name="pid">父ID</param>
/// <param name="id">子ID</param>
/// <param name="isothercity">是否添加城市</param>
/// <returns></returns>
public ActionResult BigModuleChild(int pid = 0, int id = 0, int areatype = 0)
{
#region 获取省市
List <SelectListItem> list = ParentCityList();
ViewBag.ParentCity = list;
if (id == 0 && (list != null && list.Count > 0))
{
ViewBag.ChildCity = ParentCityList(Convert.ToInt32(list[0].Value));
}
#endregion
if (id != 0)
{
ViewBag.Title = "修改";
tal_newappsetdata_v2 appv2 = GetManager.GetTal_newappsetdata_v2ById(id).FirstOrDefault <tal_newappsetdata_v2>();
ViewBag.ChildCity = ParentCityList(Convert.ToInt32(appv2.citycode)) ?? null;
return(View(appv2));
}
else
{
ViewBag.Title = "新增";
tal_newappsetdata_v2 appv2 = new tal_newappsetdata_v2();
appv2.id = 0;
appv2.parentid = pid;
if (areatype == 2)
{
appv2.areatype = (int)AreaTypeEnum.区域楼层;
}
else if (areatype == 3)
{
appv2.areatype = (int)AreaTypeEnum.区域小模块;
}
else if (areatype == 4)
{
appv2.areatype = (int)AreaTypeEnum.小模块城市;
}
else
{
appv2.areatype = areatype;
}
appv2.isparent = false;
appv2.starttime = DateTime.Now;
appv2.overtime = DateTime.Now;
appv2.createtime = DateTime.Now;
appv2.updatetime = DateTime.Now;
return(View(appv2));
}
}
/// <summary>
/// 添加大渠道
/// </summary>
/// <param name="sqlconnection"></param>
/// <param name="model"></param>
/// <returns></returns>
public static bool AddTal_newappsetdata_v2(SqlConnection sqlconnection, tal_newappsetdata_v2 model)
{
string sql = @"insert into Gungnir..[tal_newappsetdata_V2](areatype,isparent,modelname,apptype,version,showorder,showstatic,isothercity,isproduct)
values(@areatype,@isparent,@modelname,@apptype,@version,@showorder,@showstatic,@isothercity,@isproduct)";
var sqlpara = new SqlParameter[] {
new SqlParameter("@areatype", model.areatype),
new SqlParameter("@isparent", model.isparent),
new SqlParameter("@modelname", model.modelname),
new SqlParameter("@apptype", model.apptype),
new SqlParameter("@version", model.version),
new SqlParameter("@showorder", model.showorder),
new SqlParameter("@showstatic", model.showstatic),
new SqlParameter("@isothercity", model.isothercity),
new SqlParameter("@isproduct", model.isproduct)
};
return(SqlHelper.ExecuteNonQuery(sqlconnection, CommandType.Text, sql, sqlpara) > 0 ? true : false);
}
public ActionResult BigModule(int id = 0)
{
if (id != 0)
{
ViewBag.Title = "修改";
tal_newappsetdata_v2 appv2 = GetManager.GetTal_newappsetdata_v2ById(id).FirstOrDefault <tal_newappsetdata_v2>();
return(View(appv2));
}
else
{
ViewBag.Title = "新增";
tal_newappsetdata_v2 appv2 = new tal_newappsetdata_v2()
{
id = 0,
areatype = (int)AreaTypeEnum.大区域,
isparent = true,
createtime = DateTime.Now
};
return(View(appv2));
}
}
public ActionResult SaveBigModuleChild(tal_newappsetdata_v2 model, int parentid = 0, int id = 0)
{
bool result = false;
if (id == 0)
{
model.isparent = false;
result = GetManager.AddChidAreaData(model);
if (result)
{
LoggerManager.InsertOplog(User.Identity.Name, ObjectType, model.id, "添加子区域" + model.modelname);
}
}
else
{
model.isparent = false;
result = GetManager.UpdateChidAreaData(model);
if (result)
{
LoggerManager.InsertOplog(User.Identity.Name, ObjectType, model.id, "修改子区域" + model.modelname);
}
}
return(Json(true));
}
/// <summary>
/// 修改区域
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool UpdateChidAreaData(tal_newappsetdata_v2 model)
{
return(handler.UpdateChidAreaData(model));
}
/// <summary>
/// 添加大渠道
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool AddTal_newappsetdata_v2(tal_newappsetdata_v2 model)
{
return(handler.AddTal_newappsetdata_v2(model));
}
/// <summary>
/// 修改大渠道
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool UpdateTal_newappsetdata_v2(tal_newappsetdata_v2 model)
{
return(handler.UpdateTal_newappsetdata_v2(model));
}
/// <summary>
/// 修改区域
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool UpdateChidAreaData(tal_newappsetdata_v2 model)
{
Func <SqlConnection, bool> action = (connection) => DalHomePageConfig.UpdateChidAreaData(connection, model);
return(dbManager.Execute(action));
}
/// <summary>
/// 添加大渠道
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool AddTal_newappsetdata_v2(tal_newappsetdata_v2 model)
{
Func <SqlConnection, bool> action = (connection) => DalHomePageConfig.AddTal_newappsetdata_v2(connection, model);
return(dbManager.Execute(action));
}
/// <summary>
/// 修改区域
/// </summary>
/// <param name="sqlconnection"></param>
/// <param name="model"></param>
/// <returns></returns>
public static bool UpdateChidAreaData(SqlConnection sqlconnection, tal_newappsetdata_v2 model)
{
string sql = @"UPDATE Gungnir..[tal_newappsetdata_v2]
SET parentid = @parentid ,
isparent = @isparent ,
version = @version ,
showorder = @showorder ,
modelname = @modelname ,
bigtitle = @bigtitle ,
smalltitle = @smalltitle ,
apptype = @apptype ,
areatype = @areatype ,
showstyle = @showstyle ,
citycode = @citycode ,
districtcode = @districtcode ,
jumph5url = @jumph5url ,
icoimgurl = @icoimgurl ,
cpshowbanner = @cpshowbanner ,
appoperateval = @appoperateval ,
productNum = @productNum ,
keyvaluelenth = @keyvaluelenth ,
youmen = @youmen ,
showstatic = @showstatic ,
isothercity = @isothercity ,
isproduct = @isproduct ,
starttime = @starttime ,
overtime = @overtime ,
createtime = @createtime ,
updatetime = @updatetime ,
IsReadChild = @IsReadChild ,
StartVersion = @StartVersion ,
EndVersion = @EndVersion
WHERE id = @id";
var sqlpara = new SqlParameter[] {
new SqlParameter("@id", model.id),
new SqlParameter("@parentid", model.parentid),
new SqlParameter("@isparent", model.isparent),
new SqlParameter("@version", model.version),
new SqlParameter("@showorder", model.showorder),
new SqlParameter("@modelname", model.modelname),
new SqlParameter("@bigtitle", model.bigtitle),
new SqlParameter("@smalltitle", model.smalltitle),
new SqlParameter("@apptype", model.apptype),
new SqlParameter("@areatype", model.areatype),
new SqlParameter("@showstyle", model.showstyle),
new SqlParameter("@citycode", model.citycode),
new SqlParameter("@districtcode", model.districtcode),
new SqlParameter("@jumph5url", model.jumph5url),
new SqlParameter("@icoimgurl", model.icoimgurl),
new SqlParameter("@cpshowbanner", model.cpshowbanner),
new SqlParameter("@appoperateval", model.appoperateval),
new SqlParameter("@productNum", model.productNum),
new SqlParameter("@keyvaluelenth", model.keyvaluelenth),
new SqlParameter("@youmen", model.youmen),
new SqlParameter("@showstatic", model.showstatic),
new SqlParameter("@isothercity", model.isothercity),
new SqlParameter("@isproduct", model.isproduct),
new SqlParameter("@starttime", model.starttime),
new SqlParameter("@overtime", model.overtime),
new SqlParameter("@createtime", model.createtime),
new SqlParameter("@updatetime", model.updatetime),
new SqlParameter("@IsReadChild", model.IsReadChild),
new SqlParameter("@StartVersion", model.StartVersion ?? string.Empty),
new SqlParameter("@EndVersion", model.EndVersion ?? string.Empty)
};
return(SqlHelper.ExecuteNonQuery(sqlconnection, CommandType.Text, sql, sqlpara) > 0 ? true : false);
}
