public static void SetItem(MemberShipLogStatisticLabelModels item)
{
SQLData.Database db = new SQLData.Database(WebInfo.Conn);
SQLData.TableObject tableObj = db.GetTableObject("MemberShipLogStatisticLabels");
tableObj.GetDataFromObject(item);
bool isNew = false;
string sql = "Select 1 From MemberShipLogStatisticLabels Where ID = " + item.ID;
isNew = db.GetFirstValue(sql) == null;
if (isNew)
{
tableObj["Title"] = item.Title;
tableObj["LabelDate"] = item.LabelDate;
tableObj["LabelColor"] = item.LabelColor;
tableObj["ShowStatus"] = item.ShowStatus;
tableObj["Creator"] = item.Creator;
tableObj["CreateTime"] = item.CreateTime;
tableObj.Insert();
}
else
{
tableObj.Remove("Creator");
tableObj.Remove("CreateTime");
tableObj["Title"] = item.Title;
tableObj["LabelDate"] = item.LabelDate;
tableObj["ShowStatus"] = item.ShowStatus;
tableObj["LabelColor"] = item.LabelColor;
tableObj["Modifier"] = item.Modifier;
tableObj["ModifyTime"] = item.ModifyTime;
tableObj.Update(item.ID);
}
}
public ActionResult CustomLabelLineEdit(long?id)
{
MemberShipLogStatisticLabelModels item = null;
if (id != null)
{
item = MemberShipLogStatisticLabelDAO.GetItem((long)id);
item.IsShowCustomLableLine = GetCustomLableCookie();
}
return(View(item));
}
public static void SetItemStatus(long ID, bool ShowStatus)
{
MemberShipLogStatisticLabelModels item = new MemberShipLogStatisticLabelModels();
SQLData.ParameterCollection paraList = new SQLData.ParameterCollection();
paraList.Add("@ID", ID);
paraList.Add("@ShowStatus", ShowStatus);
SQLData.Database db = new SQLData.Database(WebInfo.Conn);
string updateSQL = " UPDATE MemberShipLogStatisticLabels SET ShowStatus=@ShowStatus WHERE ID=@ID ";
db.ExecuteNonQuery(updateSQL, paraList);
}
public ActionResult CustomLabelLineEdit(MemberShipLogStatisticLabelModels item)
{
if (item != null)
{
item.CreateTime = DateTime.Now;
item.Creator = MemberDAO.SysCurrent.Id;
item.ModifyTime = DateTime.Now;
item.Modifier = MemberDAO.SysCurrent.Id;
}
MemberShipLogStatisticLabelDAO.SetItem(item);
//ViewBag.Exit = true;
return(RedirectToAction("CustomLabelLine"));
}
