C# (CSharp) DBEntities.CHECK_FOR_QTY_IN_TRN_IMAGE_VIEWの例

コード例 #1

        public JsonResult Save(short CLIENT_NO = 0, int Year = 0, int Month = 0)
        {
            this.LoadSecurity();
            bool   is_saved  = false;
            string str_error = "";

            List <CHECK_FOR_QTY_IN_TRN_IMAGE_VIEW_Result> checkForQty = new List <CHECK_FOR_QTY_IN_TRN_IMAGE_VIEW_Result>();

            try
            {
                using (DBEntities db = new DBEntities())
                {
                    checkForQty = db.CHECK_FOR_QTY_IN_TRN_IMAGE_VIEW(CLIENT_NO, Year, Month).ToList();
                    if (checkForQty.Count > 0)
                    {
                        foreach (var result in checkForQty)
                        {
                            db.SET_CLIENT_RPT_CLIENT_MONTHLY_IMAGE_VIEW_COMPILE_INSERT(result.CLIENT_NO, Year, Month, result.QUANTITY, this.USER_NO, this.LOGON_NO);
                        }

                        is_saved = true;
                    }
                    else
                    {
                        is_saved = false;
                    }
                }
            }
            catch (Exception ex)
            {
                str_error += Environment.NewLine + ex.Message;
            }

            var ret_val = new
            {
                @is_success = is_saved,
                @msg        = str_error,
            };

            return(Json(ret_val, JsonRequestBehavior.AllowGet));
        }