/// <summary>
/// 修改大渠道
/// </summary>
/// <param name="sqlconnection"></param>
/// <param name="model"></param>
/// <returns></returns>
public static bool UpdateOrderArea(SqlConnection sqlconnection, OrderArea model)
{
const string sql = @"UPDATE Gungnir..[OrderFinishPageSetting]
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);
}
public void StartOrder(FoodOrder order)
{
FoodManager.Instance.OrderFood(order);
OrderArea areaOrder = FindObjectOfType <OrderArea>();
areaOrder.OrderFood(order);
}
public ActionResult SaveBigModule(OrderArea model, int id = 0)
{
bool result = false;
if (id == 0)
{
model.isparent = true;
result = OrderAreaManager.AddOrderArea(model);
if (result)
{
LoggerManager.InsertOplog(User.Identity.Name, ObjectType, model.id, "添加大渠道" + model.modelname);
}
}
else
{
model.updatetime = DateTime.Now;
model.isparent = true;
result = OrderAreaManager.UpdateOrderArea(model);
if (result)
{
LoggerManager.InsertOplog(User.Identity.Name, ObjectType, model.id, "修改大渠道" + model.modelname);
}
}
return(RedirectToAction("Index"));
}
public ActionResult SaveBigModuleChild(OrderArea model, int parentid = 0, int id = 0)
{
if (!string.IsNullOrWhiteSpace(model.keyvaluelenth))
{
model.keyvaluelenth = model.keyvaluelenth.Replace("<", "<").Replace(">", ">");
}
bool result = false;
if (id == 0)
{
model.isparent = false;
result = OrderAreaManager.AddChidAreaData(model);
if (result)
{
LoggerManager.InsertOplog(User.Identity.Name, ObjectType, model.id, "添加子区域" + model.modelname);
}
}
else
{
model.isparent = false;
result = OrderAreaManager.UpdateChidAreaData(model);
if (result)
{
LoggerManager.InsertOplog(User.Identity.Name, ObjectType, model.id, "修改子区域" + model.modelname);
}
}
return(Json(true));
}
/// <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 = "修改";
OrderArea appv2 = OrderAreaManager.GetOrderAreaById(id).FirstOrDefault();
ViewBag.ChildCity = ParentCityList(Convert.ToInt32(appv2.citycode)) ?? null;
return(View(appv2));
}
else
{
ViewBag.Title = "新增";
OrderArea appv2 = new OrderArea();
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="model"></param>
/// <returns></returns>
public bool UpdateOrderArea(OrderArea model)
{
try
{
return(handler.UpdateOrderArea(model));
}
catch (TuhuBizException)
{
throw;
}
catch (Exception ex)
{
var exception = new OrderAreaException(1, "UpdateOrderArea", ex);
Logger.Log(Level.Error, exception, "UpdateOrderArea");
throw ex;
}
}
// Start is called before the first frame update
void Start()
{
_foodOrder = new List <FoodOrder>();
_allFoodResource = new List <FoodInfo>();
_foodForSpawn = new List <FoodInfoSpaw>();
_refreshFoodResource = false;
_haveFoodOrder = false;
_isPowerUpSlowConveyor = false;
_missingOrder = 0;
_numFoodComplete = 0;
_levelConveyor = 0;
_foodInfoTmp = new FoodInfo();
_foodOrderTmp = new FoodOrder();
areaOrder = FindObjectOfType <OrderArea>();
}
public ActionResult BigModule(int id = 0)
{
if (id != 0)
{
ViewBag.Title = "修改";
OrderArea appv2 = OrderAreaManager.GetOrderAreaById(id).FirstOrDefault();
return(View(appv2));
}
else
{
ViewBag.Title = "新增";
OrderArea appv2 = new OrderArea()
{
id = 0,
areatype = (int)AreaTypeEnum.大区域,
isparent = true,
createtime = DateTime.Now
};
return(View(appv2));
}
}
/// <summary>
/// 添加大渠道
/// </summary>
/// <param name="sqlconnection"></param>
/// <param name="model"></param>
/// <returns></returns>
public static bool AddOrderArea(SqlConnection sqlconnection, OrderArea model)
{
const string sql = @"INSERT INTO Gungnir..[OrderFinishPageSetting]
( 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);
}
/// <summary>
/// 修改区域
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool UpdateChidAreaData(OrderArea model)
{
Func <SqlConnection, bool> action = (connection) => DALOrderArea.UpdateChidAreaData(connection, model);
return(dbManager.Execute(action));
}
/// <summary>
/// 添加大渠道
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool AddOrderArea(OrderArea model)
{
Func <SqlConnection, bool> action = (connection) => DALOrderArea.AddOrderArea(connection, model);
return(dbManager.Execute(action));
}
/// <summary>
/// 修改区域
/// </summary>
/// <param name="sqlconnection"></param>
/// <param name="model"></param>
/// <returns></returns>
public static bool UpdateChidAreaData(SqlConnection sqlconnection, OrderArea model)
{
const string sql = @" UPDATE Gungnir..[OrderFinishPageSetting]
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
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)
};
return(SqlHelper.ExecuteNonQuery(sqlconnection, CommandType.Text, sql, sqlpara) > 0);
}
