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)); }