/// <summary>
/// 绑定安检人工报告单
/// </summary>
/// <param name="strKey"></param>
/// <param name="strPath"></param>
/// <param name="bSingle"></param>
/// <returns></returns>
public ReportDocument BindAJRGReportEx(string strKey, string strPath, bool bSingle)
{
ReportDocument document = new ReportDocument();
document.Load(strPath);
RESULT_VEHICLE_INFO_BLL bll = new RESULT_VEHICLE_INFO_BLL();
var vehicleInfo = bll.GetModelList("ID=" + strKey);
AJReport ajReport = new AJReport(vehicleInfo[0], bSingle);
rpt.DsAJRG ds = new rpt.DsAJRG();
ds = (rpt.DsAJRG)ajReport.BindReportResource_RG(ds);
document.SetDataSource(ds);
return(document);
}
/// 绑定安检仪器报告单
/// </summary>
/// <param name="strKey"></param>
/// <param name="strPath"></param>
/// <returns></returns>
public ReportDocument BindAJYQReportEx(string strKey, string strPath, bool bSingle)
{
RESULT_VEHICLE_INFO_BLL bll = new RESULT_VEHICLE_INFO_BLL();
var vehicleInfo = bll.GetModelList("ID=" + strKey);
ReportDocument document = new ReportDocument();
document.Load(strPath);
rpt.DsAJ_YQ ds = new rpt.DsAJ_YQ();
AJReport ajReport = new AJReport(vehicleInfo[0], bSingle);
ajReport.PassC = "○";
ajReport.FailC = "×";
ajReport.NoAudit = "-";
ajReport.NoTest = "-";
ds = (rpt.DsAJ_YQ)ajReport.BindReportSource_YQ(ds);
document.SetDataSource(ds);
return(document);
}
/// <summary>
/// 绑定安检报告单
/// </summary>
/// <param name="strKey">ID</param>
/// <param name="strPath">路径</param>
/// <param name="bSingle">是不是单次打印</param>
/// <returns>ReportDocument for AJ</returns>
public ReportDocument BindAJReportEx(string strKey, string strPath, bool bSingle)
{
ReportDocument document = new ReportDocument();
document.Load(strPath);
RESULT_VEHICLE_INFO_BLL bll = new RESULT_VEHICLE_INFO_BLL();
var vehicleInfo = bll.GetModelList("ID=" + strKey);
AJReport ajReport = new AJReport(vehicleInfo[0], bSingle);
rpt.DsAJ_BGD ds = new rpt.DsAJ_BGD();
Dictionary <string, Tuple <string, string, string> > dicFialItems;
ds = (rpt.DsAJ_BGD)ajReport.BindReportResource_Report(ds, out dicFialItems);
document.SetDataSource(ds);
return(document);
}
InitData(string JCLSH, string connectionString = null)
{
RESULT_VEHICLE_INFO_BLL bllVehicleInfo = new RESULT_VEHICLE_INFO_BLL();
m_vehInfo = bllVehicleInfo.GetModel(JCLSH);
INSPECTION_DEV_REG_INFO_BLL bllDev = new INSPECTION_DEV_REG_INFO_BLL();
var arrDevs = bllDev.GetModelList(string.Format(" JCXH = '{0}' ", m_vehInfo.JCXH));
m_dev = new List <INSPECTION_DEV_REG_INFO>();
foreach (var dev in arrDevs)
{
m_dev.Add(dev);
}
RESULT_OBD_BLL bllOBD = new RESULT_OBD_BLL();
RESULT_OBD[] obds = bllOBD.GetModelList("JCLSH='{0}'".FormatWith(JCLSH));
if (obds.Length > 0)
{
m_obd = obds[0];
}
else
{
m_obd = null;
}
if (m_vehInfo.RLLBDH == "A" || m_vehInfo.RLLBDH == "E")
{
if (m_vehInfo.JYXM.Contains("X2"))
{
RESULT_ASM_BLL bllASM = new RESULT_ASM_BLL();
m_asm = bllASM.GetModel(JCLSH);
}
if (m_vehInfo.JYXM.Contains("X1"))
{
RESULT_SDS_BLL bllSDS = new RESULT_SDS_BLL();
m_sds = bllSDS.GetModel(JCLSH);
}
if (m_vehInfo.JYXM.Contains("X3"))
{
RESULT_VMAS_BLL bllVMAS = new RESULT_VMAS_BLL();
m_vmas = bllVMAS.GetModel(JCLSH);
}
m_ld = null;
m_zyjs = null;
}
else if (m_vehInfo.RLLBDH == "B")
{
if (m_vehInfo.JYXM.Contains("X4"))
{
RESULT_LD_BLL bllLD = new RESULT_LD_BLL();
m_ld = bllLD.GetModel(JCLSH);
}
if (m_vehInfo.JYXM.Contains("X5"))
{
RESULT_ZYJS_BLL bllZYJS = new RESULT_ZYJS_BLL();
m_zyjs = bllZYJS.GetModel(JCLSH);
}
m_asm = null;
m_sds = null;
m_vmas = null;
}
}
Search()
{
//DbAccess db;
//if (m_connectionString.IsEffective()) db = new DbAccess(m_connectionString, false);
//else db = new DbAccess();
string VIN = txtVIN.Text.Trim();
string condition = "";
if (VIN.IsEffective())
{
condition = "AND (VIN LIKE '%{0}%')".FormatWith(VIN);
}
condition += @"AND ( CONVERT( VARCHAR(10),CLXXSJ,120) >= CONVERT( VARCHAR(10),'{0}',120 ) ) ".FormatWith(startTime.Text);
condition += @"AND ( CONVERT( VARCHAR(10),CLXXSJ,120 ) <= CONVERT( VARCHAR(10),'{0}',120 ) )".FormatWith(endTime.Text);
RESULT_VEHICLE_INFO_BLL bllVehicleInfo = new RESULT_VEHICLE_INFO_BLL();
// string query = string.Format(@" SELECT *
// FROM (
// SELECT ROW_NUMBER() OVER (ORDER BY ID DESC) AS ROWID,*
// FROM RESULT_VEHICLE_INFO
// WHERE CHARINDEX('X',JYXM)<>'0'{0} ) AS B
// WHERE ROWID BETWEEN {1} AND {2}",
// condition, m_CurrentPage == 1 ? 1 : (m_CurrentPage - 1) * PAGE_SIZE, m_CurrentPage * PAGE_SIZE);
string query = string.Format("( CHARINDEX('X',JYXM)<>'0' or CHARINDEX('O',JYXM)<>'0') {0} ", condition);
m_resultList = bllVehicleInfo.GetModelList(query, m_CurrentPage, 20);
//List<RESULT_VEHICLE_INFO> LstVehs = new List<RESULT_VEHICLE_INFO>();
if (m_resultList == null || m_resultList.Length == 0)
{
MessageBox.Show("没有数据");
return;
}
foreach (RESULT_VEHICLE_INFO veh in m_resultList)
{
//RESULT_VEHICLE_INFO info = new RESULT_VEHICLE_INFO();
//string hb = Get_HB_JYXM(veh.JYXM);
//switch (hb)
//{
// case "X1":
// veh.JYXM = ISPMSD.X1;
// break;
// //ASM
// case "X2":
// veh.JYXM = ISPMSD.X2;
// break;
// //VMAS
// case "X3":
// veh.JYXM = ISPMSD.X3;
// break;
// case "X4":
// veh.JYXM = ISPMSD.X4;
// break;
// case "X5": veh.JYXM = ISPMSD.X5;
// break;
// case "X6": veh.JYXM = ISPMSD.X6;
// break;
//}
if (veh.Z_PD == "1")
{
veh.Z_PD = "合格";
}
else if (veh.Z_PD == "2")
{
veh.Z_PD = "不合格";
}
}
this.dataGridView1.DataSource = m_resultList;
}
/// <summary>
/// 导出报告单
/// </summary>
/// <param name="jclsh"></param>
public void SearchAndOutPut(string jclsh)
{
try
{
string query = " ( CHARINDEX('X',JYXM)<>'0' or CHARINDEX('O',JYXM)<>'0') and jclsh='" + jclsh + "'";
RESULT_VEHICLE_INFO_BLL bllVehicleInfo = new RESULT_VEHICLE_INFO_BLL();
RESULT_VEHICLE_INFO[] lstVehs = bllVehicleInfo.GetModelList(query, 0, 2);
if (lstVehs == null || lstVehs.Length == 0)
{
PUBControl.SYS_LOG.write_log("PrintReport.log", "未找到" + jclsh);
return;
}
foreach (RESULT_VEHICLE_INFO veh in lstVehs)
{
string hb = Get_HB_JYXM(veh.JYXM);
switch (hb)
{
case "X1":
veh.JYXM = ISPMSD.X1;
break;
//ASM
case "X2":
veh.JYXM = ISPMSD.X2;
break;
//VMAS
case "X3":
veh.JYXM = ISPMSD.X3;
break;
case "X4":
veh.JYXM = ISPMSD.X4;
break;
case "X5":
veh.JYXM = ISPMSD.X5;
break;
case "X6":
veh.JYXM = ISPMSD.X6;
break;
}
if (veh.Z_PD == "1")
{
veh.Z_PD = "合格";
}
else if (veh.Z_PD == "2")
{
veh.Z_PD = "不合格";
}
}
WndReport reportViewer = new WndReport(lstVehs[0]);
// reportViewer.Show();
// System.Threading.Thread.Sleep(1000);
reportViewer.OutPutPdf(System.IO.Directory.GetParent(Application.StartupPath).FullName + "\\data\\" +
jclsh + ".pdf");
reportViewer.Close();
}
catch (Exception ex)
{
PUBControl.SYS_LOG.write_log("PrintReport.log", "自动打印：" + ex.Message);
}
}
