/// <summary>
///
/// </summary>
/// <returns></returns>
public ActionResult Index(string day = "")
{
List <TopProduct> data = ReportBLL.TopProduct(day);
var model = new Models.ReportTopProduct()
{
Data = data
};
return(View(model));
}
public ActionResult Testxml(string id)
{
ReportBLL reportBll = new ReportBLL();
string Message = string.Empty;
reportBll.Testxml(id, out Message);
ViewBag.IsSuccess = Message;
return(View());
}
protected void btnReport_Click(object sender, ImageClickEventArgs e)
{
Int32 period_id = Convert.ToInt32(cboPeriod.SelectedValue);
if (validate())
{
List <Entities.AcademicOffer> pListAcademicOffer = ReportBLL.getInstance().reportTeacher(period_id);
printReport(pListAcademicOffer);
}
}
public void start(SCApplication _app)
{
scApp = _app;
reportBLL = _app.ReportBLL;
lineBLL = _app.LineBLL;
line = scApp.getEQObjCacheManager().getLine();
//initPublish(line);
}
protected void btnReport_Click(object sender, ImageClickEventArgs e)
{
Int32 period_id = Convert.ToInt32(cboPeriod.SelectedValue);
if (validate())
{
List <Entities.ClassRoom> listClassRoom = ReportBLL.getInstance().reportClassRoom(period_id);
getReport(listClassRoom);
}
}
public void start(SCApplication _app)
{
scApp = _app;
reportBLL = _app.ReportBLL;
lineBLL = _app.LineBLL;
line = scApp.getEQObjCacheManager().getLine();
line.addEventHandler(nameof(ConnectionInfoService), nameof(line.Host_Control_State), PublishLineInfo);
line.addEventHandler(nameof(ConnectionInfoService), nameof(line.SCStats), PublishLineInfo);
line.addEventHandler(nameof(ConnectionInfoService), nameof(line.Secs_Link_Stat), PublishLineInfo);
line.addEventHandler(nameof(ConnectionInfoService), nameof(line.CurrentPortStateChecked), PublishOnlineCheckInfo);
line.addEventHandler(nameof(ConnectionInfoService), nameof(line.CurrentStateChecked), PublishOnlineCheckInfo);
line.addEventHandler(nameof(ConnectionInfoService), nameof(line.EnhancedVehiclesChecked), PublishOnlineCheckInfo);
line.addEventHandler(nameof(ConnectionInfoService), nameof(line.TSCStateChecked), PublishOnlineCheckInfo);
//line.addEventHandler(nameof(ConnectionInfoService), nameof(line.UnitAlarmStateListChecked), PublishOnlineCheckInfo);
line.addEventHandler(nameof(ConnectionInfoService), nameof(line.EnhancedTransfersChecked), PublishOnlineCheckInfo);
line.addEventHandler(nameof(ConnectionInfoService), nameof(line.EnhancedCarriersChecked), PublishOnlineCheckInfo);
//line.addEventHandler(nameof(ConnectionInfoService), nameof(line.LaneCutListChecked), PublishOnlineCheckInfo);
line.addEventHandler(nameof(ConnectionInfoService), nameof(line.MCSConnectionSuccess), PublishPingCheckInfo);
line.addEventHandler(nameof(ConnectionInfoService), nameof(line.RouterConnectionSuccess), PublishPingCheckInfo);
line.addEventHandler(nameof(ConnectionInfoService), nameof(line.AGV1ConnectionSuccess), PublishPingCheckInfo);
line.addEventHandler(nameof(ConnectionInfoService), nameof(line.AGV2ConnectionSuccess), PublishPingCheckInfo);
line.addEventHandler(nameof(ConnectionInfoService), nameof(line.AGV3ConnectionSuccess), PublishPingCheckInfo);
line.addEventHandler(nameof(ConnectionInfoService), nameof(line.AGV4ConnectionSuccess), PublishPingCheckInfo);
line.addEventHandler(nameof(ConnectionInfoService), nameof(line.AGV5ConnectionSuccess), PublishPingCheckInfo);
line.addEventHandler(nameof(ConnectionInfoService), nameof(line.AGV6ConnectionSuccess), PublishPingCheckInfo);
line.addEventHandler(nameof(ConnectionInfoService), nameof(line.AGV7ConnectionSuccess), PublishPingCheckInfo);
line.addEventHandler(nameof(ConnectionInfoService), nameof(line.AGV8ConnectionSuccess), PublishPingCheckInfo);
line.addEventHandler(nameof(ConnectionInfoService), nameof(line.AGV9ConnectionSuccess), PublishPingCheckInfo);
line.addEventHandler(nameof(ConnectionInfoService), nameof(line.AGV10ConnectionSuccess), PublishPingCheckInfo);
line.addEventHandler(nameof(ConnectionInfoService), nameof(line.AGV11ConnectionSuccess), PublishPingCheckInfo);
line.addEventHandler(nameof(ConnectionInfoService), nameof(line.AGV12ConnectionSuccess), PublishPingCheckInfo);
line.addEventHandler(nameof(ConnectionInfoService), nameof(line.AGV13ConnectionSuccess), PublishPingCheckInfo);
line.addEventHandler(nameof(ConnectionInfoService), nameof(line.AGV14ConnectionSuccess), PublishPingCheckInfo);
line.addEventHandler(nameof(ConnectionInfoService), nameof(line.ChargePLCConnectionSuccess), PublishPingCheckInfo);
line.addEventHandler(nameof(ConnectionInfoService), nameof(line.ADAM1ConnectionSuccess), PublishPingCheckInfo);
line.addEventHandler(nameof(ConnectionInfoService), nameof(line.ADAM2ConnectionSuccess), PublishPingCheckInfo);
line.addEventHandler(nameof(ConnectionInfoService), nameof(line.ADAM3ConnectionSuccess), PublishPingCheckInfo);
line.addEventHandler(nameof(ConnectionInfoService), nameof(line.ADAM4ConnectionSuccess), PublishPingCheckInfo);
line.addEventHandler(nameof(ConnectionInfoService), nameof(line.ADAM5ConnectionSuccess), PublishPingCheckInfo);
line.addEventHandler(nameof(ConnectionInfoService), nameof(line.AP1ConnectionSuccess), PublishPingCheckInfo);
line.addEventHandler(nameof(ConnectionInfoService), nameof(line.AP2ConnectionSuccess), PublishPingCheckInfo);
line.addEventHandler(nameof(ConnectionInfoService), nameof(line.AP3ConnectionSuccess), PublishPingCheckInfo);
line.addEventHandler(nameof(ConnectionInfoService), nameof(line.AP4ConnectionSuccess), PublishPingCheckInfo);
line.addEventHandler(nameof(ConnectionInfoService), nameof(line.AP5ConnectionSuccess), PublishPingCheckInfo);
line.addEventHandler(nameof(ConnectionInfoService), nameof(line.AP6ConnectionSuccess), PublishPingCheckInfo);
line.addEventHandler(nameof(ConnectionInfoService), nameof(line.AP7ConnectionSuccess), PublishPingCheckInfo);
line.addEventHandler(nameof(ConnectionInfoService), nameof(line.AP8ConnectionSuccess), PublishPingCheckInfo);
line.addEventHandler(nameof(ConnectionInfoService), nameof(line.AP9ConnectionSuccess), PublishPingCheckInfo);
line.addEventHandler(nameof(ConnectionInfoService), nameof(line.AP10ConnectionSuccess), PublishPingCheckInfo);
initPublish(line);
}
private void PopulatePort(Int32 Vessel, Int32 Voyage, Int32 Line)
{
ReportBLL objBLL = new ReportBLL();
DataSet ds = objBLL.GetPOD(Vessel, Voyage, Line);
ddlPOD.DataValueField = "fk_PortID";
ddlPOD.DataTextField = "PortName";
ddlPOD.DataSource = ds;
ddlPOD.DataBind();
ddlPOD.Items.Insert(0, new ListItem("All", "0"));
}
protected void SubreportEventHandler(object sender, SubreportProcessingEventArgs e)
{
var BlNo = e.Parameters["EXPBLID"].Values[0].ToString();
var main = ReportBLL.GetRptFrieghtManifest(BlNo);
var TFS = ReportBLL.GetRptFrieghtManifest_TFS(BlNo);
var CTRS = ReportBLL.GetRptFrieghtManifest_CTRS(BlNo);
e.DataSources.Add(new ReportDataSource("dsLin", main.Tables[0]));
e.DataSources.Add(new ReportDataSource("dsTFS", TFS.Tables[0]));
e.DataSources.Add(new ReportDataSource("dsCTRS", CTRS.Tables[0]));
}
private void BindBuyerProvince()
{
string startDate = datePicker.Value.Trim();
string endDate = datePickerEnd.Value.Trim();
DataTable tb = ReportBLL.GetBuyerProviceReport(Users.Nick, startDate, endDate);
if (tb != null)
{
Chart2.Series["buyerProvince"].Points.DataBindXY(tb.DefaultView, "province", tb.DefaultView, "areacount");
}
}
/// <summary>
/// Khởi tạo
/// </summary>
public static void Initialize()
{
string connectionString =
ConfigurationManager.ConnectionStrings["LiteCommerce"].ConnectionString;
CatalogBLL.Initialize(connectionString);
HumanResourceBLL.Initialize(connectionString);
AccountBLL.Initialize(connectionString);
ReportBLL.Initialize(connectionString);
//TODO: Bổ sung khởi tạo các BLL khác khi cần sử dụng
}
protected void btnReport_Click(object sender, ImageClickEventArgs e)
{
Int32 period_id = Convert.ToInt32(cboPeriod.SelectedValue);
Int32 isContact = Convert.ToInt32(cboOptions.SelectedValue);
if (validate())
{
List <Entities.WaitingList> listWaitingList = ReportBLL.getInstance().reportWaitingList(period_id, isContact);
getReport(listWaitingList);
}
}
protected void btnSearch_Click(object sender, EventArgs e)
{
var startTime = DateTime.Parse(hidStartTime.Value);
var endTime = DateTime.Parse(hidEndTime.Value);
if (!base.CheckDateInput(startTime, endTime, ltCheckInfo))
{
ScriptManager.RegisterStartupScript(upRpt, this.Page.GetType(), "", "canClick()", true);
return;
}
// 车架号VIN
string vin = string.Empty;
if (!string.IsNullOrEmpty(this.hidVIN.Value))
{
vin = hidVIN.Value;
}
var rptName = base.CurrentRptName;
try
{
ACCONStatisticSearchModel model = new ACCONStatisticSearchModel();
model.SartTime = startTime;
model.EndTime = endTime;
model.VIN = vin;
model.PlateNum = this.hidPlateNum.Value;
List <ACCONStatisticDataModel> list;
// 默认模式
if (base.VehicleViewMode)
{
list = ReportBLL.GetDefaultACCONStatisticData(model, base.CurrentStrucID);
}
// 自由模式
else
{
list = ReportBLL.GetACCONStatisticData(model, base.CurrentUserID);
}
if (!base.CheckResult <ACCONStatisticDataModel>(list, ltCheckInfo))
{
ScriptManager.RegisterStartupScript(upRpt, this.Page.GetType(), "", "canClick()", true);
return;
}
this.ShowReport(list);
ScriptManager.RegisterStartupScript(upRpt, this.Page.GetType(), "", "canClick()", true);
}
catch (Exception ex)
{
ScriptManager.RegisterStartupScript(upRpt, this.Page.GetType(), "", "canClick()", true);
base.DoReportLog(ex.Message, ltCheckInfo);
}
}
protected void btnReport_Click(object sender, ImageClickEventArgs e)
{
Int32 period_id = Convert.ToInt32(cboPeriod.SelectedValue);
String period_name = cboPeriod.SelectedItem.Text;
if (validate())
{
List <Entities.AcademicOffer> listAcademicOffer = ReportBLL.getInstance().reportOffer(period_id);
lblMessage.Text = "";
printReport(listAcademicOffer, period_name);
}
}
private void BtnPrint_Click(object sender, EventArgs e)
{
if (this.gridView3.RowCount == 0)
{
return;
}
DataTable dt = ReportBLL.GetInstance().GetPurchaseReportData(purchaseSaveModel.PurchaseId);
FrmPrint frmPrint = new FrmPrint(new PurchaseXtraReport(base.CurrentUserOrgName + "采购单报表"), dt);
frmPrint.ShowDialog();
}
public void start(SCApplication _app)
{
scApp = _app;
reportBLL = _app.ReportBLL;
lineBLL = _app.LineBLL;
line = scApp.getEQObjCacheManager().getLine();
line.addEventHandler(nameof(ConnectionInfoService), nameof(line.MCSCommandAutoAssign), PublishTransferInfo);
initPublish(line);
}
protected void btnGoxxx_Click(object sender, EventArgs e)
{
//string where = "";
string fields = "ID,OwnerID,tbName,tbKey,tbBalance,tbMobile,tbIdentityNo,PatchID";
string key = this.RadioButtonList1.SelectedItem.Value;
StringBuilder sb = new StringBuilder();
string KeyValue = ViewState["Key_" + key].ToString();
string template = " select {0} from companycase_{1} where {2} ='{3}'";
CompanyDS = BLL.CompanyBLL.GetCompanyList();
int count = CompanyDS.Tables[0].Rows.Count;
for (int i = 0; i < count; i++)
{
DataRow dr = CompanyDS.Tables[0].Rows[i];
string id = dr["ID"].ToString();
if (HasCaseTable(id) && id != CompanyID)
{
string fieldsAddCompanyID = id + " as CompanyID," + fields;
string tempsql = string.Format(template, fieldsAddCompanyID, id, key, KeyValue);
sb.AppendLine(tempsql);
sb.AppendLine("Union All");
}
}
string sql = sb.ToString();
if (sql == "")
{
return;
}
else
{
sql = sql.Substring(0, sql.Length - "Union All".Length - 2);
DataSet ds = ReportBLL.GetDataSet(sql);
if (ds.Tables[0].Rows.Count > 0)
{
ALLPatchsDS = BLL.PatchBLL.GetPatchList();
}
this.GridView2.DataSource = ds;
this.GridView2.DataBind();
}
}
protected void btnSearch_Click(object sender, EventArgs e)
{
var startTime = DateTime.Parse(hidStartTime.Value);
var endTime = DateTime.Parse(hidEndTime.Value);
if (!base.CheckInput(startTime, endTime, ltCheckInfo))
{
ScriptManager.RegisterStartupScript(upRpt, this.Page.GetType(), "", "canClick()", true);
return;
}
// 车辆ID
long vehiclesID = 0;
if (!string.IsNullOrWhiteSpace(this.hidVehicleID.Value))
{
vehiclesID = Convert.ToInt64(hidVehicleID.Value);
}
try
{
ExceptionSearchModel model = new ExceptionSearchModel();
model.UserID = base.CurrentUserID;
model.SartTime = startTime;
model.EndTime = endTime;
model.VehiclesID = vehiclesID;
List <MGJHExpForIllegalDischargModel> list;
// 默认模式
if (base.VehicleViewMode)
{
list = ReportBLL.GetMGJHExpForIllegalDischarg(model, base.CurrentStrucID);
}
// 自由模式
else
{
list = ReportBLL.GetMGJHExpForIllegalDischarg(model);
}
if (!base.CheckResult <MGJHExpForIllegalDischargModel>(list, ltCheckInfo))
{
ScriptManager.RegisterStartupScript(upRpt, this.Page.GetType(), "", "canClick()", true);
return;
}
this.ShowReport(list);
ScriptManager.RegisterStartupScript(upRpt, this.Page.GetType(), "", "canClick()", true);
}
catch (Exception ex)
{
ScriptManager.RegisterStartupScript(upRpt, this.Page.GetType(), "", "canClick()", true);
base.DoReportLog(ex.Message, ltCheckInfo);
}
}
public ResponseLRGet LRGet([FromBody] RequestLRGet request)
{
try
{
ReportBLL bll = new ReportBLL();
return(bll.LRGet(request));
}
catch (Exception ex)
{
throw new HttpResponseException(
Request.CreateErrorResponse(HttpStatusCode.InternalServerError, ex.Message));
}
}
public void ManagerController_DistributionCentreLosses()
{
//Arrange
var mc = new ManagerController();
var reportBLL = new ReportBLL();
//Act
var result = mc.CentreList() as ViewResult;
var packages = (List <DistributionCentre>)result.ViewData.Model;
//Asert
Assert.IsNotNull(packages);
}
/// <summary>
/// Get report periods
/// </summary>
/// <returns>List of report periods</returns>
public List <ReportPeriod> GetReportPeriods()
{
try
{
return(ReportBLL.GetReportPeriods());
}
catch (Exception ex)
{
Log.Exception(ex.StackTrace);
Log.Exception(ex.Message);
throw ex;
}
}
private void GenerateReport()
{
ReportBLL cls = new ReportBLL();
try
{
DateTime dt1 = DateTime.Today;
DateTime dt2 = DateTime.Today;
DataTable dtExcel = new DataTable();
string vord = "D";
if (ddlType.SelectedIndex == 0)
{
dt1 = Convert.ToDateTime(txtFromDt.Text.Trim());
dt2 = Convert.ToDateTime(txtToDt.Text.Trim());
vord = "D";
}
else
{
vord = "V";
}
dtExcel = cls.GetDetentionReport(vord, dt1, dt2, ddlVoyage.SelectedValue, ddlVessel.SelectedValue, ddlLine.SelectedValue, ddlLoc.SelectedValue);
ExporttoExcel(dtExcel);
}
catch (Exception ex)
{
}
//ReportBLL cls = new ReportBLL();
//DateTime dtFrom = Convert.ToDateTime(txtFromDt.Text, _culture);
//DateTime dtTo = Convert.ToDateTime(txtToDt.Text, _culture);
//List<ImpInvRegisterEntity> lstReg = ReportBLL.GetImportInvoiceRegister(Convert.ToInt32(ddlLine.SelectedValue), Convert.ToInt32(ddlLoc.SelectedValue), Convert.ToInt32(ddlType.SelectedValue), dtFrom, dtTo);
//LocalReportManager reportManager = new LocalReportManager(rptViewer, "ImportInvRegister", ConfigurationManager.AppSettings["ReportNamespace"].ToString(), ConfigurationManager.AppSettings["ReportPath"].ToString());
//string rptName = "ImportInvRegister.rdlc";
//rptViewer.Reset();
//rptViewer.LocalReport.Dispose();
//rptViewer.LocalReport.DataSources.Clear();
//rptViewer.LocalReport.ReportPath = this.Server.MapPath(this.Request.ApplicationPath) + ConfigurationManager.AppSettings["ReportPath"].ToString() + "/" + rptName;
//rptViewer.LocalReport.DataSources.Add(new ReportDataSource("RptDataSet", lstReg));
//rptViewer.LocalReport.SetParameters(new ReportParameter("CompanyName", Convert.ToString(ConfigurationManager.AppSettings["CompanyName"])));
//rptViewer.LocalReport.SetParameters(new ReportParameter("Location", ddlLoc.SelectedItem.Text));
//rptViewer.LocalReport.SetParameters(new ReportParameter("Line", ddlLine.SelectedItem.Text));
//rptViewer.LocalReport.SetParameters(new ReportParameter("BillType", ddlType.SelectedItem.Text));
//rptViewer.LocalReport.SetParameters(new ReportParameter("FromDate", txtFromDt.Text));
//rptViewer.LocalReport.SetParameters(new ReportParameter("ToDate", txtToDt.Text));
//rptViewer.LocalReport.Refresh();
}
/// <summary>
/// Update report periods
/// </summary>
/// <param name="reportPeriods">List of report repiods</param>
/// <returns>True or false</returns>
public bool UpdateReportPeriods(List <ReportPeriod> reportPeriods)
{
try
{
ReportBLL.UpdateReportPeriods(reportPeriods);
return(true);
}
catch (Exception ex)
{
Log.Exception(ex.StackTrace);
Log.Exception(ex.Message);
throw ex;
}
}
// GET api/userreport
/// <summary>
///
/// </summary>
/// <param name="userID"></param>
/// <param name="model">0-仅本用户菜单，1-全部菜单</param>
/// <returns></returns>
public IEnumerable <UserReport> Get(decimal userID, short model)
{
switch (model)
{
case 0:
return(ReportBLL.ListUserReport(userID));
case 1:
return(ReportBLL.ListAllUserReport(userID));
default:
return(null);
}
}
private void BindData()
{
ReportBLL ReportBL = new ReportBLL(connectionString);
List <ReportViewModel> incident_reports = ReportBL.GetIncidentReportInventory();
foreach (ReportViewModel model in incident_reports)
{
model.Name = GetCarNameFromCarID(model.CarID);
string[] date_element = model.DateOfIncident.Split(' ');
model.DateOfIncident = date_element[0];
}
ReportList.DataSource = incident_reports;
ReportList.DataBind();
}
private void LoadCounters()
{
DataSet ds = new ReportBLL().GetAllItemGroup();
DataTable dt = ds.Tables[0];
DataRow dr = dt.NewRow();
dr["ItemGroupID"] = "0";
dr["Descr"] = "All Counters";
dt.Rows.InsertAt(dr, 0);
ddlCounters.DataValueField = "ItemGroupID";
ddlCounters.DataTextField = "Descr";
ddlCounters.DataSource = dt;
ddlCounters.DataBind();
}
protected void ReportEditButtonClick(object sender, EventArgs e)
{
if (Page.IsValid)
{
ReportBLL bll = new ReportBLL(connectionString);
ReportViewModel report = new ReportViewModel();
report.ReportID = Convert.ToInt32(Request.QueryString["ReportID"]);
report.ReportName = ReportName.Text;
report.ReportDescription = ReportDescription.Text;
report.DateOfIncident = Convert.ToDateTime(DateOfIncident.Text);
bll.EditReport(report);
Response.Redirect("~/Reports.aspx");
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
ReportBLL bll = new ReportBLL(connectionString);
ReportViewModel report = bll.GetReportById(Convert.ToInt32(Request.QueryString["ReportID"]));
ReportID.Text = report.ReportID.ToString();
DateOfIncident.Text = report.DateOfIncident.ToString();
CarID.Text = report.CarID.ToString();
ReportName.Text = report.ReportName;
ReportDescription.Text = report.ReportDescription;
}
}
protected void btnExcel_Click(object sender, EventArgs e)
{
ReportBLL cls = new ReportBLL();
try
{
DataTable dtExcel = new DataTable();
dtExcel = cls.GetGroundRentLOLOStatement(ddlLine.SelectedValue, ddlLoc.SelectedValue, ddlStatus.SelectedValue, txtStartDate.Text.Trim(), txtdtStock.Text.Trim(), ddlEmptyYard.SelectedValue.ToInt());
ExporttoExcel(dtExcel);
}
catch (Exception ex)
{
}
}
public void ManagerController_GlobalStock()
{
//Arrange
var mc = new ManagerController();
var reportBLL = new ReportBLL();
//Act
var result = mc.GlobalStock() as ViewResult;
var packages = (List <MedicationTypeViewData>)result.ViewData.Model;
var allpackages = reportBLL.GlobalStock();
//Asert
Assert.IsNotNull(packages);
Assert.AreEqual(packages.Count, allpackages.Count);
}
protected void btnPrint_Click(object sender, EventArgs e)
{
ReportBLL cls = new ReportBLL();
try
{
DateTime dt = Convert.ToDateTime(txtdtStock.Text.Trim());
DataTable dtExcel = new DataTable();
dtExcel = cls.GetTypeWiseStockSummary(ddlLine.SelectedValue, ddlLoc.SelectedValue, dt);
ExporttoExcel(dtExcel);
}
catch (Exception ex)
{
}
}