public ActionResult TabClick(int TabID)
{
IndexViewData = (IndexDataModel)Session["IndexData"];
WorkWithOffers WWO = new WorkWithOffers(Server);
if (IndexViewData == null)
{
IndexViewData = new IndexDataModel();
}
switch (TabID)
{
case 1:
IndexViewData.ShowTopOffers();
IndexViewData.TopOffers = WWO.GetTopOffers();
break;
case 2:
WorkWithUsers WWU = new WorkWithUsers();
IndexViewData.ShowTopUsers();
IndexViewData.TopUsers = WWU.GetTopUsers();
break;
case 3:
IndexViewData.ShowNewOffers();
IndexViewData.NewOffers = WWO.GetNewOffers();
break;
}
Session["IndexData"] = IndexViewData;
return(RedirectToAction("Index", "Home"));
}
public ActionResult Index()
{
var items = CNTPO2.GetItems();
var categories = CNTPO2.GetCategories();
var subCategories = CNTPO2.GetSubCategories();
var data = new IndexDataModel
{
Items = items.Select(x => new CNProduct
{
ID = x.ID,
Name = x.Name,
ImgUrl = x.ImgUrl,
Price = x.Price,
IsOffer = x.IsOffer,
IsFeatured = x.IsFeatured
}).ToList(),
Categories = categories.Select(y => new CNCategories
{
ID = y.ID,
Category = y.Category
}).ToList(),
SubCategorieses = subCategories.Select(w => new CNSubCategories
{
ID = w.ID,
Name = w.Name,
IdCategory = w.IdCategory
}).ToList()
};
return(View(data));
}
public async Task <IActionResult> Edit(string id, [Bind("Name,Occupation,Description,Picture,Email,PhoneNo,Cv")] IndexDataModel indexDataModel)
{
if (id != indexDataModel.Name)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(indexDataModel);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!IndexDataModelExists(indexDataModel.Name))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
return(View(indexDataModel));
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(IndexDataModel model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into IndexData(");
strSql.Append("ReKey,Url,JsonMemo,EventName,ItemTitle,ItemContent,ItemType,ItemClass,OrderNo,CreateTime,CreateUser,ImgId");
strSql.Append(") values (");
strSql.Append("@ReKey,@Url,@JsonMemo,@EventName,@ItemTitle,@ItemContent,@ItemType,@ItemClass,@OrderNo,@CreateTime,@CreateUser,@ImgId");
strSql.Append(") ");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@ReKey", SqlDbType.VarChar, 50),
new SqlParameter("@Url", SqlDbType.VarChar, 50),
new SqlParameter("@JsonMemo", SqlDbType.Xml, -1),
new SqlParameter("@EventName", SqlDbType.VarChar, 50),
new SqlParameter("@ItemTitle", SqlDbType.VarChar, 200),
new SqlParameter("@ItemContent", SqlDbType.VarChar, 2000),
new SqlParameter("@ItemType", SqlDbType.VarChar, 20),
new SqlParameter("@ItemClass", SqlDbType.VarChar, 20),
new SqlParameter("@OrderNo", SqlDbType.Int, 4),
new SqlParameter("@CreateTime", SqlDbType.DateTime),
new SqlParameter("@CreateUser", SqlDbType.VarChar, 50),
new SqlParameter("@ImgId", SqlDbType.VarChar, 50)
};
parameters[0].Value = model.ReKey;
parameters[1].Value = model.Url;
parameters[2].Value = model.JsonMemo;
parameters[3].Value = model.EventName;
parameters[4].Value = model.ItemTitle;
parameters[5].Value = model.ItemContent;
parameters[6].Value = model.ItemType;
parameters[7].Value = model.ItemClass;
parameters[8].Value = model.OrderNo;
parameters[9].Value = model.CreateTime;
parameters[10].Value = model.CreateUser;
parameters[11].Value = model.ImgId;
bool result = false;
try
{
model.AutoId = decimal.Parse(helper.ExecuteNonQueryBackId(strSql.ToString(), "AutoId", parameters));
result = true;
}
catch (Exception ex)
{
this.helper.Close();
throw ex;
}
finally
{
}
return(result);
}
public IActionResult Index([Bind] IndexPageStatusModel pageStatusModel = null)
{
var dataModel = new IndexDataModel
{
Data = GetAllVacancies(),
Status = pageStatusModel.ToStatus(VacancyIndexPageStatuses.Data)
};
return(View(dataModel));
}
public async Task <IActionResult> Create([Bind("Name,Occupation,Description,Picture,Email,PhoneNo,Cv")] IndexDataModel indexDataModel)
{
if (ModelState.IsValid)
{
_context.Add(indexDataModel);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
return(View(indexDataModel));
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public IndexDataModel GetModel(decimal AutoId)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select AutoId, ReKey, Url, JsonMemo, EventName, ItemTitle, ItemContent, ItemType, ItemClass, OrderNo, CreateTime, CreateUser, ImgId ");
strSql.Append(" from IndexData ");
strSql.Append(" where AutoId=@AutoId ");
SqlParameter[] parameters =
{
new SqlParameter("@AutoId", SqlDbType.Decimal, 9)
};
parameters[0].Value = AutoId;
IndexDataModel model = new IndexDataModel();
DataSet ds = helper.ExecSqlReDs(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["AutoId"].ToString() != "")
{
model.AutoId = decimal.Parse(ds.Tables[0].Rows[0]["AutoId"].ToString());
}
model.ReKey = ds.Tables[0].Rows[0]["ReKey"].ToString();
model.Url = ds.Tables[0].Rows[0]["Url"].ToString();
model.JsonMemo = ds.Tables[0].Rows[0]["JsonMemo"].ToString();
model.EventName = ds.Tables[0].Rows[0]["EventName"].ToString();
model.ItemTitle = ds.Tables[0].Rows[0]["ItemTitle"].ToString();
model.ItemContent = ds.Tables[0].Rows[0]["ItemContent"].ToString();
model.ItemType = ds.Tables[0].Rows[0]["ItemType"].ToString();
model.ItemClass = ds.Tables[0].Rows[0]["ItemClass"].ToString();
if (ds.Tables[0].Rows[0]["OrderNo"].ToString() != "")
{
model.OrderNo = int.Parse(ds.Tables[0].Rows[0]["OrderNo"].ToString());
}
if (ds.Tables[0].Rows[0]["CreateTime"].ToString() != "")
{
model.CreateTime = DateTime.Parse(ds.Tables[0].Rows[0]["CreateTime"].ToString());
}
model.CreateUser = ds.Tables[0].Rows[0]["CreateUser"].ToString();
model.ImgId = ds.Tables[0].Rows[0]["ImgId"].ToString();
return(model);
}
else
{
return(null);
}
}
public ActionResult Index()
{
IndexViewData = (IndexDataModel)Session["IndexData"];
WorkWithTags WWT = new WorkWithTags();
WorkWithOffers WWO = new WorkWithOffers(Server);
WorkWithUsers WWU = new WorkWithUsers();
if (IndexViewData == null)
{
IndexViewData = new IndexDataModel();
IndexViewData.ShowString = "NewOffers";
IndexViewData.NewOffers = WWO.GetNewOffers();
}
IndexViewData.WeightTags = WWT.GetWeightTags();
ViewBag.ViewData = IndexViewData;
Session["IndexData"] = IndexViewData;
if (User.Identity.Name != "")
{
if (WWU.GetUserRole(IdentityExtensions.GetUserId(User.Identity)) == "Banned")
{
return(RedirectToAction("UserBanned", "AccessDenied"));
}
}
if (IndexViewData.ShowString == "NewOffers")
{
IndexViewData.NewOffers = WWO.GetNewOffers();
}
if (IndexViewData.ShowString == "TopUsers")
{
IndexViewData.TopUsers = WWU.GetTopUsers();
}
if (IndexViewData.ShowString == "TopOffers")
{
IndexViewData.NewOffers = WWO.GetTopOffers();
}
return(View());
}
public ActionResult Index()
{
var model = new IndexModel()
{
DropDownValue = "\"1\\"
};
var data = new IndexDataModel()
{
DropDownData = new List <SelectListItem>()
{
new SelectListItem()
{
Text = "eeee", Value = "1"
},
new SelectListItem()
{
Text = "eee22222", Value = "2"
}
}
};
return(View(model, data));
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(IndexDataModel model)
{
bool reValue = true;
int reCount = 0;
StringBuilder strSql = new StringBuilder();
strSql.Append("update IndexData set ");
strSql.Append(" ReKey = @ReKey , ");
strSql.Append(" Url = @Url , ");
strSql.Append(" JsonMemo = @JsonMemo , ");
strSql.Append(" EventName = @EventName , ");
strSql.Append(" ItemTitle = @ItemTitle , ");
strSql.Append(" ItemContent = @ItemContent , ");
strSql.Append(" ItemType = @ItemType , ");
strSql.Append(" ItemClass = @ItemClass , ");
strSql.Append(" OrderNo = @OrderNo , ");
strSql.Append(" CreateTime = @CreateTime , ");
strSql.Append(" CreateUser = @CreateUser , ");
strSql.Append(" ImgId = @ImgId ");
strSql.Append(" where AutoId=@AutoId ");
SqlParameter[] parameters =
{
new SqlParameter("@AutoId", SqlDbType.Decimal, 9),
new SqlParameter("@ReKey", SqlDbType.VarChar, 50),
new SqlParameter("@Url", SqlDbType.VarChar, 50),
new SqlParameter("@JsonMemo", SqlDbType.Xml, -1),
new SqlParameter("@EventName", SqlDbType.VarChar, 50),
new SqlParameter("@ItemTitle", SqlDbType.VarChar, 200),
new SqlParameter("@ItemContent", SqlDbType.VarChar, 2000),
new SqlParameter("@ItemType", SqlDbType.VarChar, 20),
new SqlParameter("@ItemClass", SqlDbType.VarChar, 20),
new SqlParameter("@OrderNo", SqlDbType.Int, 4),
new SqlParameter("@CreateTime", SqlDbType.DateTime),
new SqlParameter("@CreateUser", SqlDbType.VarChar, 50),
new SqlParameter("@ImgId", SqlDbType.VarChar, 50)
};
parameters[0].Value = model.AutoId;
parameters[1].Value = model.ReKey;
parameters[2].Value = model.Url;
parameters[3].Value = model.JsonMemo;
parameters[4].Value = model.EventName;
parameters[5].Value = model.ItemTitle;
parameters[6].Value = model.ItemContent;
parameters[7].Value = model.ItemType;
parameters[8].Value = model.ItemClass;
parameters[9].Value = model.OrderNo;
parameters[10].Value = model.CreateTime;
parameters[11].Value = model.CreateUser;
parameters[12].Value = model.ImgId; try
{//异常处理
reCount = this.helper.ExecSqlReInt(strSql.ToString(), parameters);
}
catch (Exception ex)
{
this.helper.Close();
throw ex;
}
if (reCount <= 0)
{
reValue = false;
}
return(reValue);
}
public IndexViewModel(IndexDataModel model) : base(model)
{
ExposedDataModelProperty = model?.Property;
ViewOnlyProperty = ExposedDataModelProperty + " for a View";
}
