public JsonResult test2(string ddd) { ssql = @" select * from BasRainallStation where ID = '{0}' "; ssql = string.Format(ssql, "935"); BasRainallStation BRS = dbDapper.QuerySingleOrDefault <BasRainallStation>(ssql); //BRS.Active_YN = item.Active_YN; //JObject jo = JObject.Parse(JsonInput); //var tt = JsonInput; var FailResult = new { Success = "False", Message = "Error" }; var SuccessResult = new { Success = "True", Message = "Pickups Scheduled Successfully." + BRS.Name }; return(Json(SuccessResult, JsonRequestBehavior.AllowGet)); }
public JsonResult SetBureauActiveSave(List <BasRainallStation> JsonInput) { foreach (BasRainallStation item in JsonInput) { ssql = @" select * from BasRainallStation where ID = '{0}' "; ssql = string.Format(ssql, item.ID); BasRainallStation BRS = dbDapper.QuerySingleOrDefault <BasRainallStation>(ssql); BRS.Active_YN = item.Active_YN; dbDapper.Update <BasRainallStation>(BRS); } var FailResult = new { Success = "False", Message = "Error" }; var SuccessResult = new { Success = "True", Message = "儲存完成" }; return(Json(SuccessResult, JsonRequestBehavior.AllowGet)); }