public ActionResult Edit(PointsCenterConfig model) { string js = "<script>alert(\"保存失败 \");location='/PointsCenterConfig/Index';</script>"; if (model.Id != 0) { if (PointsCenterConfigManager.UpdatePointsCenterConfig(model)) { return(RedirectToAction("Index")); } else { return(Content(js)); } } else { if (PointsCenterConfigManager.InsertPointsCenterConfig(model)) { return(RedirectToAction("Index")); } else { return(Content(js)); } } }
public static bool UpdatePointsCenterConfig(PointsCenterConfig model) { const string sql = @"UPDATE Configuration..PointsCenterConfig SET Sort=@Sort, Grade=@Grade, Status=@Status, Image=@Image, Link=@Link, IOSProcessValue=@IOSProcessValue, AndroidProcessValue=@AndroidProcessValue, IOSCommunicationValue=@IOSCommunicationValue, AndroidCommunicationValue=@AndroidCommunicationValue, CreateTime= GETDATE(), Description=@Description WHERE Id=@Id"; var sqlParameter = new SqlParameter[] { new SqlParameter("@Sort", model.Sort), new SqlParameter("@Status", model.Status), new SqlParameter("@AndroidCommunicationValue", model.AndroidCommunicationValue ?? string.Empty), new SqlParameter("@AndroidProcessValue", model.AndroidProcessValue ?? string.Empty), new SqlParameter("@Grade", model.Grade), new SqlParameter("@Image", model.Image), new SqlParameter("@IOSCommunicationValue", model.IOSCommunicationValue), new SqlParameter("@IOSProcessValue", model.IOSProcessValue), new SqlParameter("@Link", model.Link ?? string.Empty), new SqlParameter("@Id", model.Id), new SqlParameter("@Description", model.Description ?? string.Empty) }; return(SqlHelper.ExecuteNonQuery(conn, CommandType.Text, sql, sqlParameter) > 0); }
public bool InsertPointsCenterConfig(PointsCenterConfig model) { try { return(DAlPointsCenterConfig.InsertPointsCenterConfig(model)); } catch (TuhuBizException) { throw; } catch (Exception ex) { var exception = new PointsCenterConfigException(1, "InsertPointsCenterConfig", ex); Logger.Log(Level.Error, exception, "InsertPointsCenterConfig"); throw ex; } }
public static bool InsertPointsCenterConfig(PointsCenterConfig model) { const string sql = @" INSERT INTO Configuration..PointsCenterConfig (Sort , Grade , Status , Image , Link , IOSProcessValue , AndroidProcessValue , IOSCommunicationValue , AndroidCommunicationValue , CreateTime, Description ) VALUES( @Sort, --Sort - int @Grade, --Grade - int @Status, --Status - bit @Image, --Image - nvarchar(1000) @Link, --Link - nvarchar(500) @IOSProcessValue, --IOSProcessValue - nvarchar(500) @AndroidProcessValue, --AndroidProcessValue - nvarchar(500) @IOSCommunicationValue, --IOSCommunicationValue - nvarchar(500) @AndroidCommunicationValue, --AndroidCommunicationValue - nvarchar(500) GETDATE(),-- CreateTime - datetime @Description )"; var sqlParameter = new SqlParameter[] { new SqlParameter("@Sort", model.Sort), new SqlParameter("@Status", model.Status), new SqlParameter("@AndroidCommunicationValue", model.AndroidCommunicationValue ?? string.Empty), new SqlParameter("@AndroidProcessValue", model.AndroidProcessValue ?? string.Empty), new SqlParameter("@Grade", model.Grade), new SqlParameter("@Image", model.Image), new SqlParameter("@IOSCommunicationValue", model.IOSCommunicationValue), new SqlParameter("@IOSProcessValue", model.IOSProcessValue), new SqlParameter("@Link", model.Link ?? string.Empty), new SqlParameter("@Description", model.Description ?? string.Empty) }; return(SqlHelper.ExecuteNonQuery(conn, CommandType.Text, sql, sqlParameter) > 0); }