Esempio n. 1
0
        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));
        }
Esempio n. 2
0
        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));
        }