private void btnRefreshStockCard_Click(object sender, EventArgs e) { if (dxStockCardValiation.Validate()) { // Bind the stock card. var dataRow = (DataRowView)lkStockArchivePeriod.GetSelectedDataRow(); StockCardReport report; if (chkStockCardArchive.Checked && dataRow != null) { report = ReportingReportFactory.CreateStockCard(Convert.ToInt32(lkStockCardActivity.EditValue), ItemID, Convert.ToInt32(lkStockCardUnit.EditValue), Convert.ToInt32(lkStockCardWarehouse.EditValue), Convert.ToInt32(lkStockCardManufacturer.EditValue), Convert.ToDateTime(dataRow["StartDate"]), Convert.ToDateTime(dataRow["EndDate"])); } else { report = ReportingReportFactory.CreateStockCard(Convert.ToInt32(lkStockCardActivity.EditValue), ItemID, Convert.ToInt32(lkStockCardUnit.EditValue), Convert.ToInt32(lkStockCardWarehouse.EditValue), Convert.ToInt32(lkStockCardManufacturer.EditValue)); } stockCardReport = report; printStockCard.PrintingSystem = report.PrintingSystem; report.PrintingSystem.ExecCommand(DevExpress.XtraPrinting.PrintingSystemCommand.ZoomToPageWidth, null); // Generate the report's print document. report.CreateDocument(); } }
public static StockCardReport CreateStockCard(int activityID, int itemID, int unitID, int warehouse, int manufactuererID, DateTime?startDate = null, DateTime?endDate = null) { BLL.Balance balance = new Balance(); BLL.Item item = new Item(); item.LoadByPrimaryKey(itemID); ItemUnit iunit = new ItemUnit(); iunit.LoadByPrimaryKey(unitID); BLL.Warehouse physicalStore = new Warehouse(); physicalStore.LoadByPrimaryKey(warehouse); var dataView = new DataView(); if (startDate == null || endDate == null) { dataView = Balance.GetStockCardByWarehouse(activityID, itemID, unitID, EthiopianDate.EthiopianDate.Now.FiscalYear, warehouse, manufactuererID); } else { dataView = Balance.GetStockCardByDate(activityID, itemID, unitID, warehouse, manufactuererID, startDate.Value, endDate.Value); } StockCardReport report = new StockCardReport(); report.DataSource = dataView; // Bind the headers here. report.StockCode.Text = item.StockCode; report.Description.Text = item.FullItemName; report.Unit.Text = iunit.Text; Activity store = new Activity(); store.LoadByPrimaryKey(activityID); report.Account.Text = store.AccountName; report.SubAccount.Text = store.SubAccountName; report.Activity.Text = store.Name; Manufacturer manufacturers = new Manufacturer(); manufacturers.LoadByPrimaryKey(manufactuererID); report.Manufacturer.Text = manufacturers.Name; // TODO: add the Item Source Here (the suggested interpretation is that item source is supplier) report.PrintedBy.Text = string.Format("Generated By: {0} On {1}", CurrentContext.LoggedInUserName, BLL.DateTimeHelper.ServerDateTime.ToString("dd-MM-yyyy hh:mm tt")); report.Store.Text = physicalStore.Name; report.AppVersion.Text = "HCMIS"; return(report); }
public StockCardReport IsHasRecord(long CustNo, DateTime PeriodDate) { StockCardReport SCRpt = new StockCardReport(); try { SCRpt = GetBeginningOnStockCard(CustNo, PeriodDate); } catch (Exception) { SCRpt = new StockCardReport(); //SCRpt = null; } return(SCRpt); }
private void Acc_StockCard() { SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["IRMSConnectionString"].ConnectionString); ReportDocument rpt; string rptDocCachedKey = null; rptDocCachedKey = "StockCardRpt"; if (Cache[rptDocCachedKey] != null) { rpt = (StockCardRpt)Cache[rptDocCachedKey]; } else { rpt = new StockCardRpt(); Cache.Insert(rptDocCachedKey, rpt); } long CustNo = long.Parse(Request.QueryString["custno"]); DateTime PrevDate = DateTime.Parse(Request.QueryString["datefrom"]).AddDays(-1); DateTime DateFrom = DateTime.Parse(Request.QueryString["datefrom"]); DateTime DateTo = DateTime.Parse(Request.QueryString["dateto"]); long Balqty = 0; decimal Balamt = 0; decimal Balcost = 0; long Balqty1 = 0; decimal Balamt1 = 0; decimal Balcost1 = 0; long Debitqty = 0; decimal Debitamt = 0; decimal Debitcost = 0; long Creditqty = 0; decimal Creditamt = 0; decimal Creditcost = 0; bool Firstrec = true; conn.Open(); SqlCommand cmd = new SqlCommand(); cmd.Connection = conn; cmd.CommandTimeout = 300; cmd.CommandText = "delete from rptstockcard_new where custno = '" + CustNo + "' and datefrom = '" + DateFrom + "' and dateto = '" + DateTo + "'"; cmd.ExecuteNonQuery(); StockCardReportManager SCRManager = new StockCardReportManager(); StockCardReport SCR = SCRManager.IsHasRecord(CustNo, PrevDate); if (SCRManager.HasRecord(CustNo, PrevDate) == true) { cmd.CommandTimeout = 300; cmd.CommandText = "GenRptStockCard_Beg_StockCard '" + DateFrom + "', '" + DateTo + "', '" + PrevDate + "', " + CustNo + ", '" + Session["USER_NAME"] + "'"; cmd.ExecuteNonQuery(); } else { StoreOutStandingInventory SOIBeginning = SCRManager.IsHasRecordOnSOI(CustNo, PrevDate); if (SOIBeginning != null) { cmd.CommandTimeout = 300; cmd.CommandText = "GenRptStockCard_Beg_SOI '" + DateFrom + "', '" + DateTo + "', '" + PrevDate + "', " + CustNo + ", '" + Session["USER_NAME"] + "'"; cmd.ExecuteNonQuery(); } else { cmd.CommandTimeout = 300; cmd.CommandText = "GenRptStockCard_Beg_Pcount '" + DateFrom + "', '" + DateTo + "', " + CustNo + ", '" + Session["USER_NAME"] + "'"; cmd.ExecuteNonQuery(); } } //cmd.Connection = conn; cmd.CommandTimeout = 3000; cmd.CommandText = "genrptstockcard_new '" + Request.QueryString["datefrom"] + "','" + Request.QueryString["dateto"] + "'," + Request.QueryString["custno"] + ", '" + Session["USER_NAME"] + "'"; cmd.ExecuteNonQuery(); DataTable ResultSet = new DataTable(); cmd.CommandText = "genrptstockcardsales '" + Request.QueryString["datefrom"] + "','" + Request.QueryString["dateto"] + "'," + Request.QueryString["custno"] + ", '" + Session["USER_NAME"] + "'"; cmd.ExecuteNonQuery(); cmd.CommandText = "select * from rptstockcard_new where custno = " + Request.QueryString["custno"] + " and datefrom= '" + Request.QueryString["datefrom"] + "' and dateto='" + Request.QueryString["dateto"] + "'"; using (SqlDataAdapter adapter = new SqlDataAdapter()) { adapter.SelectCommand = cmd; adapter.Fill(ResultSet); } foreach (DataRow row in ResultSet.Rows) { if (Firstrec == true) { ////Balqty = (long)row[14]; ////Balamt = (decimal)row[15]; ////Balcost = (decimal)row[16]; Balqty = Convert.ToInt64(row[14]); Balamt = ConvertDataToDecimal(row[15]); Balcost = ConvertDataToDecimal(row[16]); Firstrec = false; } else { Debitqty = Convert.ToInt64(row[8]); Debitamt = ConvertDataToDecimal(row[9]); Debitcost = ConvertDataToDecimal(row[10]); Creditqty = Convert.ToInt64(row[11]); Creditamt = ConvertDataToDecimal(row[12]); Creditcost = ConvertDataToDecimal(row[13]); Balqty1 = Balqty + Debitqty + Creditqty; Balamt1 = Balamt + Debitamt + Creditamt; Balcost1 = Balcost + Debitcost + Creditcost; Balqty = Balqty1; Balamt = Balamt1; Balcost = Balcost1; cmd.CommandText = "update rptstockcard_new set balance_qty = " + Balqty + ", balance_amt = " + Balamt + ", balance_cost= " + Balcost + " where id = " + (long)row[0] + " and custno = " + (int)row[4] + " and username = '******' and datefrom = '" + DateFrom + "' and dateto = '" + DateTo + "'"; cmd.ExecuteNonQuery(); } } DataBaseLogIn(rpt); ParameterField prmDatefrom = new ParameterField(); ParameterField prmDateTo = new ParameterField(); ParameterField prmCustno = new ParameterField(); ParameterFields prmList = new ParameterFields(); prmDatefrom.ParameterFieldName = "datefrom"; prmDateTo.ParameterFieldName = "dateto"; prmCustno.ParameterFieldName = "custno"; ParameterDiscreteValue prmDateFromValue = new ParameterDiscreteValue(); ParameterDiscreteValue prmDateToValue = new ParameterDiscreteValue(); ParameterDiscreteValue prmCustnoValue = new ParameterDiscreteValue(); prmDateFromValue.Value = Request.QueryString["datefrom"]; prmDateToValue.Value = Request.QueryString["dateto"]; prmCustnoValue.Value = Request.QueryString["custno"]; prmDatefrom.CurrentValues.Add(prmDateFromValue); prmDateTo.CurrentValues.Add(prmDateToValue); prmCustno.CurrentValues.Add(prmCustnoValue); prmList.Add(prmDatefrom); prmList.Add(prmDateTo); prmList.Add(prmCustno); crvDailyReport.ParameterFieldInfo = prmList; crvDailyReport.ReportSource = rpt; }