using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.Mvc;
using System.Collections;
using Estsh.Web.Service;
using Estsh.Web.Util;
using System.Data;
using Estsh.Web.Models;



namespace Estsh.Core.Web.Controllers
{
    public class ViewpdlineController : Controller
    {
        private ViewpdlineService service = new ViewpdlineService();



        public ActionResult index()
        {
            return View();
        }

        /// <summary>
        /// 修改数据
        /// </summary>
        /// <returns></returns>
        public ActionResult GetEditpdline()
        {
            string editType = Request["editType"].ToString();
            int userid = ((UserInfo)Session["loginedUser"]).empId;
            string pdline_id = Request["pdline_id"].ToString();

            string pdline_name = Request["pdline_name"].ToString();
            String jph_f = Request["jph_f"].ToString();
            String jph_r = Request["jph_r"].ToString();
            String kanban_ordering = Request["kanban_ordering"].ToString();

            Hashtable htParams = new Hashtable();
            htParams.Add(@"pdline_name", pdline_name);
            htParams.Add("@jph_f", jph_f);
            htParams.Add("@jph_r", jph_r);
            htParams.Add("@kanban_ordering", kanban_ordering);
            htParams.Add("@Create_userid", userid);

            String message = "";
            String flag = "";

            if (editType != null && editType.Trim().Equals("edit"))
            {
                try
                {
                    //if (this.service.IsExistOrd(kanban_ordering))
                    //{
                    //    message = "" + kanban_ordering + ":该看板排序已存在!";
                    //    flag = "Fail";
                    //}
                    //else
                    //{
                        UserInfo user = (UserInfo)Session["loginedUser"];
                        htParams.Add("@pdline_id", pdline_id);
                        htParams.Add("@update_userid", userid);
                        this.service.updateView(htParams);
                        message = "修改成功！";
                        flag = "OK";
                    //}
                }
                catch (Exception e)
                {
                    message = "修改失败！";
                    flag = "Fail";
                    throw;
                }

            }

            Hashtable result = new Hashtable();
            result.Add("message", message);
            result.Add("flag", flag);
            return Json(result);

        }

        /// <summary>
        /// 获取列表数据
        /// </summary>
        /// <param name="pdline_name"></param>
        /// <param name="jph_f"></param>
        /// <param name="jph_r"></param>
        /// <param name="kanban_ordering"></param>
        /// <param name="pager"></param>
        /// <param name="direction"></param>
        /// <param name="sort"></param>
        /// <returns></returns>
        public ActionResult getPdlineListByPage(String pdline_name, String jph_f, String jph_r, String kanban_ordering, Pager pager, String direction, String sort)
        {
            Hashtable result = new Hashtable();
            result.Add("pager.pageNo", pager.pageNo);
            Hashtable dataHt = this.service.getPdlineListByPage(pdline_name, jph_f, jph_r, kanban_ordering, pager, direction, sort);
            result.Add("rows", dataHt["dataList"]);
            result.Add("pager.totalRows", dataHt["totalCount"]);
            result.Add("sort", sort);
            result.Add("direction", direction);
            return Json(result);
        }

        /// <summary>
        /// 获取产线名称
        /// </summary>
        /// <returns></returns>
        public ActionResult GetViewPdlineName()
        {
            Hashtable reault = new Hashtable();
            ArrayList list = service.GetViewPdlineName();
            reault.Add("list", list);
            return Json(reault, JsonRequestBehavior.AllowGet);
        }


        /// <summary>
        /// 获取产线编号
        /// </summary>
        /// <returns></returns>
        public ActionResult GetViewPdlineID()
        {
            Hashtable reault = new Hashtable();
            ArrayList list = service.GetViewPdlineID();
            reault.Add("list", list);
            return Json(reault, JsonRequestBehavior.AllowGet);
        }

        /// <summary>
        /// 编辑数据
        /// </summary>
        /// <param name="pdline_id"></param>
        /// <returns></returns>
        public ActionResult editView(String pdline_id)
        {
            Hashtable ht = this.service.getViewDetail(pdline_id);
            ViewData.Add("editType", "edit");

            ViewData.Add("pdline_id", ht["pdline_id"]);
            ViewData.Add("pdline_name", ht["pdline_name"]);
            ViewData.Add("jph_f", ht["jph_f"]);
            ViewData.Add("jph_r", ht["jph_r"]);
            ViewData.Add("kanban_ordering", ht["kanban_ordering"]);
            ViewData.Add("create_ymd", ht["create_ymd"].ToString());
            ViewData.Add("create_hms", ht["create_hms"].ToString());
            ViewData.Add("create_userid", ht["create_userid"].ToString());
            return View("~/Views/ViewpdlineDefine/EditViewDefine.aspx");
        }


    }

}