private PageDAL GetPageDalInstance() { if (pageDal == null) { pageDal = new PageDAL(); } return(pageDal); }
public static void Create(PageDataModel page) { if (page.fileFeaturedImage != null) { page.FeaturedImage = FileManager.SaveFile(page.fileFeaturedImage); } if (page.fileMainImage != null) { page.MainImage = FileManager.SaveFile(page.fileMainImage); } PageDAL.Create(page); }
public Page PageUpdateYear(int pageID, string year, int userID) { PageDAL dal = new PageDAL(); Page storedPage = dal.PageSelectAuto(null, null, pageID); if (storedPage != null) { storedPage.Year = year; storedPage.PaginationUserID = userID; storedPage.PaginationDate = DateTime.Now; storedPage = dal.PageUpdateAuto(null, null, storedPage); } else { throw new Exception("Could not find existing page record"); } return(storedPage); }
public static void Update(PageDataModel page) { if (page.ID > 0) { if (page.fileFeaturedImage != null) { page.FeaturedImage = FileManager.SaveFile(page.fileFeaturedImage); } if (page.fileMainImage != null) { page.MainImage = FileManager.SaveFile(page.fileMainImage); } PageDAL.Update(page); } else { throw new Exception("Page not found"); } }
private void of_bindGetmain() { int li_PageIndex = 1; try { li_PageIndex = Convert.ToInt32(Lbl_PageIndex.Text); } catch { } PageInfo Page = new PageInfo(); Page.IPage = li_PageIndex; Page.IPageSize = gi_PageSize; Page.StrIndex = "getmain.orderno"; Page.StrOrder = "getmain.getorderdate desc"; Page.StrTable = "getmain,(select orderno,sum(num*price) as totalmoney from getdetail group by orderno) as getdetail"; Page.StrText = "getmain.orderno,getorderdate,isorder,orderstatus," + "getdetail.totalmoney,memo,checkman, " + "(select settle from settlekind where settlekind.settlekind=getmain.settlekind) as settle "; Page.StrWhere = "and getmain.orderno =getdetail.orderno " + "and ( isnull(getmain.islogout,'n')='n') " + "and getmain.cus_code=@cus_code " + "and totalmoney is not null"; List <GysoftParameter> ll_Pa = new List <GysoftParameter>(); GysoftParameter Pa1 = new GysoftParameter("@cus_code", as_Cus_Code); ll_Pa.Add(Pa1); #region 订单查询最小日期限制 //DateTime ld_OrderBeginDate = DateTime.MinValue; //try //{ // string ls_OrderBeginDate = publicfuns.of_GetMySysSet("商城参数" + WebSet.os_WebHost, "OrderBeginDate"); // if (ls_OrderBeginDate != "") // { // int li_OrderBeginDate = Convert.ToInt32(ls_OrderBeginDate); // if (li_OrderBeginDate > 0) // { // Lbl_DateMessage.Text = "只能查询 " + li_OrderBeginDate + "天前的订单"; // ld_OrderBeginDate = DateTime.Now.AddDays(0 - li_OrderBeginDate); // } // } //} //catch { } //if (Txt_TimeBegin.Text.Trim() == "") //{ // if (ld_OrderBeginDate <= DateTime.Now.AddMonths(-3)) // { // ld_OrderBeginDate = DateTime.Now.AddMonths(-3); // } // Txt_TimeBegin.Text = ld_OrderBeginDate.ToString("yyyy-MM-dd"); //} //else //{ // try // { // DateTime ld_Time = Convert.ToDateTime(Txt_TimeBegin.Text.Trim()); // if (ld_Time >= ld_OrderBeginDate) // { ld_OrderBeginDate = ld_Time; } // else // { // ClientScript.RegisterClientScriptBlock(this.GetType(), "", "alert('请输入正确的开始时间')", true); // return; // } // } // catch // { // ClientScript.RegisterClientScriptBlock(this.GetType(), "", "alert('请输入正确的开始时间')", true); // return; // } //} //Page.StrWhere += " and getorderdate>=@begionTime "; //ll_Pa.Add(new GysoftParameter("@begionTime", ld_OrderBeginDate)); #endregion if (Txt_TimeBegin.Text.Trim() != "") { DateTime ld_TimeEnd; try { ld_TimeEnd = Convert.ToDateTime(Txt_TimeBegin.Text.Trim()); } catch { ClientScript.RegisterClientScriptBlock(this.GetType(), "", "alert('请输入正确的开始时间')", true); return; } Page.StrWhere += " and getorderdate>=@begionTime "; GysoftParameter Pa = new GysoftParameter("@begionTime", ld_TimeEnd); ll_Pa.Add(Pa); } if (Txt_TimeEnd.Text.Trim() != "") { DateTime ld_TimeEnd; try { ld_TimeEnd = Convert.ToDateTime(Txt_TimeEnd.Text.Trim()); } catch { ClientScript.RegisterClientScriptBlock(this.GetType(), "", "alert('请输入正确的结束时间')", true); return; } Page.StrWhere += " and getorderdate<@TimeEnd "; GysoftParameter Pa = new GysoftParameter("@TimeEnd", ld_TimeEnd); ll_Pa.Add(Pa); } int Count = 0; DataTable dt = PageDAL.Page(Page, GysoftParameter.ChangeParameter(ll_Pa), out Count); if (Count % gi_PageSize != 0) { Lbl_PageCount.Text = ((Count / gi_PageSize) + 1).ToString(); } else { Lbl_PageCount.Text = (Count / gi_PageSize).ToString(); } GV_Getmain.DataSource = dt; GV_Getmain.DataBind(); }
public static PageDataModel Get(int id) { return(PageDAL.Get(id)); }
public static List <PageDataModel> GetAll() { return(PageDAL.GetAll()); }
public static List <PageDataModel> GetBlogPages() { return(PageDAL.GetBlogPages()); }
private void of_bindOutOne() { int li_PageIndex = 1; try { li_PageIndex = Convert.ToInt32(Lbl_PageIndex.Text); } catch { } PageInfo Page = new PageInfo(); Page.IPage = li_PageIndex; Page.IPageSize = gi_PageSize; Page.StrIndex = "outone.out_no"; Page.StrOrder = "outone.out_date desc"; Page.StrTable = "outone,customer,outtraffic"; Page.StrText = "outone.out_no,outone.out_date,outone.human," + "outone.remark,outone.haveout,outone.discountrate,outone.haveoutstock," + "outone.saleman,outone.haveoutstock,outone.stockcode,outone.settlekind," + "isnull(outtraffic.trafficmemo,'')+isnull(outtraffic.address,'') as trafficmemo," + "outone.trafficno,outone.sendNO,outone.driverman,outone.driverdate"; Page.StrWhere = "and outone.cus_code = customer.cus_code " + "and outone.out_no=outtraffic.out_no " + "and outone.cus_code=@cus_code"; List <GysoftParameter> ll_Pa = new List <GysoftParameter>(); GysoftParameter Pa1 = new GysoftParameter("@cus_code", as_Cus_code); ll_Pa.Add(Pa1); DateTime ld_TimeBegin = Convert.ToDateTime("1900-01-01"); if (Txt_TimeBegin.Text.Trim() != "") { try { ld_TimeBegin = Convert.ToDateTime(Txt_TimeBegin.Text.Trim()); } catch { ClientScript.RegisterClientScriptBlock(this.GetType(), "", "alert('请输入正确的开始时间')", true); return; } Page.StrWhere += " and outone.out_date>=@TimeBegin "; GysoftParameter Pa = new GysoftParameter("@TimeBegin", ld_TimeBegin); ll_Pa.Add(Pa); } if (Txt_TimeEnd.Text.Trim() != "") { DateTime ld_TimeEnd; try { ld_TimeEnd = Convert.ToDateTime(Txt_TimeEnd.Text.Trim()); } catch { ClientScript.RegisterClientScriptBlock(this.GetType(), "", "alert('请输入正确的结束时间')", true); return; } Page.StrWhere += " and outone.out_date<@TimeEnd "; GysoftParameter Pa = new GysoftParameter("@TimeEnd", ld_TimeEnd); ll_Pa.Add(Pa); } int Count = 0; DataTable dt = PageDAL.Page(Page, GysoftParameter.ChangeParameter(ll_Pa), out Count); if (Count % gi_PageSize != 0) { Lbl_PageCount.Text = ((Count / gi_PageSize) + 1).ToString(); } else { Lbl_PageCount.Text = (Count / gi_PageSize).ToString(); } GV_OutOne.DataSource = dt; GV_OutOne.DataBind(); }
public PageService(IServiceProvider service) { _pageDAL = service.GetService <PageDAL>(); }