OpenReportViewer()
{
try
{
if (dataGridView1.CurrentRow != null)
{
RESULT_VEHICLE_INFO vehicleInfo =
dataGridView1.CurrentRow.DataBoundItem as RESULT_VEHICLE_INFO;
if (m_canEdit)
{
DialogResult dialogResult = MessageBox.Show("需要增补车辆基本信息吗？", "Attetion",
MessageBoxButtons.YesNo, MessageBoxIcon.Warning);
if (dialogResult == DialogResult.Yes)
{
WndEdit wndEdit = new WndEdit(vehicleInfo.JCLSH)
{
ControlBox = false, FormBorderStyle = FormBorderStyle.FixedSingle
};
wndEdit.ShowDialog();
}
}
WndReport reportViewer = new WndReport(vehicleInfo);
reportViewer.Show();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
public RESULT_VEHICLE_INFO GetResultVehicleInfoByJCLSH(string strJCLSH)
{
SqlDataReader sdr = SqlHelper.ExecuteReader(CommandType.Text, string.Format("SELECT * FROM RESULT_VEHICLE_INFO WHERE JCLSH = '{0}'", strJCLSH));
RESULT_VEHICLE_INFO entity = FillEntity <RESULT_VEHICLE_INFO>(sdr);
return(entity);
}
WndReport(RESULT_VEHICLE_INFO vehicleInfo)
{
InitializeComponent();
this.WindowState = FormWindowState.Maximized;
this.FormClosing += WndReport_FormClosing;
if (vehicleInfo.JYXM.Contains("X"))
{
if (vehicleInfo.RLLBDH == "A" || vehicleInfo.RLLBDH == "E")
{
m_Report = new GasolineReport(vehicleInfo.JCLSH);
m_Report.ResetReportData();
crystalReportViewer1.ReportSource = m_Report.ReportInstance();
}
else if (vehicleInfo.RLLBDH == "B")
{
m_Report = new DieselReport(vehicleInfo.JCLSH);
m_Report.ResetReportData();
crystalReportViewer1.ReportSource = m_Report.ReportInstance();
}
}
else
{
m_Report = new ObdReport(vehicleInfo.JCLSH);
m_Report.ResetReportData();
crystalReportViewer1.ReportSource = m_Report.ReportInstance();
}
}
DocumentDestructor()
{
m_doc.Close();
m_doc.Dispose();
m_doc = null;
m_vehInfo = null;
m_asm = null;
m_sds = null;
m_ld = null;
m_zyjs = null;
m_docReady = false;
m_obd = null;
m_dev = null;
}
public List <RESULT_VEHICLE_INFO> GetResultVehicleList()
{
List <RESULT_VEHICLE_INFO> list = new List <RESULT_VEHICLE_INFO>();
SqlDataReader sdr = SqlHelper.ExecuteReader(CommandType.Text, "SELECT TOP 10 * FROM RESULT_VEHICLE_INFO");
while (sdr.Read())
{
RESULT_VEHICLE_INFO enity = new RESULT_VEHICLE_INFO();
enity.JCLSH = (string)sdr["JCLSH"];
list.Add(enity);
}
return(list);
}
public void UpdateResultVehicleInfo(RESULT_VEHICLE_INFO entity)
{
PropertyInfo[] propertyInfos = entity.GetType().GetProperties();
string strSql = "UPDATE RESULT_VEHICLE_INFO SET ";
foreach (PropertyInfo p in propertyInfos)
{
if (p.Name != "ID" && p.Name != "JCLSH")
{
strSql += string.Format("{0}='{1}',", p.Name, p.GetValue(entity, null));
}
}
strSql = strSql.Substring(0, strSql.Length - 1);
strSql += string.Format(" WHERE JCLSH ='{0}'", entity.JCLSH);
SqlHelper.ExcuteNonQuery(CommandType.Text, strSql);
}
public void LoadBaseData(string strJCLSH)
{
IRESULT_VEHICLE_INFO_BLL bll = ObjectFactory.CreateObject <IRESULT_VEHICLE_INFO_BLL>();
m_RESULT_VEHICLE_INFO = bll.GetResultVehicleInfoByJCLSH(strJCLSH);
PropertyInfo[] propertyInfo = m_RESULT_VEHICLE_INFO.GetType().GetProperties();
foreach (Control col in tabBase.Controls)
{
if (col is FieldTxt)
{
FieldTxt fieldTxt = (FieldTxt)col;
foreach (PropertyInfo p in propertyInfo)
{
if (p.Name == fieldTxt.Name.Replace("txt", ""))
{
fieldTxt.Text = (string)p.GetValue(m_RESULT_VEHICLE_INFO, null);
}
}
}
}
}
/// <summary>
/// 添加一条数据
/// </summary>
public bool Insert(RESULT_VEHICLE_INFO model)
{
return(g_DAL.Insert(model));
}
/// <summary>
/// 添加一条数据 SQL
/// </summary>
public string InsertSQL(RESULT_VEHICLE_INFO model)
{
return(g_DAL.InsertSQL(model));
}
/// <summary>
/// 修改全部数据
/// </summary>
public bool UpdateAll(RESULT_VEHICLE_INFO model)
{
return(g_DAL.UpdateAll(model));
}
/// <summary>
/// 修改全部数据 SQL
/// </summary>
public string UpdateAllSQL(RESULT_VEHICLE_INFO model)
{
return(g_DAL.UpdateAllSQL(model));
}
/// <summary>
/// 修改一个集合
/// </summary>
public bool UpdateRange(RESULT_VEHICLE_INFO model, string p_strWhere)
{
return(g_DAL.UpdateRange(model, p_strWhere));
}
/// <summary>
/// 修改一个集合 SQL
/// </summary>
public string UpdateRangeSQL(RESULT_VEHICLE_INFO model, string p_strWhere)
{
return(g_DAL.UpdateRangeSQL(model, p_strWhere));
}
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;
}
}
public bool UpdateResultVehicleInfo(RESULT_VEHICLE_INFO info)
{
dal.UpdateResultVehicleInfo(info);
return(false);
}
/// <summary>
/// 修改一条数据 SQL
/// </summary>
public string UpdateSQL(RESULT_VEHICLE_INFO model, string strJCLSH)
{
return(g_DAL.UpdateSQL(model, strJCLSH));
}
public WndEdit(string jclsh)
{
InitializeComponent();
m_db = new MSSqlAccess(dbConfig.g_strConnectionStringSqlClient1);
m_info = m_db.Find <RESULT_VEHICLE_INFO>("JCLSH", jclsh);
}
/// <summary>
/// 修改一条数据
/// </summary>
public bool Update(RESULT_VEHICLE_INFO model, string strJCLSH)
{
return(g_DAL.Update(model, strJCLSH));
}
