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")); }