protected void btnImport_Click(object sender, EventArgs e)
{
DataTable dt = new DataTable();
string connectionString = String.Format(@"Provider=Microsoft.ACE.OLEDB.12.0;Data Source={0};Extended Properties=""Excel 8.0;HDR=YES;IMEX=1;""", Server.MapPath("~/UserFile/Data_2016.xls"));
//string query = String.Format("select * from [{0}$]", "Area");
string query = String.Format("select * from [{0}$]", "2014_2015");
OleDbDataAdapter dataAdapter = new OleDbDataAdapter(query, connectionString);
DataSet dataSet = new DataSet();
dataAdapter.Fill(dataSet);
DataTable myTable = dataSet.Tables[0];
EnterpriseService comBSO = new EnterpriseService();
foreach (DataRow drow in myTable.Rows)
{
ReportTemp2014 temp = new ReportTemp2014();
temp.Title = drow["Title"].ToString();
if (temp.Title != null && temp.Title != "")
{
temp.OrgId = Convert.ToInt32(drow["OrgId"]);
DataTable dtE = comBSO.GetDNByName(temp.Title, temp.OrgId);
if (drow["Address"] != null)
{
temp.Address = drow["Address"].ToString();
}
if (drow["AreaName"] != null && drow["AreaName"].ToString() != "")
{
temp.AreaName = drow["AreaName"].ToString();
if (drow["AreaName"].ToString() == "Công nghiệp")
{
temp.AreaId = 5;
}
else
if (drow["AreaName"].ToString() == "Nông nghiệp")
{
temp.AreaId = 3;
}
else
if (drow["AreaName"].ToString() == "Công trình xây dựng")
{
temp.AreaId = 6;
}
else
{
temp.AreaId = 1;
}
}
//Kiem phan nganh da co trong CSDL chua
if (drow["SubAreaName"] != null && drow["SubAreaName"].ToString() != "")
{
DataTable dtSub = new AreaService().getAreaByName(drow["SubAreaName"].ToString());
if (dtSub != null && dtSub.Rows.Count > 0)
{
temp.SubAreaId = Convert.ToInt32(dtSub.Rows[0]["Id"]);
}
else
{//Neu khong ton tai thi bo sung them phan nganh
Area sub = new Area();
sub.AreaName = drow["SubAreaName"].ToString();
sub.ParentId = temp.AreaId;
sub.IsStatus = 1;
sub.SortOrder = 0;
int subId = new AreaService().Insert(sub);
temp.SubAreaId = subId;
}
temp.SubAreaName = drow["SubAreaName"].ToString();
}
//Kiem tra xem doanh nghiep da ton tai
if (dtE != null && dtE.Rows.Count > 0)
{
if (dtE.Rows.Count == 1)
{
Enterprise area = new Enterprise();
int eId = Convert.ToInt32(dtE.Rows[0]["Id"]);
////area = new EnterpriseService().FindByKey(eId);
////area.SubAreaId = temp.SubAreaId;
////area.AreaId = temp.AreaId;
EnterpriseYearService eYService = new EnterpriseYearService();
EnterpriseYear ey = new EnterpriseYear();
ey.EnterpriseId = eId;
if (drow["No_TOE"] != null && drow["No_TOE"].ToString().Trim() != "")
{
ey.No_TOE = Convert.ToDecimal(drow["No_TOE"]);
}
ey.IsDelete = false;
ey.Year = 2016;
eYService.Insert(ey);//Insert vao doanh nghiep trong diem nam
temp.EnterpriseId = eId;
if (drow["Dien_kWh"] != null && drow["Dien_kWh"].ToString().Trim() != "")
{
temp.Dien_kWh = drow["Dien_kWh"].ToString();
}
if (drow["Than_Tan"] != null && drow["Than_Tan"].ToString().Trim() != "")
{
temp.Than_Tan = drow["Than_Tan"].ToString();
}
if (drow["DO_Tan"] != null && drow["DO_Tan"].ToString().Trim() != "")
{
temp.DO_Tan = drow["DO_Tan"].ToString();
}
if (drow["DO_lit"] != null && drow["DO_lit"].ToString().Trim() != "")
{
temp.DO_lit = drow["DO_lit"].ToString();
}
if (drow["FO_Tan"] != null && drow["FO_Tan"].ToString().Trim() != "")
{
temp.FO_Tan = drow["FO_Tan"].ToString();
}
if (drow["FO_lit"] != null && drow["FO_lit"].ToString().Trim() != "")
{
temp.FO_lit = drow["FO_Tan"].ToString();
}
if (drow["Xang_Tan"] != null && drow["Xang_Tan"].ToString().Trim() != "")
{
temp.Xang_Tan = drow["Xang_Tan"].ToString();
}
if (drow["Xang_lit"] != null && drow["Xang_lit"].ToString().Trim() != "")
{
temp.Xang_lit = drow["Xang_lit"].ToString();
}
if (drow["Gas_Tan"] != null && drow["Gas_Tan"].ToString().Trim() != "")
{
temp.Gas_Tan = drow["Gas_Tan"].ToString();
}
if (drow["Khi_m3"] != null && drow["Khi_m3"].ToString().Trim() != "")
{
temp.Khi_M3 = drow["Khi_m3"].ToString();
}
if (drow["LPG_Tan"] != null && drow["LPG_Tan"].ToString().Trim() != "")
{
temp.LPG_Tan = drow["LPG_Tan"].ToString();
}
if (drow["NLPL_Tan"] != null && drow["NLPL_Tan"].ToString().Trim() != "")
{
temp.NLPL_Tan = drow["NLPL_Tan"].ToString();
}
if (drow["Khac_tan"] != null && drow["Khac_tan"].ToString().Trim() != "")
{
temp.KhacSoDo = drow["Khac_tan"].ToString();
}
if (drow["No_TOE"] != null && drow["No_TOE"].ToString().Trim() != "" && Convert.ToDecimal(drow["No_TOE"]) > 0)
{
temp.No_TOE = Convert.ToDecimal(drow["No_TOE"]);
}
temp.Year = 2016;
int retTemp = new ReportTemp2014Service().Insert(temp);//Them bao cao tam
}
else
{
if (drow["Dien_kWh"] != null && drow["Dien_kWh"].ToString().Trim() != "")
{
temp.Dien_kWh = drow["Dien_kWh"].ToString();
}
if (drow["Than_Tan"] != null && drow["Than_Tan"].ToString().Trim() != "")
{
temp.Than_Tan = drow["Than_Tan"].ToString();
}
if (drow["DO_Tan"] != null && drow["DO_Tan"].ToString().Trim() != "")
{
temp.DO_Tan = drow["DO_Tan"].ToString();
}
if (drow["DO_lit"] != null && drow["DO_lit"].ToString().Trim() != "")
{
temp.DO_lit = drow["DO_lit"].ToString();
}
if (drow["FO_Tan"] != null && drow["FO_Tan"].ToString().Trim() != "")
{
temp.FO_Tan = drow["FO_Tan"].ToString();
}
if (drow["FO_lit"] != null && drow["FO_lit"].ToString().Trim() != "")
{
temp.FO_lit = drow["FO_Tan"].ToString();
}
if (drow["Xang_Tan"] != null && drow["Xang_Tan"].ToString().Trim() != "")
{
temp.Xang_Tan = drow["Xang_Tan"].ToString();
}
if (drow["Xang_lit"] != null && drow["Xang_lit"].ToString().Trim() != "")
{
temp.Xang_lit = drow["Xang_lit"].ToString();
}
if (drow["Gas_Tan"] != null && drow["Gas_Tan"].ToString().Trim() != "")
{
temp.Gas_Tan = drow["Gas_Tan"].ToString();
}
if (drow["Khi_m3"] != null && drow["Khi_m3"].ToString().Trim() != "")
{
temp.Khi_M3 = drow["Khi_m3"].ToString();
}
if (drow["LPG_Tan"] != null && drow["LPG_Tan"].ToString().Trim() != "")
{
temp.LPG_Tan = drow["LPG_Tan"].ToString();
}
if (drow["NLPL_Tan"] != null && drow["NLPL_Tan"].ToString().Trim() != "")
{
temp.NLPL_Tan = drow["NLPL_Tan"].ToString();
}
if (drow["Khac_tan"] != null && drow["Khac_tan"].ToString().Trim() != "")
{
temp.KhacSoDo = drow["Khac_tan"].ToString();
}
if (drow["No_TOE"] != null && drow["No_TOE"].ToString().Trim() != "" && Convert.ToDecimal(drow["No_TOE"]) > 0)
{
temp.No_TOE = Convert.ToDecimal(drow["No_TOE"]);
}
temp.Year = 2016;
if (dtE.Rows.Count > 1)
{
temp.Note = "Tim thay " + dtE.Rows.Count + " DN";
}
else
{
temp.Note = "Khong tim thay " + dtE.Rows.Count + " DN";
}
int retTemp = new ReportTemp2014Service().Insert(temp);//Them bao cao tam
}
}
else
{
if (drow["Dien_kWh"] != null && drow["Dien_kWh"].ToString().Trim() != "")
{
temp.Dien_kWh = drow["Dien_kWh"].ToString();
}
if (drow["Than_Tan"] != null && drow["Than_Tan"].ToString().Trim() != "")
{
temp.Than_Tan = drow["Than_Tan"].ToString();
}
if (drow["DO_Tan"] != null && drow["DO_Tan"].ToString().Trim() != "")
{
temp.DO_Tan = drow["DO_Tan"].ToString();
}
if (drow["DO_lit"] != null && drow["DO_lit"].ToString().Trim() != "")
{
temp.DO_lit = drow["DO_lit"].ToString();
}
if (drow["FO_Tan"] != null && drow["FO_Tan"].ToString().Trim() != "")
{
temp.FO_Tan = drow["FO_Tan"].ToString();
}
if (drow["FO_lit"] != null && drow["FO_lit"].ToString().Trim() != "")
{
temp.FO_lit = drow["FO_Tan"].ToString();
}
if (drow["Xang_Tan"] != null && drow["Xang_Tan"].ToString().Trim() != "")
{
temp.Xang_Tan = drow["Xang_Tan"].ToString();
}
if (drow["Xang_lit"] != null && drow["Xang_lit"].ToString().Trim() != "")
{
temp.Xang_lit = drow["Xang_lit"].ToString();
}
if (drow["Gas_Tan"] != null && drow["Gas_Tan"].ToString().Trim() != "")
{
temp.Gas_Tan = drow["Gas_Tan"].ToString();
}
if (drow["Khi_m3"] != null && drow["Khi_m3"].ToString().Trim() != "")
{
temp.Khi_M3 = drow["Khi_m3"].ToString();
}
if (drow["LPG_Tan"] != null && drow["LPG_Tan"].ToString().Trim() != "")
{
temp.LPG_Tan = drow["LPG_Tan"].ToString();
}
if (drow["NLPL_Tan"] != null && drow["NLPL_Tan"].ToString().Trim() != "")
{
temp.NLPL_Tan = drow["NLPL_Tan"].ToString();
}
if (drow["Khac_tan"] != null && drow["Khac_tan"].ToString().Trim() != "")
{
temp.KhacSoDo = drow["Khac_tan"].ToString();
}
if (drow["No_TOE"] != null && drow["No_TOE"].ToString().Trim() != "" && Convert.ToDecimal(drow["No_TOE"]) > 0)
{
temp.No_TOE = Convert.ToDecimal(drow["No_TOE"]);
}
temp.Year = 2016;
temp.Note = "Khong tim thay " + dtE.Rows.Count + " DN";
int retTemp = new ReportTemp2014Service().Insert(temp);//Them bao cao tam
}
}
}
}
public ObjectResultEx AuditGoodSuccess(SimpleParam <Guid> Param)
{
return(ObjectResultEx.Instance(EnterpriseService.AuditGoodSuccess(Param.Id), 1, RetrunMessge.SUCCESS, HttpCode.Success));
}
public ObjectResultEx AddEnterpriseParentMenu()
{
return(ObjectResultEx.Instance(EnterpriseService.AddEnterpriseParentMenu(), 1, RetrunMessge.SUCCESS, HttpCode.Success));
}
public ObjectResultEx RegistCompanyAccount(SimpleParam <RequestEnterprise> Param)
{
return(ObjectResultEx.Instance(EnterpriseService.RegistCompanyAccount(Param.Parameter), 1, RetrunMessge.SUCCESS, HttpCode.Success));
}
public ObjectResultEx GetTagAuditDetail(RequestAudit Param)
{
return(ObjectResultEx.Instance(EnterpriseService.GetTagAuditDetail(Param), 1, RetrunMessge.SUCCESS, HttpCode.Success));
}
public ObjectResultEx RemoveEnterpriseRoleAuthor(SimpleParam <Guid> Param)
{
return(ObjectResultEx.Instance(EnterpriseService.RemoveEnterpriseRoleAuthor(Param.Id), 1, RetrunMessge.SUCCESS, HttpCode.Success));
}
public ObjectResultEx DistributionRole(RequestEnterpriseRoleAuthor Param)
{
return(ObjectResultEx.Instance(EnterpriseService.DistributionRole(Param), 1, RetrunMessge.SUCCESS, HttpCode.Success));
}
protected void voidbindexcel(int Idbaocao)
{
#region get data
WordExtend ex = new WordExtend();
string temp = "TempReport/TemMauBaoCao" + drpmaubaocao.SelectedValue + ".dot";
ex.OpenFile(Server.MapPath(ResolveUrl("~") + temp));
Enterprise or = new Enterprise();
EnterpriseService orser = new EnterpriseService();
or = orser.FindByKey(Convert.ToInt32(memVal.OrgId));
if (or != null)
{
ex.WriteToMergeField("BC_Title", or.Title);
}
else
{
ex.WriteToMergeField("BC_Title", "");
}
ex.WriteToMergeField("BC_Year", DateTime.Now.Year.ToString());
ex.WriteToMergeField("BC_NgayLap", DateTime.Now.ToString("dd/MM/yyyy"));
DataTable dt = new DataTable();
DataTable dthientai = new DataTable();
DataTable dtdukien = new DataTable();
DataSet dshientai = new DataSet("tbl1");
DataSet dsdukien = new DataSet("tbl1");
if (memVal.OrgId > 0)
{
dt = new ReportFuelService().GetReportByxuatphieu(Idbaocao);
}
// DataRow dr;
dt.Columns.Add("dvnhietnang", typeof(string));
dt.Columns.Add("dvnhieulieu", typeof(string));
dthientai = dt.Clone();
dtdukien = dt.Clone();
foreach (DataRow item in dt.Rows)
{
if (Convert.ToBoolean(item["IsNextYear"]) == true)
{
DataRow workRow = null;
workRow = dtdukien.NewRow();
workRow = item;
if (workRow["MeasurementName"].ToString().Contains("Mét khối"))
{
workRow["dvnhietnang"] = "kJ/m3";
}
else
{
workRow["dvnhietnang"] = "kJ/kg";
}
if (workRow["MeasurementName"].ToString().Contains("tấn") || workRow["MeasurementName"].ToString().Contains("Klg"))
{
workRow["dvnhieulieu"] = "kJ/tấn";
}
else
{
workRow["dvnhieulieu"] = "đ/m3";
}
workRow.AcceptChanges();
dtdukien.ImportRow(workRow);
dtdukien.AcceptChanges();
}
else
{
DataRow workRow = null;
workRow = dthientai.NewRow();
workRow = item;
if (workRow["MeasurementName"].ToString().Contains("Mét khối"))
{
workRow["dvnhietnang"] = "kJ/m3";
}
else
{
workRow["dvnhietnang"] = "kJ/kg";
}
if (workRow["MeasurementName"].ToString().Contains("tấn") || workRow["MeasurementName"].ToString().Contains("Klg"))
{
workRow["dvnhieulieu"] = "kJ/tấn";
}
else
{
workRow["dvnhieulieu"] = "đ/m3";
}
workRow.AcceptChanges();
dthientai.AcceptChanges();
dthientai.ImportRow(workRow);
}
}
dshientai.Merge(dthientai);
if (dshientai.Tables.Count > 0)
{
dshientai.Tables[0].TableName = "tbl1";
ex.WriteDataSetToMergeField(dshientai);
}
dsdukien.Merge(dtdukien);
if (dsdukien.Tables.Count > 0)
{
dsdukien.Tables[0].TableName = "tbl2";
ex.WriteDataSetToMergeField(dsdukien);
}
// dsg.Tables.Add(dst);
//var dt2 = ExcelExportHelper.CreateGroupInDT(dt, "DepName", "STT");
#endregion
ex.Save(Server.MapPath(ResolveUrl("~") + "TempReport/mauBaoCao.dot"));
HttpContext.Current.Response.Redirect(string.Format("~/Download.aspx?fp={0}&fn={1}",
Path.GetFileName(Server.MapPath(ResolveUrl("~") + "TempReport/mauBaoCao.dot")),
""
));
}
protected void OnButtonCommand(object sender, CommandEventArgs e)
{
//Event handler for command button clicked
try {
//Change view to Viewer and reset to clear existing data
Master.Viewer.Reset();
//Get parameters for the query
string _ofddate = this.ddpDelivery.FromDate.ToString("yyyy-MM-dd");
//Initialize control values
LocalReport report = Master.Viewer.LocalReport;
report.DisplayName = REPORT_NAME;
report.EnableExternalImages = true;
EnterpriseService enterprise = new EnterpriseService();
DataSet ds = enterprise.FillDataset(USP_REPORT, TBL_REPORT, new object[] { _ofddate });
if (ds.Tables[TBL_REPORT].Rows.Count >= 0)
{
switch (e.CommandName)
{
case "Run":
//Set local report and data source
System.IO.Stream stream = Master.GetReportDefinition(REPORT_SRC);
report.LoadReportDefinition(stream);
report.DataSources.Clear();
report.DataSources.Add(new ReportDataSource(REPORT_DS, ds.Tables[TBL_REPORT]));
//Set the report parameters for the report
ReportParameter rdddate = new ReportParameter("RequestedDeliveryDate", _ofddate);
report.SetParameters(new ReportParameter[] { rdddate });
//Update report rendering with new data
report.Refresh();
break;
case "Data":
//Set local export report and data source
report.LoadReportDefinition(Master.CreateExportRdl(ds, REPORT_DS, "RGXVMSQLR.TSORT"));
report.DataSources.Clear();
report.DataSources.Add(new ReportDataSource(REPORT_DS, ds.Tables[TBL_REPORT]));
report.Refresh(); break;
case "Excel":
//Create Excel mime-type page
Response.ClearHeaders();
Response.Clear();
Response.Charset = "";
Response.AddHeader("Content-Disposition", "inline; filename=RequestedDeliveryDate.xls");
Response.ContentType = "application/vnd.ms-excel"; //application/octet-stream";
System.IO.StringWriter sw = new System.IO.StringWriter();
System.Web.UI.HtmlTextWriter hw = new System.Web.UI.HtmlTextWriter(sw);
DataGrid dg = new DataGrid();
dg.DataSource = ds.Tables[TBL_REPORT];
dg.DataBind();
dg.RenderControl(hw);
Response.Write(sw.ToString());
Response.End();
break;
}
}
else
{
Master.Status = "There were no records found.";
}
}
catch (Exception ex) { Master.ReportError(ex, 3); }
}
static void Main(string[] args)
{
////海运订阅DEMO
//#region 海运订阅
////创建海运订阅对象
//YDN.Tracking.Shipping seaTrack = new YDN.Tracking.Shipping("云当企业代码", "云当秘钥");
//#region 海运批量订阅
////订阅的对象数组
//List<YDN.Tracking.Shipping.Filter> filterLst = new List<YDN.Tracking.Shipping.Filter>();
////对象
//YDN.Tracking.Shipping.Filter filter = new YDN.Tracking.Shipping.Filter
//{
// blno = "966877857",
// carriercd = "MSK",
// portcd = "CNSZX"
//};
//filterLst.Add(filter);
////批量上传订阅
//var uploadResult = seaTrack.BookingUploadLst(filterLst);
////批量下载订阅数据
//var downloadResult = seaTrack.BookingDownloadLst(filterLst);
//#endregion
//#region 海运单票查询订阅
////单票查询并订阅
//var result = seaTrack.BookingBlno("966877857", "", "MSK", "CNSZX");
//#endregion
//#endregion
////空运订阅DEMO
//#region 空运订阅
////创建空运订阅对象
//YDN.Tracking.Flight airTrack = new YDN.Tracking.Flight("云当企业代码", "云当秘钥");
//#region 空运批量订阅
////订阅的对象数组
List <YDN.Tracking.Flight.Filter> airFilterLst = new List <YDN.Tracking.Flight.Filter>();
//单票订阅
var shippingFilter = new YDN.Tracking.Shipping.Filter
{
//订阅号（提单号或订舱号都可）
ReferenceNo = "WMHB004074",
//箱号（使用箱号订阅时必填，否则可不填）
CtnrNo = "",
//船东代码（必填，详见云当船东代码）
CarrierCd = "CMA"
};
var shippingFilterList = new List <YDN.Tracking.Shipping.Filter> {
shippingFilter
};
//var resultSubscribe = EnterpriseService.GetInstance("云当企业代码", "云当秘钥").Shipping().Subscribe(shippingFilter);
//var resultData = EnterpriseService.GetInstance("云当企业代码", "云当秘钥").Shipping().GetData(shippingFilter);
//YDN.Tracking.Shipping.BookingResult
//成功调用结果
//result={status:0,message:null};
//失败调用结果
//result={status:1,message:"船东代码不可为空"};
//调用结果result对象结构,YDN.ApiResponse
//{
// /// <summary>
// /// 调用结果代码：0=成功；1=失败
// /// </summary>
// public int status { get; set; }
// /// <summary>
// /// 错误信息
// /// </summary>
// public string message { get; set; }
//}
//airFilterLst.Add(airFilter);
////空运批量上传订阅
//var uploadAirResult = airTrack.BookingUploadLst(airFilterLst);
////空运批量下载订阅数据
//var downloadAirResult = airTrack.BookingDownloadLst(airFilterLst);
//#endregion
////空运单票订阅
//#region 空运单票订阅
//var airResult = airTrack.BookingAwbno("07419533780", "KL");
//#endregion
//#endregion
#region service test
var es = EnterpriseService.GetInstance("云当企业代码", "云当秘钥");
//var result = EnterpriseService.GetInstance("云当企业代码", "云当秘钥").Flight().Subscribe(airFilter);
var resultList = EnterpriseService.GetInstance("云当企业代码", "云当秘钥").Flight().Subscribe(airFilterLst);
//var result2 = EnterpriseService.GetInstance("云当企业代码", "云当秘钥").Shipping().Subscribe(shippingFilter);
//var resultList2 = EnterpriseService.GetInstance("云当企业代码", "云当秘钥").Shipping().Subscribe(airFilterLst);
var resultList3 = EnterpriseService.GetInstance("云当企业代码", "云当秘钥").Shipping().GetData(shippingFilterList);
#endregion
}
protected void OnButtonCommand(object sender, CommandEventArgs e)
{
//Event handler for command button clicked
try {
//Change view to Viewer and reset to clear existing data
Master.Viewer.Reset();
//Get parameters for the query
string _client = this.cboClient.SelectedValue != "" ? this.cboClient.SelectedValue : null;
string _division = null;
string _agent = null;
string _region = null;
string _district = null;
string _store = this.cboParam.SelectedValue == "Stores" && this.txtStore.Text.Length > 0 ? this.txtStore.Text : null;
string _start = this.cboDateValue.SelectedValue.Split(',')[1].Split(':')[0].Trim();
string _end = this.cboDateValue.SelectedValue.Split(',')[1].Split(':')[1].Trim();
//Initialize control values
LocalReport report = Master.Viewer.LocalReport;
report.DisplayName = REPORT_NAME;
report.EnableExternalImages = true;
EnterpriseService enterprise = new EnterpriseService();
DataSet ds = enterprise.FillDataset(USP_REPORT, TBL_REPORT, new object[] { _client, _division, _agent, _region, _district, _store, _start, _end });
if (ds.Tables[TBL_REPORT].Rows.Count >= 0)
{
switch (e.CommandName)
{
case "Run":
//Set local report and data source
System.IO.Stream stream = Master.GetReportDefinition(REPORT_SRC);
report.LoadReportDefinition(stream);
report.DataSources.Clear();
report.DataSources.Add(new ReportDataSource(REPORT_DS, ds.Tables[TBL_REPORT]));
//Set the report parameters for the report
ReportParameter clientName = new ReportParameter("ClientName", this.cboClient.SelectedItem.Text);
ReportParameter client = new ReportParameter("ClientNumber", _client);
ReportParameter division = new ReportParameter("Division", _division);
ReportParameter agent = new ReportParameter("AgentNumber", _agent);
ReportParameter region = new ReportParameter("Region", _region);
ReportParameter district = new ReportParameter("District", _district);
ReportParameter store = new ReportParameter("StoreNumber", _store);
ReportParameter start = new ReportParameter("StartDate", _start);
ReportParameter end = new ReportParameter("EndDate", _end);
report.SetParameters(new ReportParameter[] { client, division, agent, region, district, store, start, end, clientName });
//Update report rendering with new data
report.Refresh();
if (!Master.Viewer.Enabled)
{
Master.Viewer.CurrentPage = 1;
}
break;
}
}
else
{
Master.ShowMessageBox("There were no records found.");
}
}
catch (Exception ex) { Master.ReportError(ex, 4); }
}
private void BindData()
{
EnterpriseService comBSO = new EnterpriseService();
DataTable dt = new DataTable();
int AreaId = 0;
int SubAreaId = 0;
int OrgId = 0;
int Year = 0;
string strclientview = string.Empty;
string strKey = string.Empty;
if (txtKeyword.Text != "" && txtKeyword.Text.Trim() != "")
{
strKey = txtKeyword.Text.Trim();
}
if (ddlArea.SelectedIndex > 0)
{
AreaId = Convert.ToInt32(ddlArea.SelectedValue);
}
if (ddlSubArea.SelectedIndex > 0)
{
SubAreaId = Convert.ToInt32(ddlSubArea.SelectedValue);
}
if (ddlOrg.SelectedIndex > 0)
{
OrgId = Convert.ToInt32(ddlOrg.SelectedValue);
}
if (ddlYear.SelectedIndex > 0)
{
Year = Convert.ToInt32(ddlYear.SelectedValue);
}
ePower.Core.PagingInfo paging = new ePower.Core.PagingInfo(PageSize, CurrentPage);
dt = comBSO.GetDataTable(Year, AreaId, SubAreaId, OrgId, 0, 0, null, strKey, paging);
if (dt != null && dt.Rows.Count > 0)
{
paging.RowsCount = Convert.ToInt32(dt.Rows[0]["Total"]);
Paging.PageSize = PageSize;
Paging.CurrentPage = CurrentPage;
Paging.TotalRecord = Convert.ToInt32(dt.Rows[0]["Total"]);
Paging.DataLoad();
if (paging.PagesCount <= 1)
{
strclientview = "Tổng số có " + paging.RowsCount + " doanh nghiệp";
Paging.Visible = false;
}
else
{
int st = (CurrentPage - 1) * PageSize + 1;
long end = CurrentPage * PageSize;
if (end > paging.RowsCount)
{
end = paging.RowsCount;
}
strclientview = "Đang xem trang " + CurrentPage + ". Hiển thị từ " + st + " - " + end + " trên tổng số " + paging.RowsCount + " doanh nghiệp";
Paging.Visible = true;
}
}
else
{
strclientview = "";
Paging.Visible = false;
}
grvNewsGroup.DataSource = dt;
grvNewsGroup.DataBind();
clientview.Text = strclientview;
}
protected void btnAddReport_Click(object sender, EventArgs e)
{
ltErr.Text = "";
if (memVal.OrgId > 0)
{
ReportFuelService reportService = new ReportFuelService();
int ReportYear = Convert.ToInt32(ddlYear.SelectedValue);
//int iReportNo = reportService.CheckReport(ReportYear, memVal.OrgId);
int iReportNo = reportService.CheckReportWithType(ReportYear, memVal.OrgId, ReportKey.PLAN);
if (iReportNo > 0)
{
ltErr.Text = "<span style='color:red'>Đã có báo cáo hàng năm của năm " + ddlYear.SelectedValue + ". Vui lòng chọn năm báo cáo khác.</span>";
//ScriptManager.RegisterStartupScript(this, GetType(), "addReport", "alert('Đã có báo cáo cho năm " + ddlYear.SelectedValue + ". Vui lòng chọn năm báo cáo khác');ShowDialogInitReport();", true);
ScriptManager.RegisterStartupScript(this, GetType(), "addReport", "ShowDialogInitReport();", true);
}
else
{
ReportFuel report = new ReportFuel();
report.EnterpriseId = Convert.ToInt32(memVal.OrgId);
Enterprise enter = new EnterpriseService().FindByKey(report.EnterpriseId);
if (enter != null)
{
if (enter.ProvinceId > 0)
{
report.ProviceId = enter.ProvinceId;
}
if (enter.DistrictId > 0)
{
report.DistrictId = enter.DistrictId;
}
if (enter.AreaId > 0)
{
report.AreaId = enter.AreaId;
}
if (enter.SubAreaId > 0)
{
report.SubAreaId = enter.SubAreaId;
}
report.ReporterName = enter.ManPerson;
IFormatProvider culture = new System.Globalization.CultureInfo("en-US", true);
report.ReportDate = DateTime.Now;
report.Address = enter.Address;
report.Email = enter.Email;
report.Phone = enter.Phone;
report.Fax = enter.Fax;
report.ParentName = enter.ParentName;
report.TaxCode = enter.TaxCode;
report.FaxParent = enter.ManFax;
report.PhoneParent = enter.ManPhone;
report.EmailParent = enter.ManEmail;
report.AddressParent = enter.ManAddress;
report.ProvinceParentId = enter.ManProvinceId;
report.DistrictParentId = enter.ManDistrictId;
report.CompanyName = enter.Title;
report.Responsible = enter.ManPerson;
report.ReportType = ReportKey.PLAN;
if (enter != null)
{
report.OrganizationId = enter.OrganizationId;
}
}
if (ddlYear.SelectedIndex > 0)
{
report.Year = Convert.ToInt32(ddlYear.SelectedValue);
}
report.IsFiveYear = false;
int ret = reportService.Insert(report);
if (ret > 0)
{
//Plan plan = new Plan();
//plan.CreateByUser = memVal.UserId;
//plan.CreateDate = DateTime.Now;
//plan.BeginYear = faqs.Year + 1;
//plan.EndYear = faqs.Year + 6;
//plan.EnterpriseId = faqs.EnterpriseId;
//plan.ReportId = ret;
//plan.ReportDate = faqs.ReportDate;
//new PlanService().Insert(plan);
EnterpriseYearService yearService = new EnterpriseYearService();
if (yearService.UpdateTOE(memVal.OrgId, report.Year, ret, 0, 0) <= 0)
{
EnterpriseYear year = new EnterpriseYear();
year.EnterpriseId = memVal.OrgId;
year.Year = report.Year;
year.No_TOE = 0;
year.NoTOE_Plan = 0;
year.IsKey = true;
yearService.Insert(year);
}
Response.Redirect(ResolveUrl("~") + "bao-cao-so-lieu-hang-nam-r" + ret + ".aspx");
}
else
{
ltErr.Text = "Chưa tạo được báo cáo. Vui lòng thử lại.";
ScriptManager.RegisterStartupScript(this, GetType(), "addReport", "ShowDialogInitReport();", true);
}
}
}
}
private void BindData()
{
if (ReportId > 0)
{
try
{
ReportFuel faqs = new ReportFuel();
ReportFuelService faqsBSO = new ReportFuelService();
faqs = faqsBSO.FindByKey(ReportId);
if (memVal.OrgId > 0 && faqs.EnterpriseId != Convert.ToInt32(memVal.OrgId))//Neu
{
Response.Redirect(ResolveUrl("~"));
}
txtReportName.Text = faqs.ReporterName;
txtCreated.Text = String.Format("{0:dd/MM/yyyy}", faqs.ReportDate);//DateTime.Parse(faqs.PostDate.ToString()).ToString("dd/MM/yyyy hh:mm", ci); // faqs.PostDate.ToString();
if (faqs.EnterpriseId > 0)
{
Enterprise enter = new EnterpriseService().FindByKey(faqs.EnterpriseId);
if (enter.ManProvinceId > 0)
{
ddlProvinceReporter.SelectedValue = enter.ManProvinceId.ToString();
}
if (enter.ManDistrictId > 0)
{
ddlProvinceReporter.SelectedValue = enter.ManDistrictId.ToString();
}
if (faqs.AreaId > 0)
{
ddlArea.SelectedValue = enter.AreaId.ToString();
BindSubArea();
}
if (faqs.SubAreaId > 0)
{
ddlSubArea.SelectedValue = enter.SubAreaId.ToString();
}
if (faqs.ProviceId > 0)
{
ddlProvince.SelectedValue = enter.ProvinceId.ToString();
}
if (faqs.DistrictId > 0)
{
ddlDistrict.SelectedValue = enter.DistrictId.ToString();
}
txtAddressReporter.Text = enter.ManAddress;
txtReportName.Text = enter.ManPerson;
txtFaxReporter.Text = enter.ManFax;
txtEmail.Text = enter.Email;
txtFax.Text = enter.Fax;
txtPhone.Text = enter.Phone;
txtAddress.Text = enter.Address;
}
if (faqs.AreaId > 0)
{
ddlArea.SelectedValue = faqs.AreaId.ToString();
}
if (faqs.SubAreaId > 0)
{
ddlSubArea.SelectedValue = faqs.SubAreaId.ToString();
}
if (faqs.ProviceId > 0)
{
ddlProvinceReporter.SelectedValue = faqs.ProviceId.ToString();
}
if (faqs.DistrictId > 0)
{
ddlDistrictReporter.SelectedValue = faqs.DistrictId.ToString();
}
txtAddressReporter.Text = faqs.Address;
txtReportName.Text = faqs.ReporterName;
txtEmail.Text = faqs.Email;
txtFaxReporter.Text = faqs.Fax;
txtPhoneReporter.Text = faqs.Phone;
if (faqs.Year > 0)
{
ddlYear.SelectedValue = faqs.Year.ToString();
}
BindReportDetail();
}
catch (Exception ex)
{
clientview.Text = ex.Message.ToString();
}
}
else
{
Enterprise enter = new EnterpriseService().FindByKey(1);
if (enter.ManProvinceId > 0)
{
ddlProvinceReporter.SelectedValue = enter.ManProvinceId.ToString();
}
if (enter.ManDistrictId > 0)
{
ddlProvinceReporter.SelectedValue = enter.ManDistrictId.ToString();
}
txtAddressReporter.Text = enter.ManAddress;
txtReportName.Text = enter.ManPerson;
txtFaxReporter.Text = enter.ManFax;
txtPhoneReporter.Text = enter.ManPhone;
txtEmail.Text = enter.Email;
txtAddress.Text = enter.Address;
txtPhone.Text = enter.Phone;
if (enter.AreaId > 0)
{
ddlArea.SelectedValue = enter.AreaId.ToString();
}
if (enter.SubAreaId > 0)
{
ddlSubArea.SelectedValue = enter.SubAreaId.ToString();
}
if (enter.ProvinceId > 0)
{
ddlProvince.SelectedValue = enter.ProvinceId.ToString();
}
if (enter.DistrictId > 0)
{
ddlDistrict.SelectedValue = enter.DistrictId.ToString();
}
}
}
protected void btnImportTemp_Click(object sender, EventArgs e)
{
DataTable dt = new DataTable();
string connectionString = String.Format(@"Provider=Microsoft.ACE.OLEDB.12.0;Data Source={0};Extended Properties=""Excel 8.0;HDR=YES;IMEX=1;""", Server.MapPath("~/UserFile/Data_2016.xls"));
//string query = String.Format("select * from [{0}$]", "Area");
string query = String.Format("select * from [{0}$]", "Nam_2016");
SecurityBSO securityBSO = new SecurityBSO();
OleDbDataAdapter dataAdapter = new OleDbDataAdapter(query, connectionString);
DataSet dataSet = new DataSet();
dataAdapter.Fill(dataSet);
DataTable myTable = dataSet.Tables[0];
EnterpriseService comBSO = new EnterpriseService();
foreach (DataRow drow in myTable.Rows)
{
ReportTemp2014 temp = new ReportTemp2014();
Enterprise area = new Enterprise();
area.Title = drow["Title"].ToString();
temp.Title = area.Title;
if (drow["Address"] != null)
{
area.Address = drow["Address"].ToString();
temp.Address = area.Address;
}
area.OrganizationId = Convert.ToInt32(drow["OrgId"]);
temp.OrgId = area.OrganizationId;
Organization org = new OrganizationService().FindByKey(area.OrganizationId);
if (drow["AreaName"] != null && drow["AreaName"].ToString() != "")
{
temp.AreaName = drow["AreaName"].ToString();
if (drow["AreaName"].ToString() == "Công nghiệp")
{
area.AreaId = 5;
}
else
if (drow["AreaName"].ToString() == "Nông nghiệp")
{
area.AreaId = 3;
}
else
if (drow["AreaName"].ToString() == "Công trình xây dựng")
{
area.AreaId = 6;
}
else
{
area.AreaId = 1;
}
temp.AreaId = area.AreaId;
}
if (drow["SubAreaName"] != null && drow["SubAreaName"].ToString() != "")
{
DataTable dtSub = new AreaService().getAreaByName(drow["SubAreaName"].ToString());
if (dtSub != null && dtSub.Rows.Count > 0)
{
area.SubAreaId = Convert.ToInt32(dtSub.Rows[0]["Id"]);
temp.SubAreaId = area.SubAreaId;
}
else
{
Area sub = new Area();
sub.AreaName = drow["SubAreaName"].ToString();
sub.ParentId = area.AreaId;
sub.IsStatus = 1;
sub.SortOrder = 0;
int subId = new AreaService().Insert(sub);
temp.SubAreaId = subId;
area.SubAreaId = subId;
}
area.Info = drow["SubAreaName"].ToString();
temp.SubAreaName = drow["SubAreaName"].ToString();
}
area.ProvinceId = Convert.ToInt32(drow["ProvinceId"]);
area.ManProvinceId = Convert.ToInt32(drow["ManProvinceId"]);
int eId = comBSO.Insert(area);//Them doanh nghiep
if (eId > 0)
{
temp.EnterpriseId = eId;
if (drow["Dien_kWh"] != null && drow["Dien_kWh"].ToString().Trim() != "")
{
temp.Dien_kWh = drow["Dien_kWh"].ToString();
}
if (drow["Than_Tan"] != null && drow["Than_Tan"].ToString().Trim() != "")
{
temp.Than_Tan = drow["Than_Tan"].ToString();
}
if (drow["DO_Tan"] != null && drow["DO_Tan"].ToString().Trim() != "")
{
temp.DO_Tan = drow["DO_Tan"].ToString();
}
if (drow["DO_lit"] != null && drow["DO_lit"].ToString().Trim() != "")
{
temp.DO_lit = drow["DO_lit"].ToString();
}
if (drow["FO_Tan"] != null && drow["FO_Tan"].ToString().Trim() != "")
{
temp.FO_Tan = drow["FO_Tan"].ToString();
}
if (drow["FO_lit"] != null && drow["FO_lit"].ToString().Trim() != "")
{
temp.FO_lit = drow["FO_Tan"].ToString();
}
if (drow["Xang_Tan"] != null && drow["Xang_Tan"].ToString().Trim() != "")
{
temp.Xang_Tan = drow["Xang_Tan"].ToString();
}
if (drow["Xang_lit"] != null && drow["Xang_lit"].ToString().Trim() != "")
{
temp.Xang_lit = drow["Xang_lit"].ToString();
}
if (drow["Gas_Tan"] != null && drow["Gas_Tan"].ToString().Trim() != "")
{
temp.Gas_Tan = drow["Gas_Tan"].ToString();
}
if (drow["Khi_m3"] != null && drow["Khi_m3"].ToString().Trim() != "")
{
temp.Khi_M3 = drow["Khi_m3"].ToString();
}
if (drow["LPG_Tan"] != null && drow["LPG_Tan"].ToString().Trim() != "")
{
temp.LPG_Tan = drow["LPG_Tan"].ToString();
}
if (drow["NLPL_Tan"] != null && drow["NLPL_Tan"].ToString().Trim() != "")
{
temp.NLPL_Tan = drow["NLPL_Tan"].ToString();
}
if (drow["Khac_tan"] != null && drow["Khac_tan"].ToString().Trim() != "")
{
temp.KhacSoDo = drow["Khac_tan"].ToString();
}
if (drow["Note"] != null && drow["Note"].ToString().Trim() != "")
{
temp.Note = drow["Note"].ToString();
}
EnterpriseYearService eYService = new EnterpriseYearService();
EnterpriseYear ey = new EnterpriseYear();
ey.EnterpriseId = eId;
if (drow["No_TOE"] != null && drow["No_TOE"].ToString().Trim() != "" && Convert.ToDecimal(drow["No_TOE"]) > 0)
{
ey.No_TOE = Convert.ToDecimal(drow["No_TOE"]);
temp.No_TOE = ey.No_TOE;
temp.Year = 2016;
int retTemp = new ReportTemp2014Service().Insert(temp);//Them bao cao tam
ey.IsDelete = false;
ey.Year = temp.Year;
eYService.Insert(ey);//Them nam bao cao
}
//Tao tai khoan doanh nghiep
Utils objUtil = new Utils();
MemberService memberService = new MemberService();
int STT = 0;
STT = new EnterpriseService().GetNoAccount(area.OrganizationId);
STT++;
ePower.DE.Domain.Member member = new ePower.DE.Domain.Member();
member.EnterpriseId = eId;
member.IsDelete = false;
member.AccountName = "dn." + Utils.UCS2Convert(org.Title).Replace(" ", "").Replace("-", "").ToLower() + "." + STT.ToString("000");
member.Password = securityBSO.EncPwd("123456");
memberService.Insert(member);
}
}
}
public EnterpriseViewModel()
{
entService = new EnterpriseService();
}
public ObjectResultEx WatchRolePage(PageParamList <RequestEnterpriseRoleAuthor> pageParam)
{
return(ObjectResultEx.Instance(EnterpriseService.WatchRolePage(pageParam), 1, RetrunMessge.SUCCESS, HttpCode.Success));
}
protected void btnImport_Click(object sender, EventArgs e)
{
lterror.Text = "";
if (flReport.HasFile)
{
string strext = Path.GetExtension(flReport.PostedFile.FileName).Substring(1);
if (strext == "xls" || strext == "xlsx")
{
string fullfilename = "~/UserFile/" + flReport.FileName;
if (File.Exists(Server.MapPath(fullfilename)))
{
lterror.Text = "File đã tồn tại, vui lòng đổi tên khác";
return;
}
flReport.PostedFile.SaveAs(Server.MapPath(fullfilename));
if (File.Exists(Server.MapPath(fullfilename)))
{
log.Info("File: " + flReport.FileName);
DataTable dt = new DataTable();
string connectionString = String.Format(@"Provider=Microsoft.ACE.OLEDB.12.0;Data Source={0};Extended Properties=""Excel 8.0;HDR=YES;IMEX=1;""", Server.MapPath(fullfilename));
string query = String.Format("select * from [{0}$]", "Sheet1");
SecurityBSO securityBSO = new SecurityBSO();
OleDbDataAdapter dataAdapter = new OleDbDataAdapter(query, connectionString);
DataSet dataSet = new DataSet();
dataAdapter.Fill(dataSet);
DataTable myTable = dataSet.Tables[0];
EnterpriseService comBSO = new EnterpriseService();
int rowi = 0;
foreach (DataRow drow in myTable.Rows)
{
rowi++;
log.Info("Dong thu: " + rowi);
try
{
ReportTemp2014 temp = new ReportTemp2014();
Enterprise enter = new Enterprise();
int eId = 0;
enter.Title = drow["Ten_DN"].ToString();
temp.Title = enter.Title;
log.Info("Doanh nghiep: " + enter.Title);
enter.OrganizationId = Convert.ToInt32(drow["SCT_ID"]);
temp.OrgId = enter.OrganizationId;
if (drow["DiaChi"] != DBNull.Value)
{
enter.Address = drow["DiaChi"].ToString();
temp.Address = enter.Address;
}
if (drow["LinhVuc_Id"] != DBNull.Value && drow["LinhVuc_Id"].ToString() != "")
{
temp.AreaId = Convert.ToInt32(drow["LinhVuc_Id"]);
enter.AreaId = temp.AreaId;
}
enter.ProvinceId = Convert.ToInt32(drow["TinhTP_ID"]);
enter.ManProvinceId = enter.ProvinceId;
enter.OrganizationId = Convert.ToInt32(drow["SCT_ID"]);
if (drow["Ma_DN"] != DBNull.Value && drow["Ma_DN"].ToString().Trim() != "")
{
eId = Convert.ToInt32(drow["Ma_DN"]);
//enter = comBSO.FindByKey(eId);
}
else
{
enter.ActiveYear = 2015;
enter.CustomerCode = "";
enter.TaxCode = "";
if (drow["PhanNganh"] != DBNull.Value && drow["PhanNganh"].ToString() != "")
{
DataTable dtSub = new AreaService().getAreaByName(drow["PhanNganh"].ToString());
if (dtSub != null && dtSub.Rows.Count > 0)
{
enter.SubAreaId = Convert.ToInt32(dtSub.Rows[0]["Id"]);
temp.SubAreaId = enter.SubAreaId;
}
else
{
Area sub = new Area();
sub.AreaName = drow["PhanNganh"].ToString();
sub.ParentId = enter.AreaId;
sub.IsStatus = 1;
sub.SortOrder = 0;
int subId = new AreaService().Insert(sub);
temp.SubAreaId = subId;
enter.SubAreaId = subId;
}
enter.Info = drow["PhanNganh"].ToString();
temp.SubAreaName = drow["PhanNganh"].ToString();
}
eId = comBSO.Insert(enter);//Them doanh nghiep
if (eId > 0)
{
Organization org = new OrganizationService().FindByKey(enter.OrganizationId);
//Tao tai khoan doanh nghiep
Utils objUtil = new Utils();
MemberService memberService = new MemberService();
int STT = 0;
STT = new EnterpriseService().GetNoAccount(enter.OrganizationId);
STT++;
ePower.DE.Domain.Member member = new ePower.DE.Domain.Member();
member.EnterpriseId = eId;
member.IsDelete = false;
member.AccountName = "dn." + Utils.UCS2Convert(org.Title).Replace(" ", "").Replace("-", "").ToLower() + "." + STT.ToString("000");
member.Password = securityBSO.EncPwd("abc123");
int mId = memberService.Insert(member);
if (mId < 0)
{
log.Info("Khong tao duoc tai khoan");
}
}
else
{
log.Info("Khong tao duoc DN");
}
}
if (eId > 0)
{
ReportFuel report = new ReportFuel();
ReportFuelService reportService = new ReportFuelService();
report.EnterpriseId = eId;
report.OrganizationId = enter.OrganizationId;
report.ReportDate = DateTime.Now;
report.CompanyName = enter.Title;
report.Address = enter.Address;
report.ApprovedSatus = true;
report.AprovedDate = DateTime.Now;
report.AreaId = enter.AreaId;
report.ConfirmedDate = DateTime.Now;
report.Created = DateTime.Now;
report.DistrictId = enter.DistrictId;
report.Email = enter.Email;
report.Fax = enter.Fax;
report.IsFiveYear = false;
report.IsDelete = false;
report.Phone = enter.Phone;
report.ReportDate = DateTime.Now;
report.SendSatus = 1;
report.Year = 2018;
report.SubAreaId = enter.SubAreaId;
report.Year = Convert.ToInt32(txtPlanYear.Text.Trim());
temp.EnterpriseId = eId;
int reportId = reportService.Insert(report);
if (reportId > 0)
{
ReportFuelDetailService serviceDetail = new ReportFuelDetailService();
ReportFuelDetail detail = new ReportFuelDetail();
int detailid = 0;
if (drow["Dien_kWh"] != DBNull.Value && drow["Dien_kWh"].ToString().Trim() != "")
{
temp.Dien_kWh = drow["Dien_kWh"].ToString();
detail.EnterpriseId = report.EnterpriseId;
detail.FuelId = 1;
detail.MeasurementId = 1;
detail.No_RateTOE = 0.0001543m;
detail.Price = 0;
detail.Year = 2017;
if (drow["Dien_kWh"] != DBNull.Value && drow["Dien_kWh"].ToString() != "")
{
detail.NoFuel = Convert.ToDecimal(drow["Dien_kWh"]);
}
detail.NoFuel_TOE = detail.No_RateTOE * detail.NoFuel;
detail.ReportId = reportId;
detailid = serviceDetail.Insert(detail);
if (detailid <= 0)
{
log.Info("Them dien loi");
}
}
if (drow["ThanDa_Tan"] != DBNull.Value && drow["ThanDa_Tan"].ToString().Trim() != "")
{
detail = new ReportFuelDetail();
temp.Than_Tan = drow["ThanDa_Tan"].ToString();
detail.EnterpriseId = report.EnterpriseId;
detail.FuelId = 2;
detail.MeasurementId = 2;
detail.No_RateTOE = 0.7m;
detail.Price = 0;
detail.Year = 2017;
if (drow["ThanDa_Tan"] != DBNull.Value && drow["ThanDa_Tan"].ToString() != "")
{
detail.NoFuel = Convert.ToDecimal(drow["ThanDa_Tan"]);
}
detail.NoFuel_TOE = detail.No_RateTOE * detail.NoFuel;
detail.ReportId = reportId;
detailid = serviceDetail.Insert(detail);
if (detailid <= 0)
{
log.Info("Them than da_tan loi");
}
}
if (drow["Than12_Tan"] != DBNull.Value && drow["Than12_Tan"].ToString().Trim() != "")
{
detail = new ReportFuelDetail();
temp.Than_Tan = drow["Than12_Tan"].ToString();
detail.EnterpriseId = report.EnterpriseId;
detail.FuelId = 3;
detail.MeasurementId = 2;
detail.No_RateTOE = 0.7m;
detail.Price = 0;
detail.Year = 2017;
if (drow["Than12_Tan"] != DBNull.Value && drow["Than12_Tan"].ToString() != "")
{
detail.NoFuel = Convert.ToDecimal(drow["Than12_Tan"]);
}
detail.NoFuel_TOE = detail.No_RateTOE * detail.NoFuel;
detail.ReportId = reportId;
detailid = serviceDetail.Insert(detail);
if (detailid <= 0)
{
log.Info("Them than 12 loi");
}
}
if (drow["Than34_Tan"] != DBNull.Value && drow["Than34_Tan"].ToString().Trim() != "")
{
detail = new ReportFuelDetail();
temp.Than_Tan = drow["Than34_Tan"].ToString();
detail.EnterpriseId = report.EnterpriseId;
detail.FuelId = 4;
detail.MeasurementId = 2;
detail.No_RateTOE = 0.6m;
detail.Price = 0;
detail.Year = 2017;
if (drow["Than34_Tan"] != DBNull.Value && drow["Than34_Tan"].ToString() != "")
{
detail.NoFuel = Convert.ToDecimal(drow["Than34_Tan"]);
}
detail.NoFuel_TOE = detail.No_RateTOE * detail.NoFuel;
detail.ReportId = reportId;
detailid = serviceDetail.Insert(detail);
if (detailid <= 0)
{
log.Info("Them than34 loi");
}
}
if (drow["Than56_Tan"] != DBNull.Value && drow["Than56_Tan"].ToString().Trim() != "")
{
detail = new ReportFuelDetail();
temp.Than_Tan = drow["Than56_Tan"].ToString();
detail.EnterpriseId = report.EnterpriseId;
detail.FuelId = 5;
detail.MeasurementId = 2;
detail.No_RateTOE = 0.5m;
detail.Price = 0;
detail.Year = 2017;
if (drow["Than56_Tan"] != DBNull.Value && drow["Than56_Tan"].ToString() != "")
{
detail.NoFuel = Convert.ToDecimal(drow["Than56_Tan"]);
}
detail.NoFuel_TOE = detail.No_RateTOE * detail.NoFuel;
detail.ReportId = reportId;
detailid = serviceDetail.Insert(detail);
if (detailid <= 0)
{
log.Info("Them than56 loi");
}
}
if (drow["DO_Tan"] != DBNull.Value && drow["DO_Tan"].ToString().Trim() != "")
{
detail = new ReportFuelDetail();
temp.DO_Tan = drow["DO_Tan"].ToString();
detail.EnterpriseId = report.EnterpriseId;
detail.FuelId = 6;
detail.MeasurementId = 2;
detail.No_RateTOE = 1.02m;
detail.Price = 0;
detail.Year = 2017;
if (drow["DO_Tan"] != DBNull.Value && drow["DO_Tan"].ToString() != "")
{
detail.NoFuel = Convert.ToDecimal(drow["DO_Tan"]);
}
detail.NoFuel_TOE = detail.No_RateTOE * detail.NoFuel;
detail.ReportId = reportId;
detailid = serviceDetail.Insert(detail);
if (detailid <= 0)
{
log.Info("Them dau do_tan loi");
}
}
if (drow["DO_lit"] != DBNull.Value && drow["DO_lit"].ToString().Trim() != "")
{
temp.DO_lit = drow["DO_lit"].ToString();
detail = new ReportFuelDetail();
detail.EnterpriseId = report.EnterpriseId;
detail.FuelId = 6;
detail.MeasurementId = 3;
detail.No_RateTOE = 0.00088m;
detail.Price = 0;
detail.Year = 2017;
if (drow["DO_lit"] != DBNull.Value && drow["DO_lit"].ToString() != "")
{
detail.NoFuel = Convert.ToDecimal(drow["DO_lit"]);
}
detail.NoFuel_TOE = detail.No_RateTOE * detail.NoFuel;
detail.ReportId = reportId;
detailid = serviceDetail.Insert(detail);
if (detailid <= 0)
{
log.Info("Them dauDO_lit loi");
}
}
if (drow["FO_Tan"] != DBNull.Value && drow["FO_Tan"].ToString().Trim() != "")
{
temp.FO_Tan = drow["FO_Tan"].ToString();
detail = new ReportFuelDetail();
detail.EnterpriseId = report.EnterpriseId;
detail.FuelId = 7;
detail.MeasurementId = 2;
detail.No_RateTOE = 0.99m;
detail.Price = 0;
detail.Year = 2017;
if (drow["FO_Tan"] != DBNull.Value && drow["FO_Tan"].ToString() != "")
{
detail.NoFuel = Convert.ToDecimal(drow["FO_Tan"]);
}
detail.NoFuel_TOE = detail.No_RateTOE * detail.NoFuel;
detail.ReportId = reportId;
detailid = serviceDetail.Insert(detail);
if (detailid <= 0)
{
log.Info("Them dau FO_tan loi");
}
}
if (drow["FO_lit"] != DBNull.Value && drow["FO_lit"].ToString().Trim() != "")
{
temp.FO_lit = drow["FO_lit"].ToString();
detail = new ReportFuelDetail();
detail.EnterpriseId = report.EnterpriseId;
detail.FuelId = 7;
detail.MeasurementId = 3;
detail.No_RateTOE = 0.00094m;
detail.Price = 0;
detail.Year = 2017;
if (drow["FO_lit"] != DBNull.Value && drow["FO_lit"].ToString() != "")
{
detail.NoFuel = Convert.ToDecimal(drow["FO_lit"]);
}
detail.NoFuel_TOE = detail.No_RateTOE * detail.NoFuel;
detail.ReportId = reportId;
detailid = serviceDetail.Insert(detail);
if (detailid <= 0)
{
log.Info("Them dau FO_Lit loi");
}
}
if (drow["Xang_Tan"] != DBNull.Value && drow["Xang_Tan"].ToString().Trim() != "")
{
temp.Xang_Tan = drow["Xang_Tan"].ToString();
detail = new ReportFuelDetail();
detail.EnterpriseId = report.EnterpriseId;
detail.FuelId = 11;
detail.MeasurementId = 2;
detail.No_RateTOE = 1.05m;
detail.Price = 0;
detail.Year = 2017;
if (drow["Xang_Tan"] != DBNull.Value && drow["Xang_Tan"].ToString() != "")
{
detail.NoFuel = Convert.ToDecimal(drow["Xang_Tan"]);
}
detail.NoFuel_TOE = detail.No_RateTOE * detail.NoFuel;
detail.ReportId = reportId;
detailid = serviceDetail.Insert(detail);
if (detailid <= 0)
{
log.Info("Them xang_tan loi");
}
}
if (drow["Xang_lit"] != DBNull.Value && drow["Xang_lit"].ToString().Trim() != "")
{
temp.Xang_lit = drow["Xang_lit"].ToString();
detail = new ReportFuelDetail();
detail.EnterpriseId = report.EnterpriseId;
detail.FuelId = 11;
detail.MeasurementId = 3;
detail.No_RateTOE = 0.00083m;
detail.Price = 0;
detail.Year = 2017;
if (drow["Xang_lit"] != DBNull.Value && drow["Xang_lit"].ToString() != "")
{
detail.NoFuel = Convert.ToDecimal(drow["Xang_lit"]);
}
detail.NoFuel_TOE = detail.No_RateTOE * detail.NoFuel;
detail.ReportId = reportId;
detailid = serviceDetail.Insert(detail);
if (detailid <= 0)
{
log.Info("Them xang_lit loi");
}
}
if (drow["Gas_Tan"] != DBNull.Value && drow["Gas_Tan"].ToString().Trim() != "")
{
temp.Gas_Tan = drow["Gas_Tan"].ToString();
detail = new ReportFuelDetail();
detail.EnterpriseId = report.EnterpriseId;
detail.FuelId = 10;
detail.MeasurementId = 4;
detail.No_RateTOE = 0.0009m;
detail.Price = 0;
detail.Year = 2017;
if (drow["Gas_Tan"] != DBNull.Value && drow["Gas_Tan"].ToString() != "")
{
detail.NoFuel = Convert.ToDecimal(drow["Gas_Tan"]);
}
detail.NoFuel_TOE = detail.No_RateTOE * detail.NoFuel;
detail.ReportId = reportId;
detailid = serviceDetail.Insert(detail);
if (detailid <= 0)
{
log.Info("Them Gas_Tan loi");
}
}
if (drow["Khi_m3"] != DBNull.Value && drow["Khi_m3"].ToString().Trim() != "")
{
temp.Khi_M3 = drow["Khi_m3"].ToString();
detail = new ReportFuelDetail();
detail.EnterpriseId = report.EnterpriseId;
detail.FuelId = 10;
detail.MeasurementId = 1;
detail.No_RateTOE = 0.0009m;
detail.Price = 0;
detail.Year = 2017;
if (drow["Khi_m3"] != DBNull.Value && drow["Khi_m3"].ToString() != "")
{
detail.NoFuel = Convert.ToDecimal(drow["Khi_m3"]);
}
detail.NoFuel_TOE = detail.No_RateTOE * detail.NoFuel;
detail.ReportId = reportId;
detailid = serviceDetail.Insert(detail);
if (detailid <= 0)
{
log.Info("Them Khi_m3 loi");
}
}
if (drow["LPG_Tan"] != DBNull.Value && drow["LPG_Tan"].ToString().Trim() != "")
{
temp.LPG_Tan = drow["LPG_Tan"].ToString();
detail = new ReportFuelDetail();
detail.EnterpriseId = report.EnterpriseId;
detail.FuelId = 8;
detail.MeasurementId = 2;
detail.No_RateTOE = 1.09m;
detail.Price = 0;
detail.Year = 2017;
if (drow["LPG_Tan"] != DBNull.Value && drow["LPG_Tan"].ToString() != "")
{
detail.NoFuel = Convert.ToDecimal(drow["LPG_Tan"]);
}
detail.NoFuel_TOE = detail.No_RateTOE * detail.NoFuel;
detail.ReportId = reportId;
detailid = serviceDetail.Insert(detail);
if (detailid <= 0)
{
log.Info("Them LPG loi");
}
}
if (drow["NLPL_Tan"] != DBNull.Value && drow["NLPL_Tan"].ToString().Trim() != "")
{
temp.NLPL_Tan = drow["NLPL_Tan"].ToString();
detail = new ReportFuelDetail();
detail.EnterpriseId = report.EnterpriseId;
detail.FuelId = 12;
detail.MeasurementId = 2;
detail.No_RateTOE = 1.05m;
detail.Price = 0;
detail.Year = 2017;
if (drow["NLPL_Tan"] != DBNull.Value && drow["NLPL_Tan"].ToString() != "")
{
detail.NoFuel = Convert.ToDecimal(drow["NLPL_Tan"]);
}
detail.NoFuel_TOE = detail.No_RateTOE * detail.NoFuel;
detail.ReportId = reportId;
detailid = serviceDetail.Insert(detail);
if (detailid <= 0)
{
log.Info("Them NLPL loi");
}
}
if (drow["Khac_tan"] != DBNull.Value && drow["Khac_tan"].ToString().Trim() != "")
{
temp.KhacSoDo = drow["Khac_tan"].ToString();
detail = new ReportFuelDetail();
detail.EnterpriseId = report.EnterpriseId;
detail.FuelId = 1;
detail.MeasurementId = 1;
detail.No_RateTOE = 0.0002770000m;
detail.Price = 0;
detail.Year = 2017;
if (drow["Khac_tan"] != DBNull.Value && drow["Khac_tan"].ToString() != "")
{
detail.NoFuel = Convert.ToDecimal(drow["Khac_tan"]);
}
detail.NoFuel_TOE = detail.No_RateTOE * detail.NoFuel;
detail.ReportId = reportId;
detailid = serviceDetail.Insert(detail);
if (detailid <= 0)
{
log.Info("Them khac loi");
}
}
if (drow["GhiChu"] != DBNull.Value && drow["GhiChu"].ToString().Trim() != "")
{
temp.Note = drow["GhiChu"].ToString();
}
EnterpriseYearService eYService = new EnterpriseYearService();
EnterpriseYear ey = new EnterpriseYear();
ey.EnterpriseId = eId;
ey.ReportId = reportId;
ey.Year = 2017;
ey.IsKey = true;
if (drow["No_TOE"] != DBNull.Value && drow["No_TOE"].ToString().Trim() != "")
{
ey.No_TOE = Convert.ToDecimal(drow["No_TOE"]);
}
temp.No_TOE = ey.No_TOE;
temp.Year = 2017;
int retTemp = new ReportTemp2014Service().Insert(temp);//Them bao cao tam
ey.IsDelete = false;
ey.Year = temp.Year;
int retempId = eYService.Insert(ey);//Them nam bao cao
if (retempId <= 0)
{
log.Info("Them bao cao loi loi");
}
}
else
{
log.Info("Khong tao duoc bao cao");
}
}
}
catch (Exception ex)
{
log.Error("Loi import du lieu dong thu i: " + rowi, ex);
}
}
}
else
{
lterror.Text = "Không upload được file";
}
}
else
{
lterror.Text = "Chỉ chọn file Excel đuôi .xls và .xlsx";
}
}
else
{
lterror.Text = "File không tồn tại";
}
}
public ObjectResultEx GetRoleAuthorList()
{
return(ObjectResultEx.Instance(EnterpriseService.GetRoleAuthorList(), 1, RetrunMessge.SUCCESS, HttpCode.Success));
}
protected void OnButtonCommand(object sender, CommandEventArgs e)
{
//Event handler for command button clicked
try {
//Change view to Viewer and reset to clear existing data
Master.Viewer.Reset();
//Initialize control values
LocalReport report = Master.Viewer.LocalReport;
report.DisplayName = this.mTitle;
report.EnableExternalImages = true;
report.EnableHyperlinks = true;
EnterpriseService enterprise = new EnterpriseService();
DataSet ds = new DataSet(this.mDSName);
foreach (GridViewRow row in SelectedRows)
{
DataKey dataKey = (DataKey)this.grdPickups.DataKeys[row.RowIndex];
DataSet _ds = enterprise.FillDataset(this.mUSPName, mTBLName, new object[] { dataKey["PickupID"].ToString() });
ds.Merge(_ds);
}
if (ds.Tables[mTBLName] == null)
{
ds.Tables.Add(mTBLName);
}
switch (e.CommandName)
{
case "Run":
//Set local report and data source
System.IO.Stream stream = Master.GetReportDefinition(this.mSource);
report.LoadReportDefinition(stream);
report.DataSources.Clear();
report.DataSources.Add(new ReportDataSource(this.mDSName, ds.Tables[mTBLName]));
report.SetParameters(new ReportParameter[] { new ReportParameter("PickupID", "0") });
report.Refresh();
if (!Master.Viewer.Enabled)
{
Master.Viewer.CurrentPage = 1;
}
break;
case "Data":
//Set local export report and data source
report.LoadReportDefinition(Master.CreateExportRdl(ds, this.mDSName, "RGXVMSQLR.TSORT"));
report.DataSources.Clear();
report.DataSources.Add(new ReportDataSource(this.mDSName, ds.Tables[mTBLName]));
report.Refresh();
break;
case "Excel":
//Create Excel mime-type page
Response.ClearHeaders();
Response.Clear();
Response.Charset = "";
Response.AddHeader("Content-Disposition", "inline; filename=LOccitaneCartonInfo.xls");
Response.ContentType = "application/vnd.ms-excel"; //application/octet-stream";
System.IO.StringWriter sw = new System.IO.StringWriter();
System.Web.UI.HtmlTextWriter hw = new System.Web.UI.HtmlTextWriter(sw);
DataGrid dg = new DataGrid();
dg.DataSource = ds.Tables[mTBLName];
dg.DataBind();
dg.RenderControl(hw);
Response.Write(sw.ToString());
Response.End();
break;
}
}
catch (Exception ex) { Master.ReportError(ex, 4); }
}
public ObjectResultEx AuditPayment(RequestPayment Param)
{
return(ObjectResultEx.Instance(EnterpriseService.AuditPayment(Param), 1, RetrunMessge.SUCCESS, HttpCode.Success));
}
private void BindData()
{
if (ItemId > 0)
{
EnterpriseService objlogic = new EnterpriseService();
Enterprise obj = new Enterprise();
obj = objlogic.FindByKey(ItemId);
if (obj != null)
{
txtTitle.Text = obj.Title;
if (obj.AreaId > 0)
{
ddlArea.SelectedValue = obj.AreaId.ToString();
BindSubArea();
if (obj.SubAreaId > 0)
{
ddlSubArea.SelectedValue = obj.SubAreaId.ToString();
}
}
if (obj.ProvinceId > 0)
{
ddlProvince.SelectedValue = obj.ProvinceId.ToString();
BindDistrict();
if (obj.DistrictId > 0)
{
ddlDistrict.SelectedValue = obj.DistrictId.ToString();
}
}
txtMST.Text = obj.TaxCode;
txtCustomerCode.Text = obj.CustomerCode;
txtPhone.Text = obj.Phone;
txtFax.Text = obj.Fax;
txtEmail.Text = obj.Email;
txtResponsible.Text = obj.ManPerson;
txtAddress.Text = obj.Address;
if (obj.OwnerId > 0)
{
ddlOwner.SelectedValue = obj.OwnerId.ToString();
}
cbxActive.Checked = obj.IsActive;
if (obj.ActiveYear > 0)
{
txtAtiveYear.Text = obj.ActiveYear.ToString();
}
txtNote.Text = obj.Info;
OrgId = obj.OrganizationId;
txtParentName.Text = obj.ParentName;
if (obj.ManProvinceId > 0)
{
ddlProvinceReporter.SelectedValue = obj.ManProvinceId.ToString();
BindDistrictReporter();
if (obj.ManDistrictId > 0)
{
ddlDistrictReporter.SelectedValue = obj.ManDistrictId.ToString();
}
}
txtAddressReporter.Text = obj.ManAddress;
txtPhoneReporter.Text = obj.ManPhone;
txtFaxReporter.Text = obj.ManFax;
txtManEmail.Text = obj.ManEmail;
}
}
//if (ImportantYears != "" && ImportantYears.Contains(DateTime.Today.ToString("yyyy")))
//{
// divImportantYear.Visible = false;
//}
//else divImportantYear.Visible = true;
}
public ObjectResultEx EditEnterpriseMenu(RequestEnterpriseMenu Param)
{
return(ObjectResultEx.Instance(EnterpriseService.EditEnterpriseMenu(Param), 1, RetrunMessge.SUCCESS, HttpCode.Success));
}
protected void btn_add_Click(object sender, EventArgs e)
{
try
{
EnterpriseService objlogic = new EnterpriseService();
Enterprise obj = new Enterprise();
obj.Title = txtTitle.Text;
//if (ddlProvince.SelectedIndex > 0)
obj.ProvinceId = Convert.ToInt32(ddlProvince.SelectedValue);
if (ddlDistrict.SelectedIndex > 0)
{
obj.DistrictId = Convert.ToInt32(ddlDistrict.SelectedValue);
}
if (ddlArea.SelectedIndex > 0)
{
obj.AreaId = Convert.ToInt32(ddlArea.SelectedValue);
}
if (ddlSubArea.SelectedIndex > 0)
{
obj.SubAreaId = Convert.ToInt32(ddlSubArea.SelectedValue);
}
IFormatProvider culture = new System.Globalization.CultureInfo("en-US", true);
if (txtMST.Text != "")
{
obj.TaxCode = txtMST.Text.Trim();
}
if (txtCustomerCode.Text != "")
{
obj.CustomerCode = txtCustomerCode.Text.Trim();
}
obj.Phone = txtPhone.Text;
obj.Email = txtEmail.Text;
obj.Fax = txtFax.Text;
obj.ManPerson = txtResponsible.Text;
obj.Address = txtAddress.Text;
obj.OwnerId = Convert.ToInt32(ddlOwner.SelectedValue);
obj.ParentName = txtParentName.Text;
if (ddlProvinceReporter.SelectedIndex > 0)
{
obj.ManProvinceId = Convert.ToInt32(ddlProvinceReporter.SelectedValue);
}
if (ddlDistrictReporter.SelectedIndex > 0)
{
obj.ManDistrictId = Convert.ToInt32(ddlDistrictReporter.SelectedValue);
}
obj.ManAddress = txtAddressReporter.Text;
obj.ManPhone = txtPhoneReporter.Text;
obj.ManFax = txtFaxReporter.Text;
obj.ManEmail = txtManEmail.Text;
if (cbxActive.Checked)
{
obj.IsActive = true;
}
else
{
obj.IsActive = false;
}
try
{
if (txtAtiveYear.Text.Trim() != "")
{
obj.ActiveYear = Convert.ToInt32(txtAtiveYear.Text);
}
}
catch { }
obj.OrganizationId = m_UserValidation.OrgId;
if (ItemId > 0)
{
obj.Id = ItemId;
if (objlogic.Update(obj) != null)
{
/*Cap nhat du lieu trong diem nam hien tai*/
//if (ImportantYears != "" && !ImportantYears.Contains(DateTime.Today.ToString("yyyy")) && cbxIsImportant.Checked)
//{
// EnterpriseYear ey = new EnterpriseYear();
// ey.EnterpriseId = ItemId;
// ey.Year = DateTime.Today.Year;
// new EnterpriseYearService().Insert(ey);
//}
//BindImportantYear();
BindData();
error.Text = "<div class='alert alert-primary'>Cập nhật thành công !</div>";
}
else
{
error.Text = "<div class='alert alert-dangers'>Cập nhật không thành công !</div>";
}
}
else
{
ItemId = objlogic.Insert(obj);
if (ItemId > 0)
{
/*Tao tai khoan mac dinh*/
Organization org = new OrganizationService().FindByKey(m_UserValidation.OrgId);
if (org != null)
{
int noAccount = new EnterpriseService().GetNoAccount(m_UserValidation.OrgId);
SecurityBSO securityBSO = new SecurityBSO();
AdminRolesBSO adminRolesBSO = new AdminRolesBSO();
Utils objUtil = new Utils();
MemberService memberService = new MemberService();
ePower.DE.Domain.Member member = new ePower.DE.Domain.Member();
member.EnterpriseId = ItemId;
member.IsDelete = false;
member.IsActive = true;
member.AccountName = "dn." + Utils.UCS2Convert(org.Title).Replace(" ", "").Replace("-", "").ToLower() + "." + (noAccount).ToString("000");
string spassdefault = "abc123";
spassdefault = ConfigurationManager.AppSettings["DefaultPassword"].ToString();
member.Password = securityBSO.EncPwd(spassdefault);
int iMember = 0;
iMember = memberService.Insert(member);
//if (memberService.Insert(member) > 0)
//{
// BindMember();
//}
//else
// error.Text = "<div class='alert alert-dangers'>Tạo tài khoản không thành công !</div>";
}
/*Cap nhat du lieu trong diem nam hien tai*/
//if (ImportantYears != "" && !ImportantYears.Contains(DateTime.Today.ToString("yyyy")) && cbxIsImportant.Checked)
//{
// EnterpriseYear ey = new EnterpriseYear();
// ey.EnterpriseId = ItemId;
// ey.Year = DateTime.Today.Year;
// new EnterpriseYearService().Insert(ey);
//}
Response.Redirect(ResolveUrl("~") + "Admin/EditEnterprise/" + ItemId.ToString() + "/Default.aspx");
}
else
{
error.Text = "<div class='alert alert-dangers'>Thêm mới không thành công !</div>";
}
}
}
catch (Exception ex)
{
error.Text = ex.Message.ToString();
}
}
public ObjectResultEx GetWaitAuditGoodPage(PageParamList <RequestEnterpriseGoodsStock> pageParam)
{
return(ObjectResultEx.Instance(EnterpriseService.GetWaitAuditGoodPage(pageParam), 1, RetrunMessge.SUCCESS, HttpCode.Success));
}
protected void OnButtonCommand(object sender, CommandEventArgs e)
{
//Event handler for command button clicked
//Change view to Viewer and reset to clear existing data
Master.Viewer.Reset();
//Get parameters for the query
string _client = Master.ClientNumber;
string _division = Master.Division;
string _agent = Master.AgentNumber;
string _region = Master.Region;
string _district = Master.District;
string _store = Master.StoreNumber;
int _isException = this.chkExceptionsOnly.Checked ? 1 : 0;
string _start = Master.StartDate;
string _end = Master.EndDate;
//Initialize control values
LocalReport report = Master.Viewer.LocalReport;
report.DisplayName = REPORT_NAME;
report.EnableExternalImages = true;
EnterpriseService enterprise = new EnterpriseService();
DataSet ds = enterprise.FillDataset(USP_REPORT, TBL_REPORT, new object[] { _client, _division, _agent, _region, _district, _store, _start, _end, _isException });
if (ds.Tables[TBL_REPORT].Rows.Count >= 0)
{
switch (e.CommandName)
{
case "Run":
//Set local report and data source
System.IO.Stream stream = Master.GetReportDefinition(REPORT_SRC);
report.LoadReportDefinition(stream);
report.DataSources.Clear();
report.DataSources.Add(new ReportDataSource(REPORT_DS, ds.Tables[TBL_REPORT]));
//Set the report parameters for the report
ReportParameter clientName = new ReportParameter("ClientName", Master.ClientName);
ReportParameter client = new ReportParameter("ClientNumber", _client);
ReportParameter division = new ReportParameter("Division", _division);
ReportParameter agent = new ReportParameter("AgentNumber"); if (_agent != null)
{
agent.Values.Add(_agent);
}
ReportParameter region = new ReportParameter("Region"); if (_region != null)
{
region.Values.Add(_region);
}
ReportParameter district = new ReportParameter("District"); if (_district != null)
{
district.Values.Add(_district);
}
ReportParameter store = new ReportParameter("StoreNumber"); if (_store != null)
{
store.Values.Add(_store);
}
ReportParameter start = new ReportParameter("StartDate", _start);
ReportParameter end = new ReportParameter("EndDate", _end);
ReportParameter isException = new ReportParameter("IsExceptionOnly", _isException.ToString());
report.SetParameters(new ReportParameter[] { client, division, agent, region, district, store, start, end, isException, clientName });
//Update report rendering with new data
report.Refresh();
if (!Master.Viewer.Enabled)
{
Master.Viewer.CurrentPage = 1;
}
break;
case "Data":
//Set local export report and data source
report.LoadReportDefinition(Master.CreateExportRdl(ds, REPORT_DS, "RGXSQLR.TSORT"));
report.DataSources.Clear();
report.DataSources.Add(new ReportDataSource(REPORT_DS, ds.Tables[TBL_REPORT]));
report.Refresh(); break;
case "Excel":
//Create Excel mime-type page
Response.ClearHeaders();
Response.Clear();
Response.Charset = "";
Response.AddHeader("Content-Disposition", "inline; filename=ScanningDetailByStore.xls");
Response.ContentType = "application/vnd.ms-excel"; //application/octet-stream";
System.IO.StringWriter sw = new System.IO.StringWriter();
System.Web.UI.HtmlTextWriter hw = new System.Web.UI.HtmlTextWriter(sw);
DataGrid dg = new DataGrid();
dg.DataSource = ds.Tables[TBL_REPORT];
dg.DataBind();
dg.RenderControl(hw);
Response.Write(sw.ToString());
Response.End();
break;
}
}
else
{
Master.Status = "There were no records found.";
}
}
public ObjectResultEx GetEnterpriseMenuDetail(SimpleParam <Guid> Param)
{
return(ObjectResultEx.Instance(EnterpriseService.GetEnterpriseMenuDetail(Param.Id), 1, RetrunMessge.SUCCESS, HttpCode.Success));
}
public ProjectController(EnterpriseService entService)
{
_entService = entService;
}
public ObjectResultEx GetEnterpriseMenuPage(PageParamList <RequestEnterpriseMenu> pageParam)
{
return(ObjectResultEx.Instance(EnterpriseService.GetEnterpriseMenuPage(pageParam), 1, RetrunMessge.SUCCESS, HttpCode.Success));
}
protected void btnExport_Click(object sender, EventArgs e)
{
#region get data
WordExtend ex = new WordExtend();
string temp = "TempReport/TemMauBaoCao" + drpmaubaocao.SelectedValue + ".doc";
ex.OpenFile(Server.MapPath(ResolveUrl("~") + temp));
Enterprise or = new Enterprise();
EnterpriseService orser = new EnterpriseService();
or = orser.FindByKey(Convert.ToInt32(memVal.OrgId));
DataTable dtinfo = new DataTable();
ex.WriteToMergeField("BC_MaDN", "");
if (memVal.OrgId > 0)
{
dtinfo = new ReportFuelService().GetInfoReportFuel(ReportId);
}
if (or != null)
{
ex.WriteToMergeField("BC_Title", or.Title);
ex.WriteToMergeField("BC_TenCoSo", or.Title);
ex.WriteToMergeField("BC_TenCoSo1", or.Title);
ex.WriteToMergeField("BC_TenCoSo2", or.Title);
}
else
{
ex.WriteToMergeField("BC_TenCoSo", "");
}
if (dtinfo.Rows[0]["Year"] != DBNull.Value)
{
string NextYear = (Convert.ToInt32(dtinfo.Rows[0]["Year"]) + 1).ToString();
ex.WriteToMergeField("BC_NextYear", NextYear);
ex.WriteToMergeField("BC_NextYear1", NextYear);
ex.WriteToMergeField("BC_NextYear2", NextYear);
ex.WriteToMergeField("BC_Year", dtinfo.Rows[0]["Year"].ToString());
ex.WriteToMergeField("BC_Year1", dtinfo.Rows[0]["Year"].ToString());
}
if (dtinfo.Rows[0]["Responsible"] != DBNull.Value)
{
ex.WriteToMergeField("BC_ChiuTrachNhiem", dtinfo.Rows[0]["Responsible"].ToString());
}
else
{
ex.WriteToMergeField("BC_ChiuTrachNhiem", "");
}
if (dtinfo.Rows[0]["ReportDate"] != DBNull.Value)
{
ex.WriteToMergeField("BC_NgayLap", Convert.ToDateTime(dtinfo.Rows[0]["ReportDate"]).ToString("dd/MM/yyyy"));
ex.WriteToMergeField("BC_NgayBC", Convert.ToDateTime(dtinfo.Rows[0]["ReportDate"]).ToString("dd/MM/yyyy"));
}
if (dtinfo.Rows[0]["ReceivedDate"] != DBNull.Value)
{
ex.WriteToMergeField("BC_NgayNhan", Convert.ToDateTime(dtinfo.Rows[0]["ReceivedDate"]).ToString("dd/MM/yyyy"));
}
else
{
ex.WriteToMergeField("BC_NgayNhan", "");
}
if (dtinfo.Rows[0]["ConfirmedDate"] != DBNull.Value)
{
ex.WriteToMergeField("BC_NgayXacNhan", Convert.ToDateTime(dtinfo.Rows[0]["ConfirmedDate"]).ToString("dd/MM/yyyy"));
}
else
{
ex.WriteToMergeField("BC_NgayXacNhan", "");
}
if (dtinfo.Rows[0]["SubAreaName"] != DBNull.Value)
{
ex.WriteToMergeField("BC_PhanNganh", dtinfo.Rows[0]["SubAreaName"].ToString());
}
else
{
ex.WriteToMergeField("BC_PhanNganh", "");
}
if (dtinfo.Rows[0]["TaxCode"] != DBNull.Value)
{
ex.WriteToMergeField("BC_TaxCode", dtinfo.Rows[0]["TaxCode"].ToString());
}
else
{
ex.WriteToMergeField("BC_TaxCode", "");
}
ex.WriteToMergeField("BC_Owner", ltOwner.Text);
if (or.Address != null)
{
ex.WriteToMergeField("BC_DiaChi", or.Address);
}
if (dtinfo.Rows[0]["DistrictName"] != DBNull.Value)
{
ex.WriteToMergeField("BC_Huyen", dtinfo.Rows[0]["DistrictName"].ToString());
}
else
{
ex.WriteToMergeField("BC_Huyen", "");
}
if (dtinfo.Rows[0]["ProvinceName"] != DBNull.Value)
{
ex.WriteToMergeField("BC_Tinh", dtinfo.Rows[0]["ProvinceName"].ToString());
}
else
{
ex.WriteToMergeField("BC_Tinh", "");
}
if (dtinfo.Rows[0]["ReporterName"] != DBNull.Value)
{
ex.WriteToMergeField("BC_NguoiBC", dtinfo.Rows[0]["ReporterName"].ToString());
}
else
{
ex.WriteToMergeField("BC_NguoiBC", "");
}
if (dtinfo.Rows[0]["Fax"] != DBNull.Value)
{
ex.WriteToMergeField("BC_Fax", dtinfo.Rows[0]["Fax"].ToString());
}
else
{
ex.WriteToMergeField("BC_Fax", "");
}
if (dtinfo.Rows[0]["Email"] != DBNull.Value)
{
ex.WriteToMergeField("BC_Email", dtinfo.Rows[0]["Email"].ToString());
}
else
{
ex.WriteToMergeField("BC_Email", "");
}
if (dtinfo.Rows[0]["Phone"] != DBNull.Value)
{
ex.WriteToMergeField("BC_DienThoai", dtinfo.Rows[0]["Phone"].ToString());
}
else
{
ex.WriteToMergeField("BC_DienThoai", "");
}
if (dtinfo.Rows[0]["ParentName"] != DBNull.Value)
{
ex.WriteToMergeField("BC_TenCtyMe", dtinfo.Rows[0]["ParentName"].ToString());
}
else
{
ex.WriteToMergeField("BC_TenCtyMe", "");
}
if (dtinfo.Rows[0]["AddressParent"] != null)
{
ex.WriteToMergeField("BC_DiaChiP", dtinfo.Rows[0]["AddressParent"].ToString());
}
else
{
ex.WriteToMergeField("BC_DiaChiP", "");
}
if (dtinfo.Rows[0]["DistrictNameP"] != null)
{
ex.WriteToMergeField("BC_HuyenP", dtinfo.Rows[0]["DistrictNameP"].ToString());
}
else
{
ex.WriteToMergeField("BC_HuyenP", "");
}
if (dtinfo.Rows[0]["ProvinceNameP"] != DBNull.Value)
{
ex.WriteToMergeField("BC_TinhP", dtinfo.Rows[0]["ProvinceNameP"].ToString());
}
else
{
ex.WriteToMergeField("BC_TinhP", "");
}
if (dtinfo.Rows[0]["PhoneParent"] != DBNull.Value)
{
ex.WriteToMergeField("BC_DienThoaiP", dtinfo.Rows[0]["PhoneParent"].ToString());
}
else
{
ex.WriteToMergeField("BC_DienThoaiP", "");
}
if (dtinfo.Rows[0]["FaxParent"] != DBNull.Value)
{
ex.WriteToMergeField("BC_FaxP", dtinfo.Rows[0]["FaxParent"].ToString());
}
else
{
ex.WriteToMergeField("BC_FaxP", "");
}
if (dtinfo.Rows[0]["EmailParent"] != DBNull.Value)
{
ex.WriteToMergeField("BC_EmailP", dtinfo.Rows[0]["EmailParent"].ToString());
}
else
{
ex.WriteToMergeField("BC_EmailP", "");
}
if (or.ActiveYear > 0)
{
ex.WriteToMergeField("ActiveYear", or.ActiveYear.ToString());
}
else
{
ex.WriteToMergeField("ActiveYear", "");
}
Infrastructure infra = new Infrastructure();
InfrastructureService infraService = new InfrastructureService();
infra = infraService.GetInfrastructureByReport(ReportId);
if (infra != null)
{
if (infra.ProduceAreaNo > 0)
{
ex.WriteToMergeField("ProduceAreaNo", infra.ProduceAreaNo.ToString());
}
else
{
ex.WriteToMergeField("ProduceAreaNo", "");
}
if (infra.OfficeAreaNo > 0)
{
ex.WriteToMergeField("OfficeAreaNo", infra.OfficeAreaNo.ToString());
}
else
{
ex.WriteToMergeField("OfficeAreaNo", "");
}
if (infra.ProduceEmployeeNo > 0)
{
ex.WriteToMergeField("ProduceEmployeeNo", infra.ProduceEmployeeNo.ToString());
}
else
{
ex.WriteToMergeField("ProduceEmployeeNo", "");
}
if (infra.OfficeEmployeeNo > 0)
{
ex.WriteToMergeField("OfficeEmployeeNo", infra.OfficeEmployeeNo.ToString());
}
else
{
ex.WriteToMergeField("OfficeEmployeeNo", "");
}
}
else
{
ex.WriteToMergeField("ProduceAreaNo", "");
ex.WriteToMergeField("OfficeAreaNo", "");
ex.WriteToMergeField("ProduceEmployeeNo", "");
ex.WriteToMergeField("OfficeEmployeeNo", "");
}
UsingElectrict usingElectrict = new UsingElectrict();
UsingElectrictService usingElectrictService = new UsingElectrictService();
usingElectrict = usingElectrictService.GetUsingElectrictByReport(ReportId, false);
if (usingElectrict != null)
{
//Su dung dien 2
if (usingElectrict.Quantity > 0)
{
ex.WriteToMergeField("QuantityResult2", usingElectrict.Quantity.ToString());
}
else
{
ex.WriteToMergeField("QuantityResult2", "");
}
if (usingElectrict.InstalledCapacity > 0)
{
ex.WriteToMergeField("InstalledCapacityResult2", usingElectrict.InstalledCapacity.ToString());
}
else
{
ex.WriteToMergeField("InstalledCapacityResult2", "");
}
if (usingElectrict.Capacity > 0)
{
ex.WriteToMergeField("CapacityResult2", usingElectrict.Capacity.ToString());
}
else
{
ex.WriteToMergeField("CapacityResult2", "");
}
if (usingElectrict.BuyCost > 0)
{
ex.WriteToMergeField("BuyCostResult2", usingElectrict.BuyCost.ToString());
}
else
{
ex.WriteToMergeField("BuyCostResult2", "");
}
if (usingElectrict.BuyCost > 0 && usingElectrict.Capacity > 0)
{
ex.WriteToMergeField("BuyPriceResult2", Math.Round((usingElectrict.BuyCost / (usingElectrict.Capacity * 1000)), 0).ToString());
}
else
{
ex.WriteToMergeField("BuyPriceResult2", "");
}
if (usingElectrict.ProduceQty > 0)
{
ex.WriteToMergeField("ProduceQtyResult2", usingElectrict.ProduceQty.ToString());
}
else
{
ex.WriteToMergeField("ProduceQtyResult2", "");
}
if (usingElectrict.Technology != null)
{
ex.WriteToMergeField("TechnologyResult2", usingElectrict.Technology.ToString());
}
else
{
ex.WriteToMergeField("TechnologyResult2", "");
}
if (usingElectrict.FuelId > 0)
{
Fuel fuel = new Fuel();
fuel = new FuelService().FindByKey(usingElectrict.FuelId);
if (fuel != null)
{
ex.WriteToMergeField("FuelNameResult2", fuel.FuelName);
ex.WriteToMergeField("FuelNameResult", fuel.FuelName);
}
else
{
ex.WriteToMergeField("FuelNameResult2", "");
ex.WriteToMergeField("FuelNameResult", "");
}
}
else
{
ex.WriteToMergeField("FuelNameResult2", "");
ex.WriteToMergeField("FuelNameResult", "");
}
if (usingElectrict.PriceProduce > 0)
{
ex.WriteToMergeField("PriceProduceResult2", usingElectrict.PriceProduce.ToString());
}
else
{
ex.WriteToMergeField("PriceProduceResult2", "");
}
//Su dung dien 1
if (usingElectrict.Quantity > 0)
{
ex.WriteToMergeField("QuantityResult", usingElectrict.Quantity.ToString());
}
else
{
ex.WriteToMergeField("QuantityResult", "");
}
if (usingElectrict.InstalledCapacity > 0)
{
ex.WriteToMergeField("InstalledCapacityResult", usingElectrict.InstalledCapacity.ToString());
}
else
{
ex.WriteToMergeField("InstalledCapacityResult", "");
}
if (usingElectrict.Capacity > 0)
{
ex.WriteToMergeField("CapacityResult", usingElectrict.Capacity.ToString());
}
else
{
ex.WriteToMergeField("CapacityResult", "");
}
if (usingElectrict.BuyCost > 0)
{
ex.WriteToMergeField("BuyCostResult", usingElectrict.BuyCost.ToString());
}
else
{
ex.WriteToMergeField("BuyCostResult", "");
}
if (usingElectrict.BuyCost > 0 && usingElectrict.Capacity > 0)
{
ex.WriteToMergeField("BuyPriceResult", Math.Round((usingElectrict.BuyCost / (usingElectrict.Capacity * 1000)), 0).ToString());
}
else
{
ex.WriteToMergeField("BuyPriceResult", "");
}
if (usingElectrict.ProduceQty > 0)
{
ex.WriteToMergeField("ProduceQtyResult", usingElectrict.ProduceQty.ToString());
}
else
{
ex.WriteToMergeField("ProduceQtyResult", "");
}
if (usingElectrict.Technology != null)
{
ex.WriteToMergeField("TechnologyResult", usingElectrict.Technology.ToString());
}
else
{
ex.WriteToMergeField("TechnologyResult", "");
}
if (usingElectrict.FuelId > 0)
{
ex.WriteToMergeField("FuelNameResult", usingElectrict.FuelId.ToString());
}
else
{
ex.WriteToMergeField("FuelNameResult", "");
}
}
else
{
ex.WriteToMergeField("QuantityResult2", "");
ex.WriteToMergeField("InstalledCapacityResult2", "");
ex.WriteToMergeField("CapacityResult2", "");
ex.WriteToMergeField("BuyCostResult2", "");
ex.WriteToMergeField("ProduceQtyResult2", "");
ex.WriteToMergeField("TechnologyResult2", "");
ex.WriteToMergeField("FuelNameResult2", "");
ex.WriteToMergeField("PriceProduceResult2", "");
ex.WriteToMergeField("QuantityResult", "");
ex.WriteToMergeField("InstalledCapacityResult", "");
ex.WriteToMergeField("CapacityResult", "");
ex.WriteToMergeField("BuyCostResult", "");
ex.WriteToMergeField("ProduceQtyResult", "");
ex.WriteToMergeField("TechnologyResult", "");
ex.WriteToMergeField("FuelNameResult", "");
}
usingElectrict = new UsingElectrict();
usingElectrict = usingElectrictService.GetUsingElectrictByReport(ReportId, true);
if (usingElectrict != null)
{
//Su dung dien 2
if (usingElectrict.Quantity > 0)
{
ex.WriteToMergeField("QuantityPlan", usingElectrict.Quantity.ToString());
}
else
{
ex.WriteToMergeField("QuantityPlan", "");
}
if (usingElectrict.InstalledCapacity > 0)
{
ex.WriteToMergeField("InstalledCapacityPlan", usingElectrict.InstalledCapacity.ToString());
}
else
{
ex.WriteToMergeField("InstalledCapacityPlan", "");
}
if (usingElectrict.Capacity > 0)
{
ex.WriteToMergeField("CapacityPlan", usingElectrict.Capacity.ToString());
}
else
{
ex.WriteToMergeField("CapacityPlan", "");
}
if (usingElectrict.BuyCost > 0)
{
ex.WriteToMergeField("BuyCostPlan", usingElectrict.BuyCost.ToString());
}
else
{
ex.WriteToMergeField("BuyCostPlan", "");
}
if (usingElectrict.BuyCost > 0)
{
ex.WriteToMergeField("BuyPricePlan", usingElectrict.BuyCost.ToString());
}
else
{
ex.WriteToMergeField("BuyPricePlan", "");
}
if (usingElectrict.ProduceQty > 0)
{
ex.WriteToMergeField("ProduceQtyPlan", usingElectrict.ProduceQty.ToString());
}
else
{
ex.WriteToMergeField("ProduceQtyPlan", "");
}
if (usingElectrict.Technology != null)
{
ex.WriteToMergeField("TechnologyPlan", usingElectrict.Technology.ToString());
}
else
{
ex.WriteToMergeField("TechnologyPlan", "");
}
if (usingElectrict.FuelId > 0)
{
Fuel fuel = new Fuel();
fuel = new FuelService().FindByKey(usingElectrict.FuelId);
if (fuel != null)
{
ex.WriteToMergeField("FuelNamePlan", fuel.FuelName);
}
else
{
ex.WriteToMergeField("FuelNamePlan", "");
}
}
else
{
ex.WriteToMergeField("FuelNamePlan", "");
}
if (usingElectrict.PriceProduce > 0)
{
ex.WriteToMergeField("PriceProducePlan", usingElectrict.PriceProduce.ToString());
}
else
{
ex.WriteToMergeField("PriceProducePlan", "");
}
}
else
{
ex.WriteToMergeField("QuantityPlan", "");
ex.WriteToMergeField("InstalledCapacityPlan", "");
ex.WriteToMergeField("CapacityPlan", "");
ex.WriteToMergeField("BuyCostPlan", "");
ex.WriteToMergeField("ProduceQtyPlan", "");
ex.WriteToMergeField("TechnologyPlan", "");
ex.WriteToMergeField("FuelNamePlan", "");
ex.WriteToMergeField("PriceProducePlan", "");
}
DataTable dthientai = new DataTable();
DataTable dtdukien = new DataTable();
DataSet dshientai = new DataSet("tbl1");
DataTable dt = new DataTable();
dt = new ReportFuelDetailService().GetNoFuelDetailByReport(ReportId, false);
dt.Columns.Add("dvnhietnang", typeof(string));
dt.Columns.Add("dvnhieulieu", typeof(string));
dthientai = dt.Clone();
foreach (DataRow item in dt.Rows)
{
DataRow workRow = null;
workRow = dthientai.NewRow();
workRow = item;
if (workRow["MeasurementName"].ToString().Contains("Mét khối"))
{
workRow["dvnhietnang"] = "kJ/m3";
}
else
{
workRow["dvnhietnang"] = "kJ/kg";
}
if (workRow["MeasurementName"].ToString().Contains("tấn") || workRow["MeasurementName"].ToString().Contains("Klg"))
{
workRow["dvnhieulieu"] = "kJ/tấn";
}
else
{
workRow["dvnhieulieu"] = "đ/m3";
}
workRow.AcceptChanges();
dthientai.AcceptChanges();
dthientai.ImportRow(workRow);
}
dt = new ReportFuelDetailService().GetNoFuelDetailByReport(ReportId, true);
dt.Columns.Add("dvnhietnang", typeof(string));
dt.Columns.Add("dvnhieulieu", typeof(string));
dtdukien = dt.Clone();
foreach (DataRow item in dt.Rows)
{
DataRow workRow = null;
workRow = dtdukien.NewRow();
workRow = item;
if (workRow["MeasurementName"].ToString().Contains("Mét khối"))
{
workRow["dvnhietnang"] = "kJ/m3";
}
else
{
workRow["dvnhietnang"] = "kJ/kg";
}
if (workRow["MeasurementName"].ToString().Contains("tấn") || workRow["MeasurementName"].ToString().Contains("Klg"))
{
workRow["dvnhieulieu"] = "kJ/tấn";
}
else
{
workRow["dvnhieulieu"] = "đ/m3";
}
workRow.AcceptChanges();
dtdukien.ImportRow(workRow);
dtdukien.AcceptChanges();
}
ProductCapacityService productCapacityService = new ProductCapacityService();
DataTable tblProductResult = new DataTable();
tblProductResult = productCapacityService.GetDataCapacity(ReportId, false);
dshientai.Merge(tblProductResult);
dshientai.Tables[0].TableName = "tbl1";
dshientai.Merge(dthientai);
dshientai.Tables[1].TableName = "tbl2";
//ex.WriteDataSetToMergeField(dshientai);
DataTable tblProductPlan = new DataTable();
tblProductPlan = productCapacityService.GetDataCapacity(ReportId, true);
dshientai.Merge(tblProductPlan);
dshientai.Tables[2].TableName = "tbl3";
dshientai.Merge(dtdukien);
dshientai.Tables[3].TableName = "tbl4";
//ex.WriteDataSetToMergeField(dshientai);
DataSet dsData = new DataSet();
PlanTBService plangpservice = new PlanTBService();
PlanTKNLService plangTKNLservice = new PlanTKNLService();
DataTable tblGPTKNLPlan = new DataTable();
tblGPTKNLPlan = plangTKNLservice.GetPlanTKNLEnerprise(Convert.ToInt32(memVal.OrgId), ReportId, false, true);
dshientai.Merge(tblGPTKNLPlan);
dshientai.Tables[4].TableName = "tbl5";
DataTable tblTBPlan = new DataTable();
tblTBPlan = plangpservice.GetPlanTBEnterprise(memVal.OrgId, ReportId, false, true);
dshientai.Merge(tblTBPlan);
dshientai.Tables[5].TableName = "tbl6";
dshientai.Merge(tblProductPlan.Copy());
dshientai.Tables[6].TableName = "tbl7";
dshientai.Merge(dthientai.Copy());
dshientai.Tables[7].TableName = "tbl8";
DataTable tblGPTKNLResult = new DataTable();
tblGPTKNLResult = plangTKNLservice.GetPlanTKNLEnerprise(Convert.ToInt32(memVal.OrgId), ReportId, false, false);
dshientai.Merge(tblGPTKNLResult);
dshientai.Tables[8].TableName = "tbl9";
DataTable tblTBResult = new DataTable();
tblTBResult = plangpservice.GetPlanTBEnterprise(memVal.OrgId, ReportId, false, false);
dshientai.Merge(tblTBResult);
dshientai.Tables[9].TableName = "tbl10";
dshientai.Tables.Add(tblTBResult.Copy());
dshientai.Tables[10].TableName = "tbl11";
ex.WriteDataSetToMergeField(dshientai);
// dsg.Tables.Add(dst);
//var dt2 = ExcelExportHelper.CreateGroupInDT(dt, "DepName", "STT");
#endregion
ex.Save(Server.MapPath(ResolveUrl("~") + "TempReport/" + memVal.UserName + ".Bao-cao-hang-nam-" + dtinfo.Rows[0]["Year"] + ".doc"));
HttpContext.Current.Response.Redirect(string.Format("~/Download.aspx?fp={0}&fn={1}",
System.IO.Path.GetFileName(Server.MapPath(ResolveUrl("~") + "TempReport/" + memVal.UserName + ".Bao-cao-hang-nam-" + dtinfo.Rows[0]["Year"] + ".doc")),
""
));
}
