public ActionResult Index() { ViewBag.IsFirstPage = true; ViewBag.BodyClass = "index"; ViewBag.Cur = new string[] { "", "", "", "", "", "", "", "", "", "", "" }; #region getSid Int a_ProductKind c = new a_ProductKind() { Connection = getSQLConnection(), logPlamInfo = plamInfo }; RunQueryPackage <m_ProductKind> hResult = c.SearchMaster(new q_ProductKind() { s_Series = 12 }, 1); //get 新進商品 int[] s_kinds = hResult.SearchData.Select(x => x.ID).ToArray(); #endregion a_ProductData t = new a_ProductData() { Connection = getSQLConnection(), logPlamInfo = plamInfo }; RunQueryPackage <m_ProductData> r = t.SearchMaster(new q_ProductData() { s_IsSecond = true, s_IsOpen = true, s_Kinds = s_kinds }, 1); return(View(r.SearchData.AsEnumerable())); }
public ActionResult Products_new3(int id, int?sid) { a_ProductData b = new a_ProductData() { Connection = getSQLConnection(), logPlamInfo = plamInfo }; //資料庫連線,取得登入者資訊 var a = b.GetDataMaster(id, 0); //取得kind的值 a_ProductKind t = new a_ProductKind() { Connection = getSQLConnection(), logPlamInfo = plamInfo }; RunQueryPackage <m_ProductKind> r = t.SearchMaster(new q_ProductKind() { s_ID = a.SearchData.Kind }, 1); var tmp = r.SearchData.FirstOrDefault().Name; ViewBag.kind = tmp;//放進viewbag裡 ViewBag.BodyClass = "Products new"; ViewBag.Cur = new string[] { "", "", "", "", "", "", "", "", "", "", "", "" }; String[] Series = { "", "屏風系列", "辦公桌系列", "會議桌系列", "檔案櫃系列", "主管辦公桌系列", "辦公椅系列", "沙發系列", "", "", "其他商品", "造型椅 / 吧檯椅" }; if (sid == null) { sid = 1; } ViewBag.Cur[Convert.ToInt32(sid)] = "current"; ViewBag.Nur = Convert.ToInt32(sid); ViewBag.Series = Series[Convert.ToInt32(sid)]; return(View(a.SearchData)); }
public override ActionResult EditMasterDataByID(int id) { #region GetKinds //gg a_ProductKind c = new a_ProductKind() { Connection = getSQLConnection(), logPlamInfo = plamInfo }; RunQueryPackage <m_ProductKind> hResult = c.SearchMaster(new q_ProductKind(), LoginUserId); HandleResultCheck(hResult); List <SelectListItem> New_Kinds = new List <SelectListItem>(); List <SelectListItem> Second_Kinds = new List <SelectListItem>(); #endregion operationMode = OperationMode.EditModify; ac = new a_ProductData() { Connection = getSQLConnection(), logPlamInfo = plamInfo }; RunOneDataEnd <m_ProductData> HResult = ac.GetDataMaster(id, LoginUserId); md = HResult.SearchData; int sid = hResult.SearchData.Where(m_ProductData => m_ProductData.ID == md.Kind).First().Series; foreach (var item in hResult.SearchData.Where(x => x.Series == sid)) { if (item.IsSecond == true) { Second_Kinds.Add(new SelectListItem() { Text = item.Name, Value = item.ID.ToString() }); } else { New_Kinds.Add(new SelectListItem() { Text = item.Name, Value = item.ID.ToString() }); } } ViewBag.NewKind_Option = New_Kinds; ViewBag.SecondKind_Option = Second_Kinds; md.Series = sid; md.EditType = EditModeType.Modify; HandleResultCheck(HResult); HandleCollectDataToOptions(); ViewBag.Caption = GetSystemInfo().prog_name; HandleRequest HRq = new HandleRequest(); //記錄QueryString HRq.Remove("id"); //不需記ID ViewBag.QueryString = HRq.ToQueryString(); ViewBag.id = id; HRq = null; return(View("EditData", md)); }
public ActionResult Products_second(int?sid, int?page) { if (sid == null) { sid = 1; } //if (Convert.ToInt32(sid) == 0 || Convert.ToInt32(sid) == 8 || Convert.ToInt32(sid) == 9) { return RedirectToAction("Products_second2", "Products", new { sid = sid }); } if (Convert.ToInt32(sid) == 9) { return(RedirectToAction("Products_second2", "Products", new { sid = sid })); } ViewBag.BodyClass = "Products second"; ViewBag.Cur = new string[] { "", "", "", "", "", "", "", "", "", "", "", "", "", "" }; String[] Series = { "新進商品", "屏風系列", "辦公桌系列", "會議桌系列", "檔案櫃系列", "主管辦公桌系列", "辦公椅系列", "沙發系列", "特價系列", "規劃樣品展示", "其他商品", "造型椅 / 吧檯椅", "新進商品", "特價商品" }; ViewBag.Cur[Convert.ToInt32(sid)] = "current"; ViewBag.Nur = Convert.ToInt32(sid); ViewBag.Series = Series[Convert.ToInt32(sid)]; a_ProductKind t = new a_ProductKind() { Connection = getSQLConnection(), logPlamInfo = plamInfo }; RunQueryPackage <m_ProductKind> r = t.SearchMaster(new q_ProductKind() { s_IsOpen = true, s_Series = sid, s_IsSecond = true }, 1); page = page == null ? 1 : page; int totalpage = r.SearchData.Count() / 9; int mod = r.SearchData.Count() % 9; if (mod != 0) { totalpage++; } int getTotalPage = totalpage; var getProduct = r.SearchData.Skip(9 * ((int)page - 1)).Take(9); ViewBag.nextPage = getTotalPage > page ? page + 1 : page; ViewBag.prvePage = page <= 1 ? 1 : page - 1; if (r.SearchData.Count() >= 1 && r.SearchData.Count() <= 9) { ViewBag.totalPage = 1; } else { ViewBag.totalPage = getTotalPage; } ViewBag.page = page; ViewBag.sid = sid; return(View(getProduct)); }
public override ActionResult EditMasterNewData() { #region GetKinds //gg a_ProductKind c = new a_ProductKind() { Connection = getSQLConnection(), logPlamInfo = plamInfo }; RunQueryPackage <m_ProductKind> hResult = c.SearchMaster(new q_ProductKind(), LoginUserId); HandleResultCheck(hResult); List <SelectListItem> All_Kinds = new List <SelectListItem>(); List <SelectListItem> New_Kinds = new List <SelectListItem>(); List <SelectListItem> Second_Kinds = new List <SelectListItem>(); foreach (var item in hResult.SearchData.Where(x => x.Series == 12))//預設為 新進商品 SID=12 { All_Kinds.Add(new SelectListItem() { Text = item.Name, Value = item.ID.ToString() }); if (item.IsSecond == true) { Second_Kinds.Add(new SelectListItem() { Text = item.Name, Value = item.ID.ToString() }); } else { New_Kinds.Add(new SelectListItem() { Text = item.Name, Value = item.ID.ToString() }); } } ViewBag.NewKind_Option = New_Kinds; ViewBag.SecondKind_Option = Second_Kinds; ViewBag.AllKind_Option = All_Kinds; #endregion operationMode = OperationMode.EditInsert; HandleCollectDataToOptions(); ViewBag.Caption = GetSystemInfo().prog_name; HandleRequest HRq = new HandleRequest(); //記錄QueryString HRq.Remove("Id"); //不需記ID ViewBag.QueryString = HRq.ToQueryString(); HRq = null; ac = new a_ProductData() { Connection = getSQLConnection(), logPlamInfo = plamInfo }; return(View("EditData", new m_ProductData() { ID = ac.GetIDX(), IsSecond = true, EditType = EditModeType.Insert, IsOpen = true })); }
public override ActionResult ListGrid(q_ProductData sh) { #region GetKinds //gg a_ProductKind c = new a_ProductKind() { Connection = getSQLConnection(), logPlamInfo = plamInfo }; RunQueryPackage <m_ProductKind> hResult = c.SearchMaster(new q_ProductKind(), LoginUserId); HandleResultCheck(hResult); List <SelectListItem> All_Kinds = new List <SelectListItem>(); List <SelectListItem> New_Kinds = new List <SelectListItem>(); List <SelectListItem> Second_Kinds = new List <SelectListItem>(); Second_Kinds.Add(new SelectListItem() { Text = "不分類", Value = null }); New_Kinds.Add(new SelectListItem() { Text = "不分類", Value = null }); foreach (var item in hResult.SearchData) { All_Kinds.Add(new SelectListItem() { Text = item.Name, Value = item.ID.ToString() }); if (item.IsSecond == true) { Second_Kinds.Add(new SelectListItem() { Text = item.Name, Value = item.ID.ToString() }); } else { New_Kinds.Add(new SelectListItem() { Text = item.Name, Value = item.ID.ToString() }); } } ViewBag.NewKind_Option = New_Kinds; ViewBag.SecondKind_Option = Second_Kinds; #endregion operationMode = OperationMode.EnterList; HandleRequest HRq = new HandleRequest(); //記錄QueryString HRq.encodeURIComponent = true; HRq.Remove("page"); ViewBag.Page = QueryGridPage(); ViewBag.Caption = GetSystemInfo().prog_name; ViewBag.AppendQuertString = HRq.ToQueryString(); HRq = null; return(View("ListData", sh)); }
public override String ajax_MasterGridData(q_Users queryObj) { #region 連接BusinessLogicLibary資料庫並取得資料 ac = new a_Users() { Connection = getSQLConnection() }; RunQueryPackage <m_Users> HResult = ac.SearchMaster(queryObj, LoginUserId); HandleResultCheck(HResult); #endregion #region 設定 Page物件 頁數 總筆數 每頁筆數 int page = (queryObj.page == null ? 1 : queryObj.page.CInt()); int startRecord = PageCount.PageInfo(page, this.DefPageSize, HResult.Count); #endregion #region 每行及每個欄位資料組成 List <RowElement> setRowElement = new List <RowElement>(); var Modules = HResult.SearchData.Skip(startRecord).Take(this.DefPageSize); UnitData unit = new UnitData(); var dic = unit.CollectIdNameFields(x => x.id, x => x.name, getSQLConnection()); foreach (m_Users md in Modules) { List <String> setFields = new List <String>(5); setFields.Add(md.id.ToString()); setFields.Add(md.account); setFields.Add(md.unit.TableCodeValue(dic)); setFields.Add(md.state.CodeValue(CodeSheet.使用者狀態.MakeCodes())); setFields.Add(md.isadmin.BooleanValue(BooleanSheet.ynv)); setRowElement.Add(new RowElement() { id = md.id.ToString(), cell = setFields.ToArray() }); } #endregion #region 回傳JSON資料 JQGridDataObject dataObj = new JQGridDataObject() { rows = setRowElement.ToArray(), total = PageCount.TotalPage, page = PageCount.Page, records = PageCount.RecordCount }; return(JsonConvert.SerializeObject(dataObj, new JsonSerializerSettings() { NullValueHandling = NullValueHandling.Ignore })); #endregion }
public override String ajax_MasterGridData(q_ProductKind queryObj) { #region 連接BusinessLogicLibary資料庫並取得資料 ac = new a_ProductKind() { Connection = getSQLConnection(), logPlamInfo = plamInfo };; RunQueryPackage <m_ProductKind> HResult = ac.SearchMaster(queryObj, LoginUserId); HandleResultCheck(HResult); #endregion #region 設定 Page物件 頁數 總筆數 每頁筆數 int page = (queryObj.page == null ? 1 : queryObj.page.CInt()); int startRecord = PageCount.PageInfo(page, this.DefPageSize, HResult.Count); #endregion #region 每行及每個欄位資料組成 List <RowElement> setRowElement = new List <RowElement>(); var Modules = HResult.SearchData.Skip(startRecord).Take(this.DefPageSize); var Series = new String[] { "", "屏風系列", "辦公桌系列", "會議桌系列", "檔案櫃系列", "主管辦公桌系列", "辦公椅系列", "沙發系列", "", "", "其他商品", "造型椅 / 吧檯椅", "新進商品", "特價商品" }; foreach (m_ProductKind md in Modules) { List <String> setFields = new List <String>(6); setFields.Add(md.ID.ToString()); setFields.Add(Series[md.Series]); setFields.Add(md.Name); setFields.Add(md.IsOpen.BooleanValue(BooleanSheet.yn)); setFields.Add(md.IsSecond.BooleanValue("二手", "全新")); setFields.Add(md.Sort.ToString()); setRowElement.Add(new RowElement() { id = md.ID.ToString(), cell = setFields.ToArray() }); } #endregion #region 回傳JSON資料 return(JsonConvert.SerializeObject(new JQGridDataObject() { rows = setRowElement.ToArray(), total = PageCount.TotalPage, page = PageCount.Page, records = PageCount.RecordCount }, new JsonSerializerSettings() { NullValueHandling = NullValueHandling.Ignore })); #endregion }
public override String ajax_MasterSubGridData(q__CodeSheet queryObj) { #region 連接BusinessLogicLibary資料庫並取得資料 acd = new a__CodeSheet() { Connection = getSQLConnection(), logPlamInfo = plamInfo };; RunQueryPackage <m__CodeSheet> HResult = acd.SearchMaster(queryObj, LoginUserId); HandleResultCheck(HResult); #endregion #region 設定 Page物件 頁數 總筆數 每頁筆數 int page = (queryObj.page == null ? 1 : queryObj.page.CInt()); int startRecord = PageCount.PageInfo(page, this.DefPageSize, HResult.Count); #endregion #region 每行及每個欄位資料組成 List <RowElement> setRowElement = new List <RowElement>(); var Modules = HResult.SearchData.Skip(startRecord).Take(this.DefPageSize); foreach (m__CodeSheet md in Modules) { List <String> setFields = new List <String>(); setFields.Add(md.id.ToString()); setFields.Add(md.Code); setFields.Add(md.Value); setFields.Add(md.Memo); setFields.Add(md.Sort.ToString()); setFields.Add(md.IsUse.BooleanValue(BooleanSheet.ynv)); setFields.Add(md.CodeHeadId.ToString()); setRowElement.Add(new RowElement() { id = md.id.ToString(), cell = setFields.ToArray() }); } #endregion #region 回傳JSON資料 JQGridDataObject dataObj = new JQGridDataObject() { rows = setRowElement.ToArray(), total = PageCount.TotalPage, page = PageCount.Page, records = PageCount.RecordCount }; JavaScriptSerializer js = new JavaScriptSerializer() { MaxJsonLength = 65536 }; //64K return(js.Serialize(dataObj)); #endregion }
public override String ajax_MasterGridData(q_ProgData queryObj) { #region 連接BusinessLogicLibary資料庫並取得資料 ac = new a_ProgData(); ac.Connection = this.getSQLConnection(); RunQueryPackage <m_ProgData> HResult = ac.SearchMasterLVL1(LoginUserId); HandleResultCheck(HResult); #endregion #region 設定 Page物件 頁數 總筆數 每頁筆數 //int page = (queryObj.page == null ? 1 : queryObj.page.CInt()); //int startRecord = PageCount.PageInfo(page, this.DefPageSize, HResult.Count); #endregion #region 組成資料 List <RowElement> setRowElement = new List <RowElement>(); m_ProgData[] drDataCollect = HResult.SearchData; foreach (m_ProgData dr in drDataCollect) { List <String> setFields = new List <String>(); setFields.Add(dr.id.ToString()); setFields.Add(dr.prog_name); setFields.Add(dr.area); setFields.Add(dr.controller); setFields.Add(dr.action); setFields.Add(dr.sort); setFields.Add(dr.isfolder.BooleanValue(BooleanSheet.ynvx)); setRowElement.Add(new RowElement() { id = dr.id.ToString(), cell = setFields.ToArray() }); } #endregion #region 回傳JSON資料 JQGridDataObject dataObj = new JQGridDataObject() { rows = setRowElement.ToArray(), total = 1, page = 1, records = PageCount.RecordCount }; JavaScriptSerializer js = new JavaScriptSerializer() { MaxJsonLength = 65536 }; //64K return(js.Serialize(dataObj)); #endregion }
public override String ajax_MasterGridData(q_Document queryObj) { #region 連接BusinessLogicLibary資料庫並取得資料 ac = new a_Document() { Connection = getSQLConnection(), logPlamInfo = plamInfo };; RunQueryPackage <m_Document> HResult = ac.SearchMaster(queryObj, LoginUserId); HandleResultCheck(HResult); #endregion #region 設定 Page物件 頁數 總筆數 每頁筆數 int page = (queryObj.page == null ? 1 : queryObj.page.CInt()); int startRecord = PageCount.PageInfo(page, this.DefPageSize, HResult.Count); #endregion #region 每行及每個欄位資料組成 List <RowElement> setRowElement = new List <RowElement>(); var Modules = HResult.SearchData.Skip(startRecord).Take(this.DefPageSize); foreach (m_Document md in Modules) { List <String> setFields = new List <String>(); setFields.Add(md.id.ToString()); setFields.Add(md.title); setFields.Add(md.set_date.ToStandardDate()); setFields.Add(md.isopen.BooleanValue(BooleanSheet.ynvx)); setRowElement.Add(new RowElement() { id = md.id.ToString(), cell = setFields.ToArray() }); } #endregion #region 回傳JSON資料 return(JsonConvert.SerializeObject(new JQGridDataObject() { rows = setRowElement.ToArray(), total = PageCount.TotalPage, page = PageCount.Page, records = PageCount.RecordCount }, new JsonSerializerSettings() { NullValueHandling = NullValueHandling.Ignore })); #endregion }
public override string ajax_MasterGridData(q_Unit queryObj) { #region 連接BusinessLogicLibary資料庫並取得資料 ac = new a_Unit(); ac.Connection = this.getSQLConnection(); RunQueryPackage <m_Unit> HResult = ac.SearchMaster(queryObj, LoginUserId); HandleResultCheck(HResult); #endregion #region 設定 Page物件 頁數 總筆數 每頁筆數 int page = (queryObj.page == null ? 1 : queryObj.page.CInt()); int startRecord = PageCount.PageInfo(page, this.DefPageSize, HResult.Count); #endregion #region 組成資料 List <RowElement> setRowElement = new List <RowElement>(); var drDataCollect = HResult.SearchData.Skip(startRecord).Take(this.DefPageSize); this.Tab = new UnitData(); foreach (var dr in drDataCollect) { RowElement GridRow = new RowElement() { id = dr.id.ToString(), cell = new String[3] }; GridRow.cell[0] = dr.id.ToString(); GridRow.cell[1] = dr.name; GridRow.cell[2] = dr.sort.ToString(); setRowElement.Add(GridRow); } #endregion #region 回傳JSON資料 JQGridDataObject dataObj = new JQGridDataObject() { rows = setRowElement.ToArray(), total = PageCount.TotalPage, page = PageCount.Page, records = PageCount.RecordCount }; return(JsonConvert.SerializeObject(dataObj, new JsonSerializerSettings() { NullValueHandling = NullValueHandling.Ignore })); #endregion }
public string getOption(int sid, bool is_second) { #region GetKinds //gg a_ProductKind c = new a_ProductKind() { Connection = getSQLConnection(), logPlamInfo = plamInfo }; RunQueryPackage <m_ProductKind> hResult = c.SearchMaster(new q_ProductKind(), LoginUserId); HandleResultCheck(hResult); List <SelectListItem> New_Kinds = new List <SelectListItem>(); List <SelectListItem> Second_Kinds = new List <SelectListItem>(); #endregion foreach (var item in hResult.SearchData.Where(x => x.Series == sid)) { if (item.IsSecond == true) { Second_Kinds.Add(new SelectListItem() { Text = item.Name, Value = item.ID.ToString() }); } else { New_Kinds.Add(new SelectListItem() { Text = item.Name, Value = item.ID.ToString() }); } } string getjson = string.Empty; if (is_second) { getjson = JsonConvert.SerializeObject(Second_Kinds); } else { getjson = JsonConvert.SerializeObject(New_Kinds); } return(getjson); }
public ActionResult Index() { Session["MenuHtmlString"] = null; a__Lang ac = new a__Lang() { Connection = getSQLConnection(), logPlamInfo = new ProcCore.Log.LogPlamInfo() { UserId = 0, AllowWrite = true, BroswerInfo = System.Web.HttpContext.Current.Request.Browser.Browser + "." + System.Web.HttpContext.Current.Request.Browser.Version, IP = System.Web.HttpContext.Current.Request.UserHostAddress } }; RunQueryPackage <m__Lang> r = ac.SearchMaster(new q__Lang() { s_isuse = true }, 0); List <SelectListItem> p = new List <SelectListItem>(); foreach (var opt in r.SearchData) { p.Add(new SelectListItem() { Value = opt.lang, Text = opt.area }); } ViewBag.Lang_Option = p; ViewData["username"] = ""; ViewData["password"] = ""; #if DEBUG ViewData["username"] = CommWebSetup.AutoLoginUser; ViewData["password"] = CommWebSetup.AutoLoginPassword; #endif return(View()); }
public ActionResult Products_new2(int?sid, int?kid, int?page) { ViewBag.BodyClass = "Products new"; ViewBag.Cur = new string[] { "", "", "", "", "", "", "", "", "", "", "", "" }; String[] Series = { "", "屏風系列", "辦公桌系列", "會議桌系列", "檔案櫃系列", "主管辦公桌系列", "辦公椅系列", "沙發系列", "", "", "其他商品", "造型椅 / 吧檯椅" }; if (sid == null) { sid = 1; } ViewBag.Cur[Convert.ToInt32(sid)] = "current"; ViewBag.Nur = Convert.ToInt32(sid); ViewBag.Series = Series[Convert.ToInt32(sid)]; a_ProductKind t = new a_ProductKind() { Connection = getSQLConnection(), logPlamInfo = plamInfo }; RunQueryPackage <m_ProductKind> r = t.SearchMaster(new q_ProductKind() { s_ID = kid }, 1); ViewBag.kind = r.SearchData.First().Name; a_ProductData p = new a_ProductData() { Connection = getSQLConnection(), logPlamInfo = plamInfo }; RunQueryPackage <m_ProductData> pr = p.SearchMaster(new q_ProductData() { s_IsOpen = true, s_IsSecond = false, s_Kind = kid }, 1); if (pr.SearchData.Any()) { int?kind_id = r.SearchData.First().ID; var getid = p.SearchMaster(new q_ProductData() { s_Kind = kind_id }, 0); if (pr.SearchData.Count() == 1 && getid.SearchData.Any()) { //如果此種類(kid)只有一項就直接跳到product_second3去顯示 int id = getid.SearchData.First().ID; Response.Redirect("~/Products/Products_new3/" + id + "?sid=" + sid); } } page = page == null ? 1 : page; int totalpage = pr.SearchData.Count() / 9; int mod = pr.SearchData.Count() % 9; if (mod != 0) { totalpage++; } int getTotalPage = totalpage; var getProduct = pr.SearchData.Skip(9 * ((int)page - 1)).Take(9); ViewBag.nextPage = getTotalPage > page ? page + 1 : page; ViewBag.prvePage = page <= 1 ? 1 : page - 1; if (r.SearchData.Count() >= 1 && r.SearchData.Count() <= 9) { ViewBag.totalPage = 1; } else { ViewBag.totalPage = getTotalPage; } ViewBag.page = page; ViewBag.sid = sid; return(View(getProduct.AsEnumerable())); }