/// <summary> /// 加载销售排行榜 /// </summary> private void LoadGoodsRank() { this.dgvGoodsRank.Rows.Clear(); bll = BLLLoader.GetReportBll(); List <ReportGoodsRank> ranks = null; try { ranks = bll.SaleGoodsRankByAll(); } catch (Exception e) { MessageBox.Show(e.Message, "数据库不可用", MessageBoxButtons.OK, MessageBoxIcon.Error); } if (ranks == null) { return; } foreach (ReportGoodsRank rank in ranks) { this.dgvGoodsRank.Rows.Add(new String[] { rank.GoodsName, rank.Price.ToString(), rank.Count.ToString() }); } }
private void loadGoods() { IGoodsBLL gbll = BLLLoader.GetGoodsBll(); goodses = gbll.GetSaleGoods(); reloadGoods(0); }
private void initBll() { catBll = BLLLoader.GetMemberCardCategoryBll(); cardBll = BLLLoader.GetMemberCardBll(); recordBll = BLLLoader.GetMemberCardRecordBll(); logBll = BLLLoader.GetSaleLogBll(); }
private void FrmAddLog_Load(object sender, EventArgs e) { bll = BLLLoader.GetSaleLogBll(); goodsbll = BLLLoader.GetGoodsBll(); List <Goods> items = goodsbll.GetAllGoods(); this.cmbGoods.DisplayMember = "Name"; this.cmbGoods.ValueMember = "Id"; this.cmbGoods.DataSource = items; }
private void FrmAdd_Load(object sender, System.EventArgs e) { categoryBll = BLLLoader.GetMemberCardCategoryBll(); cardBll = BLLLoader.GetMemberCardBll(); List <MemberCardCategory> list = categoryBll.GetAllMemberCardCategory(); this.cbxCategory.DisplayMember = "Name"; this.cbxCategory.ValueMember = "Id"; this.cbxCategory.DataSource = list; }
/// <summary> /// 加载商品类目 /// </summary> private void LoadCategories() { if (catBll == null) { catBll = BLLLoader.GetGoodsCategoryBll(); } this.cmbCategory.DisplayMember = "Name"; this.cmbCategory.ValueMember = "Id"; this.cmbCategory.DataSource = catBll.GetAllCategories(); }
/// <summary> /// 统计数据按年份分组 /// </summary> private void LoadYears() { if (bll == null) { bll = BLLLoader.GetReportBll(); } for (int year = 2014; year <= DateTime.Now.Year; year++) { TabPage page = new TabPage(String.Format("{0}年", year)); page.Controls.Add(initDataGridView(year, this.cmbCategory.DataSource as List <Models.GoodsCategory>)); this.tabYears.TabPages.Add(page); } }
/// <summary> /// 加载销售记录 /// </summary> /// <param name="begin">起始时间</param> /// <param name="end">截止时间</param> private void loadSaleLogs(DateTime begin, DateTime end) { if (saleBll == null) { saleBll = BLLLoader.GetSaleLogBll(); } List <SaleLog> result = saleBll.GetAllSaleLogsByDate(begin, end); this.dgvSalelogs.Rows.Clear(); foreach (SaleLog log in result) { this.dgvSalelogs.Rows.Add(new String[] { log.Id.ToString(), TimeStamp.ConvertIntDateTime(log.CreatedAt).ToString(), log.Summary, log.Money.ToString() }); } }
private void synData() { if (isSyn) { return; } isSyn = true; if (bll == null) { bll = BLLLoader.GetSaleLogBll(); } IniFile ini = new IniFile(Application.StartupPath + "/" + "syn.ini"); String last_id = ini.IniReadValue("data", "LastID"); int lastId = String.IsNullOrEmpty(last_id) ? 0 : Convert.ToInt32(last_id); //生成文件名 DateTime now = DateTime.Now; String fileName = String.Format("{0}/runtime/logs/{1}/{2}/{3}.log", Application.StartupPath, now.Year, now.Month, now.Day); //获取数据 List <SaleLog> logs = bll.GetSaleLogsByLastId(lastId); FileTools.Writer(fileName, String.Format("[{0}]本次共加载数据 {1} 条", DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss"), logs.Count)); for (int i = 0; i < logs.Count; i++) { switch (logs[i].GoodsId) { case 0: logs[i].GoodsId = 24; break; case -1: logs[i].GoodsId = 18; break; case -2: logs[i].GoodsId = 19; break; case -3: switch (Convert.ToInt32(logs[i].Remark)) { case 6: logs[i].GoodsId = 21; break; case 7: logs[i].GoodsId = 22; break; case 8: logs[i].GoodsId = 23; break; } break; } } if (logs.Count < 1) { return; } //添加至Mysql String result = "失败"; if (bll.AddLog(logs)) { ini.IniWriteValue("data", "LastID", logs[logs.Count - 1].Id.ToString()); result = "成功"; } //FileTools.Writer(fileName, String.Format("[{0}]同步ID为 {1} 的数据结果为:{2}", DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss"), log.Id, result)); isSyn = false; }