public Permissoes() { InitializeComponent(); this.Dock = DockStyle.Fill; DataTable tbUsuarios = new SysUserDao().select(); DataTable tbGrupos = new UserGroupDao().select(); DataTable tbRelatorios = new ReportDao().select(); addOpcaoTodos(tbUsuarios, SysUserDao.DisplayMember, SysUserDao.ValueMember); addOpcaoTodos(tbGrupos, UserGroupDao.DisplayMember, UserGroupDao.ValueMember); addOpcaoTodos(tbRelatorios, ReportDao.DisplayMember, ReportDao.ValueMember); //Listando todos os usuários cmbUsuarios.DisplayMember = SysUserDao.DisplayMember; cmbUsuarios.ValueMember = SysUserDao.ValueMember; cmbUsuarios.DataSource = tbUsuarios; //Listando todos os Grupos de Usuários cmbGrupo.DisplayMember = UserGroupDao.DisplayMember; cmbGrupo.ValueMember = UserGroupDao.ValueMember; cmbGrupo.DataSource = tbGrupos; //Listando todos os relatórios cmbRelUsu.DisplayMember = ReportDao.DisplayMember; cmbRelUsu.ValueMember = ReportDao.ValueMember; cmbRelUsu.DataSource = tbRelatorios; cmbRelGrupo.DisplayMember = ReportDao.DisplayMember; cmbRelGrupo.ValueMember = ReportDao.ValueMember; cmbRelGrupo.DataSource = tbRelatorios; }
//private void BindStateRegion() //{ // ddlProvince.DataSource = _presenter.GetProvinces(); // ddlProvince.DataBind(); //} //protected void BindFacilityType(string value) //{ // ddlFacilityType.DataSource = _presenter.GetFacilityTypeByFacilityType2(value); // ddlFacilityType.DataBind(); //} //protected void BindLaboratories() //{ // //ddlLab.DataSource = _presenter.GetLaboratories(); // //ddlLab.DataBind(); // if (CurrentUser.AppUserRoles[0].Role.Name == "Administrator") // { // ddlLab.DataSource = _presenter.GetLaboratories(); // ddlLab.DataValueField = "LabCode"; // ddlLab.DataTextField = "Description"; // ddlLab.DataBind(); // } // else // { // ReportDao dao = new ReportDao(); // DataSet infoDS = dao.GetUserLocationsInfo(CurrentUser.Id); // DataTable table = infoDS.Tables[0]; // ddlLab.DataSource = table; // ddlLab.DataValueField = "LabCode"; // ddlLab.DataTextField = "LaboratoryName"; // ddlLab.DataBind(); // } //} protected void BindLaboratories() { //ddlLab.DataSource = _presenter.GetLaboratories(); //ddlLab.DataBind(); if (CurrentUser.AppUserRoles[0].Role.Name == "Administrator" || CurrentUser.AppUserRoles[0].Role.Name == "SuperUser") { ddlLab.DataSource = _presenter.GetLaboratories(); ddlLab.DataValueField = "LabCode"; ddlLab.DataTextField = "Description"; ddlLab.DataBind(); } else { ReportDao dao = new ReportDao(); DataSet infoDS = dao.GetUserLocationsInfo(CurrentUser.Id); DataTable table = infoDS.Tables[0]; ddlLab.DataSource = table; ddlLab.DataValueField = "LabCode"; ddlLab.DataTextField = "LaboratoryName"; ddlLab.DataBind(); } }
private void BindLocation() { if (CurrentUser.AppUserRoles[0].Role.Name == "Administrator") { ddlLocation.DataSource = _presenter.GetProvinces(); ddlLocation.DataBind(); } else { ReportDao dao = new ReportDao(); DataSet infoDS = dao.GetUserLocationsInfo(CurrentUser.Id); DataTable table = infoDS.Tables[0]; var distinctValues = table.AsEnumerable() .Select(row => new { attrib_name1 = row.Field <int>("ProvinceId"), attrib_name2 = row.Field <string>("ProvinceName") }) .Distinct(); DataTable dt = new DataTable("Location"); dt.Columns.Add("ProvinceId"); dt.Columns.Add("ProvinceName"); foreach (var row in distinctValues) { ddlLocation.Items.Add(new ListItem(row.attrib_name2, row.attrib_name1.ToString())); } } }
private void BindUserInfo() { dao = new ReportDao(); DataSet infoDS = dao.GetUserLocationsInfo(CurrentUser.Id); DataTable table = infoDS.Tables[0]; DataView dview = new DataView(table); dview.Sort = "FacilityName"; // for descending "FacilityName DESC" table = dview.ToTable(); for (int i = 0; i < table.Rows.Count; i++) { //lbllocation.Text = table.Rows[0]["LaboratoryName"].ToString(); LinkButton hyp = new LinkButton(); hyp.ID = "hyp" + table.Rows[i]["FacilityId"].ToString(); //hyp.NavigateUrl = ""; hyp.Text = table.Rows[i]["FacilityName"].ToString(); hyp.ToolTip = table.Rows[i]["FacilityName"].ToString(); hyp.CssClass = "btn btn-info"; //hyp.CssClass = "btn btn-link"; hyp.Style.Add("margin-right", "5px"); hyp.Style.Add("margin-bottom", "2px"); //hyp.Target = "_new"; //hyp.Click += (hypFacility_Click); //plhFacilities.Controls.Add(hyp); } }
// GET: Report public ActionResult Index() { var dao = new ReportDao(); IList <ReportDao.UsekOddeleniWithCount> useky = dao.GetLopCounts(ReportDao.StavUkolu.Vsechny, ReportDao.Tabulka.Lop); return(View(useky)); }
public ActionResult Index() { var model = new ReportDao().Report_all(); ViewBag.ImportReport = TempData["import_report"]; ViewBag.SellingReport = TempData["selling_report"]; return(View(model)); }
public ActionResult SellingReport() { DateTime start_date = DateTime.Parse(Request.Form["SellingStartDate"].ToString()); DateTime end_date = DateTime.Parse(Request.Form["SellingEndDate"].ToString()); var selling_report = new ReportDao(); TempData["selling_report"] = selling_report.Selling_Report(start_date, end_date); return(RedirectToAction("Index", "Report")); }
public ActionResult ImportReport() { DateTime start_date = DateTime.Parse(Request.Form["ImportStartDate"].ToString()); DateTime end_date = DateTime.Parse(Request.Form["ImportEndDate"].ToString()); var import_report = new ReportDao(); TempData["import_report"] = import_report.Import_Report(start_date, end_date); return(RedirectToAction("Index", "Report")); }
internal void setProfitPerItemRowsCount() { try { DataSet dataSet = ReportDao.getProfitPerItem((profitPerItem.datePicker_from.SelectedDate != null ? Convert.ToDateTime(profitPerItem.datePicker_from.SelectedDate).ToString("yyyy-MM-dd") : null), (profitPerItem.datePicker_to.SelectedDate != null ? Convert.ToDateTime(profitPerItem.datePicker_to.SelectedDate).ToString("yyyy-MM-dd") : null), Convert.ToInt32(profitPerItem.comboBox_categoryId.SelectedValue), Convert.ToInt32(profitPerItem.comboBox_companyId.SelectedValue), profitPerItem.textBox_itemName.TrimedText, profitPerItem.textBox_itemCode.TrimedText, true, profitPerItem.Pagination.LimitStart, profitPerItem.Pagination.LimitCount); profitPerItem.Pagination.RowsCount = Convert.ToInt32(dataSet.Tables[0].Rows[0][0]); } catch (Exception) { } }
internal void setDailyProfitRowsCount() { try { DataSet dataSet = ReportDao.getDailyProfit((dailyProfit.datePicker_from.SelectedDate != null ? Convert.ToDateTime(dailyProfit.datePicker_from.SelectedDate).ToString("yyyy-MM-dd") : null), (dailyProfit.datePicker_to.SelectedDate != null ? Convert.ToDateTime(dailyProfit.datePicker_to.SelectedDate).ToString("yyyy-MM-dd") : null), true, dailyProfit.Pagination.LimitStart, dailyProfit.Pagination.LimitCount); dailyProfit.Pagination.RowsCount = Convert.ToInt32(dataSet.Tables[0].Rows[0][0]); } catch (Exception) { } }
public ActionResult XoaBaoCao() { string id = RouteData.Values["id"].ToString(); // Trước khi xóa bài viết sau đó xóa nhà trọ var bc = db.BaoCaos.Find(Int32.Parse(id)); var bv = db.BaiViets.Find(bc.idBV); var nt = db.NhaTroes.Find(bv.idNT); var HamP = new FunctionPosts(); var HamNT = new FunctionNhaTro(); var HamBC = new ReportDao(); HamBC.Delete(Int32.Parse(id)); return(RedirectToAction("QLBC", "Home")); }
internal void filterProfitPerItem() { try { DataSet dataSet = ReportDao.getProfitPerItem((profitPerItem.datePicker_from.SelectedDate != null ? Convert.ToDateTime(profitPerItem.datePicker_from.SelectedDate).ToString("yyyy-MM-dd") : null), (profitPerItem.datePicker_to.SelectedDate != null ? Convert.ToDateTime(profitPerItem.datePicker_to.SelectedDate).ToString("yyyy-MM-dd") : null), Convert.ToInt32(profitPerItem.comboBox_categoryId.SelectedValue), Convert.ToInt32(profitPerItem.comboBox_companyId.SelectedValue), profitPerItem.textBox_itemName.TrimedText, profitPerItem.textBox_itemCode.TrimedText, false, profitPerItem.Pagination.LimitStart, profitPerItem.Pagination.LimitCount); profitPerItem.DataTable.Rows.Clear(); foreach (DataRow row in dataSet.Tables[0].Rows) { profitPerItem.DataTable.Rows.Add(0, row[0], row[1], row[2], row[3], Convert.ToDouble(row[4]).ToString("#,##0.00")); } } catch (Exception) { } }
public ActionResult Report(string tieude, string mota, string idbv) { var session = (DACN.Common.UserLogin)Session[DACN.Common.CommonConstants.USER_SESSION]; BaoCao bc = new BaoCao(); var bcdao = new ReportDao(); bc.TieuDe = tieude; bc.TenBaoCao = mota; DateTime now = DateTime.Now; bc.NgayBC = now; bc.TrangThai = false; bc.idBV = Int32.Parse(idbv); bcdao.Insert(bc); return(Json(new { Message = "success", JsonRequestBehavior = JsonRequestBehavior.AllowGet })); }
internal void setDailyItemSaleRowsCount() { try { if (String.IsNullOrWhiteSpace(dailyItemSale.textBox_itemId.Text)) { dailyItemSale.label_selectedItemName.Content = null; } DataSet dataSet = ReportDao.getDailyItemSale((!String.IsNullOrWhiteSpace(dailyItemSale.textBox_categoryId.Text) ? Convert.ToInt32(dailyItemSale.textBox_categoryId.Text) : 0), (!String.IsNullOrWhiteSpace(dailyItemSale.textBox_companyId.Text) ? Convert.ToInt32(dailyItemSale.textBox_companyId.Text) : 0), (!String.IsNullOrWhiteSpace(dailyItemSale.textBox_itemId.Text) ? Convert.ToInt32(dailyItemSale.textBox_itemId.Text) : 0), (dailyItemSale.datePicker_from.SelectedDate != null ? Convert.ToDateTime(dailyItemSale.datePicker_from.SelectedDate).ToString("yyyy-MM-dd") : null), (dailyItemSale.datePicker_to.SelectedDate != null ? Convert.ToDateTime(dailyItemSale.datePicker_to.SelectedDate).ToString("yyyy-MM-dd") : null), true, dailyItemSale.Pagination.LimitStart, dailyItemSale.Pagination.LimitCount); dailyItemSale.Pagination.RowsCount = Convert.ToInt32(dataSet.Tables[0].Rows[0][0]); } catch (Exception) { } }
internal void filterDailyProfit() { try { DataSet dataSet = ReportDao.getDailyProfit((dailyProfit.datePicker_from.SelectedDate != null ? Convert.ToDateTime(dailyProfit.datePicker_from.SelectedDate).ToString("yyyy-MM-dd") : null), (dailyProfit.datePicker_to.SelectedDate != null ? Convert.ToDateTime(dailyProfit.datePicker_to.SelectedDate).ToString("yyyy-MM-dd") : null), false, dailyProfit.Pagination.LimitStart, dailyProfit.Pagination.LimitCount); dailyProfit.DataTable.Rows.Clear(); foreach (DataRow row in dataSet.Tables[0].Rows) { dailyProfit.DataTable.Rows.Add(0, Convert.ToDateTime(row[0]).ToString("yyyy-MM-dd"), Convert.ToDouble(row[1]).ToString("#,##0.00"), Convert.ToDouble(row[2]).ToString("#,##0.00"), Convert.ToDouble(row[3]).ToString("#,##0.00")); } } catch (Exception) { } }
//신고글 조회 기능(함수) public void After_Report() { ReportDao reportdao = new ReportDao(); Report report = new Report(); Report inputReport = new Report(); DataSet ds = reportdao.SelectReport(); dataGridView1.DataSource = ds.Tables[0]; //rep_no, trv_no, rep_timestap, rep_mem_id, rep_reason dataGridView1.Columns[0].HeaderCell.Value = "신고 번호"; dataGridView1.Columns[1].HeaderCell.Value = "게시글 번호"; dataGridView1.Columns[2].HeaderCell.Value = "신고 일시"; dataGridView1.Columns[3].HeaderCell.Value = "신고인"; dataGridView1.Columns[4].HeaderCell.Value = "신고 사유"; }
private void PopulateLabs() { ReportDao reportDao = new ReportDao(); var LabList = reportDao.GetLaboratories(); for (int i = 0; i < LabList.Count; i++) { ArrayList row = (ArrayList)LabList[i]; ddlLab.Items.Add(new ListItem(row[3].ToString(), row[1].ToString())); ddlLab2.Items.Add(new ListItem(row[3].ToString(), row[1].ToString())); } //ddlLab.DataSource = reportDao.GetLaboratories(); //ddlLab.DataTextField = "LabCode"; //ddlLab.DataValueField = "Id"; ////ddlLab.DataBind(); }
internal void filterDailyItemSale() { try { DataSet dataSet = ReportDao.getDailyItemSale((!String.IsNullOrWhiteSpace(dailyItemSale.textBox_categoryId.Text) ? Convert.ToInt32(dailyItemSale.textBox_categoryId.Text) : 0), (!String.IsNullOrWhiteSpace(dailyItemSale.textBox_companyId.Text) ? Convert.ToInt32(dailyItemSale.textBox_companyId.Text) : 0), (!String.IsNullOrWhiteSpace(dailyItemSale.textBox_itemId.Text) ? Convert.ToInt32(dailyItemSale.textBox_itemId.Text) : 0), (dailyItemSale.datePicker_from.SelectedDate != null ? Convert.ToDateTime(dailyItemSale.datePicker_from.SelectedDate).ToString("yyyy-MM-dd") : null), (dailyItemSale.datePicker_to.SelectedDate != null ? Convert.ToDateTime(dailyItemSale.datePicker_to.SelectedDate).ToString("yyyy-MM-dd") : null), false, dailyItemSale.Pagination.LimitStart, dailyItemSale.Pagination.LimitCount); dailyItemSale.DataTable.Rows.Clear(); foreach (DataRow row in dataSet.Tables[0].Rows) { dailyItemSale.DataTable.Rows.Add(0, Convert.ToDateTime(row[0]).ToString("yyyy-MM-dd"), row[1], Convert.ToDouble(row[2]).ToString("#,##0.00"), Convert.ToDouble(row[3]).ToString("#,##0.00"), Convert.ToDouble(row[4]).ToString("#,##0.00"), Convert.ToDouble(row[5]).ToString("#,##0.00"), Convert.ToDouble(row[6]).ToString("#,##0.00"), Convert.ToDouble(row[7]).ToString("#,##0.00"), Convert.ToDouble(row[8]).ToString("#,##0.00"), Convert.ToDouble(row[9]).ToString("#,##0.00")); } } catch (Exception) { } }
internal void printDailyProfit() { try { PrepareReport prepareReport = new PrepareReport(); prepareReport.addParameter("reportType", "Daily Profit"); prepareReport.addParameter("reportDescription", ""); prepareReport.addCommon(); DataTable dt = new DataTable(); dt.Columns.Add("ID", typeof(int)); dt.Columns.Add("Date", typeof(String)); dt.Columns.Add("Amount", typeof(String)); dt.Columns.Add("Expenses", typeof(String)); dt.Columns.Add("Total", typeof(String)); DataSet dataSet = ReportDao.getDailyProfit((dailyProfit.datePicker_from.SelectedDate != null ? Convert.ToDateTime(dailyProfit.datePicker_from.SelectedDate).ToString("yyyy-MM-dd") : null), (dailyProfit.datePicker_to.SelectedDate != null ? Convert.ToDateTime(dailyProfit.datePicker_to.SelectedDate).ToString("yyyy-MM-dd") : null), false, dailyProfit.Pagination.LimitStart, dailyProfit.Pagination.LimitCount); double profit = 0; double expenses = 0; double total = 0; foreach (DataRow row in dataSet.Tables[0].Rows) { profit += Convert.ToDouble(row[1]); expenses += Convert.ToDouble(row[2]); total += Convert.ToDouble(row[3]); dt.Rows.Add(0, Convert.ToDateTime(row[0]).ToString("yyyy-MM-dd"), Convert.ToDouble(row[1]).ToString("#,##0.00"), Convert.ToDouble(row[2]).ToString("#,##0.00"), Convert.ToDouble(row[3]).ToString("#,##0.00")); } prepareReport.addParameter("totalProfit", profit.ToString("#,##0.00")); prepareReport.addParameter("reportExpenses", expenses.ToString("#,##0.00")); prepareReport.addParameter("reportTotal", total.ToString("#,##0.00")); /**/ new ReportViewer(dt, "DailyProfit", prepareReport.getParameters()).Show(); } catch (Exception) { } }
private void btnPrintTakeIn_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { if (lstTakeIn.SelectedIndex == -1) { return; } int _idMaster = -1; DataTable tbTmp = (DataTable)lstTakeIn.DataSource; if (tbTmp.Rows.Count > 0) { DataRow dr = tbTmp.Rows[lstTakeIn.SelectedIndex]; _idMaster = CnvToInt32(dr["Id"]); } if (_idMaster == -1) { return; } FORM.BAOCAO.NHAPXUAT.rptTakeIns frp = new FORM.BAOCAO.NHAPXUAT.rptTakeIns(); FORM.BAOCAO.frmBaoCao f = new FORM.BAOCAO.frmBaoCao(); f.ShowBaoCao(frp, ReportDao.GetListTakeIn(_idMaster, _ConfigItem), this.ParentForm); }
public DataSet ExportTravelAdvance(string datefrom, string dateto, string ExportType) { ReportDao re = new ReportDao(); return(re.ExportTravelAdvance(datefrom, dateto, ExportType)); }
public DataSet ExportCostSharingPayment(string datefrom, string dateto, string ExportType) { ReportDao re = new ReportDao(); return(re.ExportCostSharingPayment(datefrom, dateto, ExportType)); }
public DataSet GetCostSharingPaymentReport(string datefrom, string dateto) { ReportDao re = new ReportDao(); return(re.CostSharingPaymentReport(datefrom, dateto)); }
public DataSet GetBankPaymentReport(string datefrom, string dateto) { ReportDao re = new ReportDao(); return(re.BankPaymentPaymentReport(datefrom, dateto)); }
public DataSet GetTravelAdvancenReport(string datefrom, string dateto) { ReportDao re = new ReportDao(); return(re.TravelAdvanceReport(datefrom, dateto)); }
public DataSet GetLiquidationReport(string datefrom, string dateto) { ReportDao re = new ReportDao(); return(re.LiquidationReport(datefrom, dateto)); }
public DataSet GetVehicleReport(string datefrom, string dateto) { ReportDao re = new ReportDao(); return(re.VehicleReport(datefrom, dateto)); }
public DataSet GetPurchaseReport(string datefrom, string dateto) { ReportDao re = new ReportDao(); return(re.PurchaseReport(datefrom, dateto)); }
public DataSet GetLeaveReport(int EmployeeName, int LeaveType) { ReportDao re = new ReportDao(); return(re.LeaveReport(EmployeeName, LeaveType)); }
public DataSet EmployeeBirthReport(string month) { ReportDao re = new ReportDao(); return(re.EmployeeBirthReport(month)); }