//
        // GET: /QAM/CheckSettingPoint/Detail
        public async Task <ActionResult> Detail(string checksettingKey, int itemNo)
        {
            using (CheckSettingPointServiceClient client = new CheckSettingPointServiceClient())
            {
                MethodReturnResult <CheckSettingPoint> result = await client.GetAsync(new CheckSettingPointKey()
                {
                    CheckSettingKey = checksettingKey,
                    ItemNo          = itemNo
                });

                if (result.Code == 0)
                {
                    CheckSettingPointViewModel viewModel = new CheckSettingPointViewModel()
                    {
                        CheckSettingKey = result.Data.Key.CheckSettingKey,
                        ItemNo          = result.Data.Key.ItemNo,
                        CheckPlanName   = result.Data.CheckPlanName,
                        CategoryName    = result.Data.CategoryName,
                        Status          = result.Data.Status,
                        Editor          = result.Data.Editor,
                        EditTime        = result.Data.EditTime,
                        CreateTime      = result.Data.CreateTime,
                        Creator         = result.Data.Creator
                    };
                    return(PartialView("_InfoPartial", viewModel));
                }
                else
                {
                    ModelState.AddModelError("", result.Message);
                }
            }
            return(PartialView("_InfoPartial"));
        }
        public async Task <ActionResult> SaveModify(CheckSettingPointViewModel model)
        {
            using (CheckSettingPointServiceClient client = new CheckSettingPointServiceClient())
            {
                MethodReturnResult <CheckSettingPoint> result = await client.GetAsync(new CheckSettingPointKey()
                {
                    CheckSettingKey = model.CheckSettingKey,
                    ItemNo          = model.ItemNo
                });

                if (result.Code == 0)
                {
                    result.Data.CategoryName  = model.CategoryName;
                    result.Data.CheckPlanName = model.CheckPlanName;
                    result.Data.Status        = model.Status;
                    result.Data.Editor        = User.Identity.Name;
                    result.Data.EditTime      = DateTime.Now;
                    MethodReturnResult rst = await client.ModifyAsync(result.Data);

                    if (rst.Code == 0)
                    {
                        rst.Message = string.Format(QAMResources.StringResource.CheckSettingPoint_SaveModify_Success
                                                    , result.Data.Key);
                    }
                    return(Json(rst));
                }
                return(Json(result));
            }
        }
        public async Task <ActionResult> Save(CheckSettingPointViewModel model)
        {
            using (CheckSettingPointServiceClient client = new CheckSettingPointServiceClient())
            {
                CheckSettingPoint obj = new CheckSettingPoint()
                {
                    Key = new CheckSettingPointKey()
                    {
                        CheckSettingKey = model.CheckSettingKey,
                        ItemNo          = model.ItemNo
                    },
                    CategoryName  = model.CategoryName,
                    CheckPlanName = model.CheckPlanName,
                    Status        = model.Status,
                    Editor        = User.Identity.Name,
                    EditTime      = DateTime.Now,
                    CreateTime    = DateTime.Now,
                    Creator       = User.Identity.Name
                };
                MethodReturnResult rst = await client.AddAsync(obj);

                if (rst.Code == 0)
                {
                    rst.Message = string.Format(QAMResources.StringResource.CheckSettingPoint_Save_Success
                                                , model.ItemNo);
                }
                return(Json(rst));
            }
        }
        //
        // GET: /QAM/CheckSettingPointDetail/
        public async Task <ActionResult> Index(string checksettingKey, int itemNo)
        {
            string groupName = string.Empty;

            using (CheckSettingServiceClient client = new CheckSettingServiceClient())
            {
                MethodReturnResult <CheckSetting> result = await client.GetAsync(checksettingKey ?? string.Empty);

                if (result.Code > 0 || result.Data == null)
                {
                    return(RedirectToAction("Index", "CheckSetting"));
                }
                groupName = result.Data.GroupName;
            }

            using (CheckSettingPointServiceClient client = new CheckSettingPointServiceClient())
            {
                MethodReturnResult <CheckSettingPoint> result = await client.GetAsync(new CheckSettingPointKey()
                {
                    CheckSettingKey = checksettingKey,
                    ItemNo          = itemNo
                });

                if (result.Code > 0 || result.Data == null)
                {
                    return(RedirectToAction("Index", "CheckSettingPoint"));
                }
            }

            using (CheckSettingPointDetailServiceClient client = new CheckSettingPointDetailServiceClient())
            {
                await Task.Run(() =>
                {
                    PagingConfig cfg = new PagingConfig()
                    {
                        OrderBy = "Key.ItemNo",
                        Where   = string.Format(" Key.CheckSettingKey = '{0}' AND Key.ItemNo='{1}'"
                                                , checksettingKey
                                                , itemNo)
                    };
                    MethodReturnResult <IList <CheckSettingPointDetail> > result = client.Get(ref cfg);

                    if (result.Code == 0)
                    {
                        ViewBag.PagingConfig = cfg;
                        ViewBag.List         = result.Data;
                    }
                });
            }
            return(View(new CheckSettingPointDetailQueryViewModel()
            {
                CheckSettingKey = checksettingKey, GroupName = groupName, ItemNo = itemNo
            }));
        }
        public async Task <ActionResult> Query(CheckSettingPointQueryViewModel model)
        {
            if (ModelState.IsValid)
            {
                using (CheckSettingPointServiceClient client = new CheckSettingPointServiceClient())
                {
                    await Task.Run(() =>
                    {
                        StringBuilder where = new StringBuilder();
                        if (model != null)
                        {
                            where.AppendFormat(" {0} Key.CheckSettingKey = '{1}'"
                                               , where.Length > 0 ? "AND" : string.Empty
                                               , model.CheckSettingKey);

                            if (!string.IsNullOrEmpty(model.CategoryName))
                            {
                                where.AppendFormat(" {0} CategoryName LIKE '{1}%'"
                                                   , where.Length > 0 ? "AND" : string.Empty
                                                   , model.CategoryName);
                            }
                            if (!string.IsNullOrEmpty(model.CheckPlanName))
                            {
                                where.AppendFormat(" {0} CheckPlanName LIKE '{1}%'"
                                                   , where.Length > 0 ? "AND" : string.Empty
                                                   , model.CheckPlanName);
                            }
                        }
                        PagingConfig cfg = new PagingConfig()
                        {
                            OrderBy = "Key.ItemNo",
                            Where   = where.ToString()
                        };
                        MethodReturnResult <IList <CheckSettingPoint> > result = client.Get(ref cfg);

                        if (result.Code == 0)
                        {
                            ViewBag.PagingConfig = cfg;
                            ViewBag.List         = result.Data;
                        }
                    });
                }
            }
            return(PartialView("_ListPartial"));
        }
 public ActionResult GetMaxItemNo(string checksettingKey)
 {
     using (CheckSettingPointServiceClient client = new CheckSettingPointServiceClient())
     {
         PagingConfig cfg = new PagingConfig()
         {
             PageNo   = 0,
             PageSize = 1,
             Where    = string.Format("Key.CheckSettingKey='{0}'", checksettingKey),
             OrderBy  = "Key.ItemNo Desc"
         };
         MethodReturnResult <IList <CheckSettingPoint> > result = client.Get(ref cfg);
         if (result.Code <= 0 && result.Data != null && result.Data.Count > 0)
         {
             return(Json(result.Data[0].Key.ItemNo + 1, JsonRequestBehavior.AllowGet));
         }
     }
     return(Json(1, JsonRequestBehavior.AllowGet));
 }
        public async Task <ActionResult> Delete(string checksettingKey, int itemNo)
        {
            MethodReturnResult result = new MethodReturnResult();

            using (CheckSettingPointServiceClient client = new CheckSettingPointServiceClient())
            {
                result = await client.DeleteAsync(new CheckSettingPointKey()
                {
                    CheckSettingKey = checksettingKey,
                    ItemNo          = itemNo
                });

                if (result.Code == 0)
                {
                    result.Message = string.Format(QAMResources.StringResource.CheckSettingPoint_Delete_Success
                                                   , itemNo);
                }
                return(Json(result));
            }
        }
        public async Task <ActionResult> PagingQuery(string where, string orderBy, int?currentPageNo, int?currentPageSize)
        {
            if (ModelState.IsValid)
            {
                int pageNo   = currentPageNo ?? 0;
                int pageSize = currentPageSize ?? 20;
                if (Request["PageNo"] != null)
                {
                    pageNo = Convert.ToInt32(Request["PageNo"]);
                }
                if (Request["PageSize"] != null)
                {
                    pageSize = Convert.ToInt32(Request["PageSize"]);
                }

                using (CheckSettingPointServiceClient client = new CheckSettingPointServiceClient())
                {
                    await Task.Run(() =>
                    {
                        PagingConfig cfg = new PagingConfig()
                        {
                            PageNo   = pageNo,
                            PageSize = pageSize,
                            Where    = where ?? string.Empty,
                            OrderBy  = orderBy ?? string.Empty
                        };
                        MethodReturnResult <IList <CheckSettingPoint> > result = client.Get(ref cfg);
                        if (result.Code == 0)
                        {
                            ViewBag.PagingConfig = cfg;
                            ViewBag.List         = result.Data;
                        }
                    });
                }
            }
            return(PartialView("_ListPartial"));
        }