public static bool SetStatementItems(AgreeStatementSetModels item) { item.ModuleName = statementModuleName; SQLData.Database db = new SQLData.Database(WebInfo.Conn); SQLData.TableObject tableObj = db.GetTableObject("AgreeStatementSet"); tableObj.GetDataFromObject(item); DateTime now = DateTime.Now; string sql = $"SELECT * FROM AgreeStatementSet WHERE ModuleName='{ statementModuleName.Replace("'", "")}' "; bool isNew = db.GetFirstValue(sql) == null; if (isNew) { tableObj["Creator"] = Areas.Backend.Models.DataAccess.MemberDAO.SysCurrent.Id; tableObj["CreateTime"] = now; tableObj["Modifier"] = WorkV3.Areas.Backend.Models.DataAccess.MemberDAO.SysCurrent.Id; tableObj["ModifyTime"] = now; tableObj.Insert(); } else { tableObj.Remove("ModuleName"); tableObj.Remove("Creator"); tableObj.Remove("CreateTime"); tableObj["Modifier"] = WorkV3.Areas.Backend.Models.DataAccess.MemberDAO.SysCurrent.Id; tableObj["ModifyTime"] = now; tableObj.Update(item.ModuleName); } return(true); }
public ActionResult GetAgreeStatement() { AgreeStatementSetModels model = MemberShipSettingDAO.GetStatementItems(); // model.StatementContent = HttpUtility.UrlEncode(model.StatementContent); return(Json(model, JsonRequestBehavior.AllowGet)); }
public ActionResult SetAgreeStatement(AgreeStatementSetModels model) { model.ModuleName = "Member"; model.StatementContent = HttpUtility.UrlDecode(model.StatementContent); bool Result = MemberShipSettingDAO.SetStatementItems(model); bool colSetResult = MemberShipRegSetDAO.UpdateItemSet(PageCache.SiteID, "IsNeedAgreeMemberDesc", model.IsNeedAgree.ToString().ToLower()); if (!colSetResult) { return(Json("fail")); } return(Json(Result ? "success" : "fail")); }
public static bool UpdateItemSet(long SiteID, string columnName, string columnValue) { string sql = $"UPDATE MemberShipRegSet SET {columnName}='{columnValue.Replace("'","")}' WHERE SiteID={SiteID} "; SQLData.Database db = new SQLData.Database(WebInfo.Conn); db.ExecuteNonQuery(sql); if (columnName == "IsNeedAgreeMemberDesc") { AgreeStatementSetModels agreeState = MemberShipSettingDAO.GetStatementItems(); if (agreeState != null) { agreeState.IsNeedAgree = Convert.ToBoolean(columnValue); MemberShipSettingDAO.SetStatementItems(agreeState); } } return(true); }