/// <summary> /// 得到一个对象实体 /// </summary> public DEV_STANDARD_VMAS GetModel(int intID) { string strSql = ""; strSql += "select * from DEV_STANDARD_VMAS"; strSql += " where "; strSql += " ID=" + intID + ""; DataTable dtTemp = new DataTable(); DbHelper.GetTable(Conn, strSql, ref dtTemp); DEV_STANDARD_VMAS model = new DEV_STANDARD_VMAS(); if (dtTemp.Rows.Count > 0) { model = new DEV_STANDARD_VMAS(); model.ID = dtTemp.Rows[0]["ID"] == DBNull.Value ? 0 : Convert.ToInt32(dtTemp.Rows[0]["ID"]); model.SEARCH_CONDITION = dtTemp.Rows[0]["SEARCH_CONDITION"] == DBNull.Value ? "" : dtTemp.Rows[0]["SEARCH_CONDITION"].ToString(); model.ZXMC = dtTemp.Rows[0]["ZXMC"] == DBNull.Value ? "" : dtTemp.Rows[0]["ZXMC"].ToString(); model.COXZ = dtTemp.Rows[0]["COXZ"] == DBNull.Value ? "" : dtTemp.Rows[0]["COXZ"].ToString(); model.HCXZ = dtTemp.Rows[0]["HCXZ"] == DBNull.Value ? "" : dtTemp.Rows[0]["HCXZ"].ToString(); model.NOXZ = dtTemp.Rows[0]["NOXZ"] == DBNull.Value ? "" : dtTemp.Rows[0]["NOXZ"].ToString(); model.HC_NOXZ = dtTemp.Rows[0]["HC_NOXZ"] == DBNull.Value ? "" : dtTemp.Rows[0]["HC_NOXZ"].ToString(); model.PDFS = dtTemp.Rows[0]["PDFS"] == DBNull.Value ? "" : dtTemp.Rows[0]["PDFS"].ToString(); model.IS_SHOW = dtTemp.Rows[0]["IS_SHOW"] == DBNull.Value ? 0 : Convert.ToInt32(dtTemp.Rows[0]["IS_SHOW"]); model.AREA_NAME = dtTemp.Rows[0]["AREA_NAME"] == DBNull.Value ? "" : dtTemp.Rows[0]["AREA_NAME"].ToString(); model.UTYPE = dtTemp.Rows[0]["UTYPE"] == DBNull.Value ? 0 : Convert.ToInt32(dtTemp.Rows[0]["UTYPE"]); } dtTemp.Dispose(); return(model); }
/// <summary> /// 得到最大JCLSH /// </summary> public string GetMax_JCLSH(string p_strWhere) { string strResult = "0"; string strSql = "select max(JCLSH) as m from RESULT_ZYJS"; if (p_strWhere.Trim().Length > 0) { strSql += " where " + p_strWhere; } DataTable dtTemp = new DataTable(); DbHelper.GetTable(Conn, strSql, ref dtTemp); if (dtTemp.Rows.Count > 0) { if (dtTemp.Rows[0]["m"].ToString().Length > 0) { strResult = dtTemp.Rows[0]["m"] == DBNull.Value ? "" : dtTemp.Rows[0]["m"].ToString(); } } dtTemp.Dispose(); return(string.Format("{0:D50}", Convert.ToInt32(strResult) + 1)); }
/// <summary> /// 判断数据是否存在 /// </summary> public bool Exists(string strJCLSH) { bool bolResult = false; if (strJCLSH == null) { return(false); } if (strJCLSH.Length == 0) { return(false); } string strSql = ""; strSql += "select count(1) as c from RESULT_ZYJS"; strSql += " where "; strSql += " JCLSH='" + strJCLSH + "'"; DataTable dtTemp = new DataTable(); DbHelper.GetTable(Conn, strSql, ref dtTemp); if (dtTemp.Rows.Count > 0) { bolResult = Convert.ToInt32(dtTemp.Rows[0]["c"]) > 0; } dtTemp.Dispose(); return(bolResult); }
/// <summary> /// 得到一个对象实体 /// </summary> public COSTUME_MODEL_LIMIT GetModel(string strMODEL_NAME) { string strSql = ""; strSql += "select * from COSTUME_MODEL_LIMIT"; strSql += " where "; strSql += " MODEL_NAME='" + strMODEL_NAME + "'"; DataTable dtTemp = new DataTable(); DbHelper.GetTable(Conn, strSql, ref dtTemp); COSTUME_MODEL_LIMIT model = new COSTUME_MODEL_LIMIT(); if (dtTemp.Rows.Count > 0) { model = new COSTUME_MODEL_LIMIT(); model.MODEL_NAME = dtTemp.Rows[0]["MODEL_NAME"] == DBNull.Value ? "" : dtTemp.Rows[0]["MODEL_NAME"].ToString(); model.METHOD_NAME = dtTemp.Rows[0]["METHOD_NAME"] == DBNull.Value ? "" : dtTemp.Rows[0]["METHOD_NAME"].ToString(); } dtTemp.Dispose(); return(model); }
/// <summary> /// 判断数据是否存在 /// </summary> public bool Exists(string strMODEL_NAME) { bool bolResult = false; if (strMODEL_NAME == null) { return(false); } if (strMODEL_NAME.Length == 0) { return(false); } string strSql = ""; strSql += "select count(1) as c from COSTUME_MODEL_LIMIT"; strSql += " where "; strSql += " MODEL_NAME='" + strMODEL_NAME + "'"; DataTable dtTemp = new DataTable(); DbHelper.GetTable(Conn, strSql, ref dtTemp); if (dtTemp.Rows.Count > 0) { bolResult = Convert.ToInt32(dtTemp.Rows[0]["c"]) > 0; } dtTemp.Dispose(); return(bolResult); }
/// <summary> /// 得到最大ID /// </summary> public int GetMax_ID(string p_strWhere) { int intResult = 0; string strSql = "select max(ID) as m from DEV_STANDARD_SDS"; if (p_strWhere.Trim().Length > 0) { strSql += " where " + p_strWhere; } DataTable dtTemp = new DataTable(); DbHelper.GetTable(Conn, strSql, ref dtTemp); if (dtTemp.Rows.Count > 0) { if (dtTemp.Rows[0]["m"].ToString().Length > 0) { intResult = dtTemp.Rows[0]["m"] == DBNull.Value ? 0 : Convert.ToInt32(dtTemp.Rows[0]["m"]); } } dtTemp.Dispose(); return(intResult + 1); }
/// <summary> /// 获取数据总记录数 /// </summary> public int GetRecordCount(string p_strWhere) { int intResult = 0; string strSql = ""; strSql += "select count(1) as c from DEV_STANDARD_SDS"; if (p_strWhere.Trim().Length > 0) { strSql += " where " + p_strWhere; } DataTable dtTemp = new DataTable(); DbHelper.GetTable(Conn, strSql, ref dtTemp); if (dtTemp.Rows.Count > 0) { intResult = Convert.ToInt32(dtTemp.Rows[0]["c"]); } dtTemp.Dispose(); return(intResult); }
/// <summary> /// 得到对象集合 /// </summary> public COSTUME_MODEL_LIMIT[] GetModelList(string p_strWhere, string p_strOrder, int p_intPageNumber, int p_intPageSize) { int m_intPageNumber = p_intPageNumber; int m_intPageCount = GetPageCount(p_strWhere, p_intPageSize); if ((m_intPageNumber < 1) || (m_intPageNumber == 0)) { m_intPageNumber = 1; } if (m_intPageNumber == -1) { m_intPageNumber = m_intPageCount; } if (m_intPageNumber > m_intPageCount) { m_intPageNumber = m_intPageCount; } string strSql = ""; strSql += "select * from COSTUME_MODEL_LIMIT"; if (p_strWhere.Trim().Length > 0) { strSql += " where " + p_strWhere; } if (p_strOrder.Trim().Length > 0) { strSql += " order by " + p_strOrder; } DataTable dtTemp = new DataTable(); if (p_intPageSize > 0) { DbHelper.GetTable(Conn, strSql, ref dtTemp, (m_intPageNumber - 1) * p_intPageSize, p_intPageSize); } else { DbHelper.GetTable(Conn, strSql, ref dtTemp); } COSTUME_MODEL_LIMIT[] arrModel = new COSTUME_MODEL_LIMIT[dtTemp.Rows.Count]; for (int N = 0; N < dtTemp.Rows.Count; N++) { arrModel[N] = new COSTUME_MODEL_LIMIT(); arrModel[N].MODEL_NAME = dtTemp.Rows[N]["MODEL_NAME"] == DBNull.Value ? "" : dtTemp.Rows[N]["MODEL_NAME"].ToString(); arrModel[N].METHOD_NAME = dtTemp.Rows[N]["METHOD_NAME"] == DBNull.Value ? "" : dtTemp.Rows[N]["METHOD_NAME"].ToString(); } dtTemp.Dispose(); return(arrModel); }
/// <summary> /// 得到一个对象实体 /// </summary> public void GetModel(ref DataTable p_dtData, string strMODEL_NAME) { p_dtData.Clear(); string strSql = ""; strSql += "select * from COSTUME_MODEL_LIMIT"; strSql += " where "; strSql += " MODEL_NAME='" + strMODEL_NAME + "'"; DbHelper.GetTable(Conn, strSql, ref p_dtData); }
/// <summary> /// 得到一个对象实体 /// </summary> public void GetModel(ref DataTable p_dtData, int intID) { p_dtData.Clear(); string strSql = ""; strSql += "select * from INSPECTION_DEV_REG_INFO"; strSql += " where "; strSql += " ID=" + intID + ""; DbHelper.GetTable(Conn, strSql, ref p_dtData); }
/// <summary> /// 得到一个对象实体 /// </summary> public void GetModel(ref DataTable p_dtData, string strJCLSH) { p_dtData.Clear(); string strSql = ""; strSql += "select * from RESULT_ZYJS"; strSql += " where "; strSql += " JCLSH='" + strJCLSH + "'"; DbHelper.GetTable(Conn, strSql, ref p_dtData); }
/// <summary> /// 得到一个对象实体 /// </summary> public void GetModel(ref DataTable p_dtData, int intID) { p_dtData.Clear(); string strSql = ""; strSql += "select * from DEV_STANDARD_SDS"; strSql += " where "; strSql += " ID=" + intID + ""; DbHelper.GetTable(Conn, strSql, ref p_dtData); }
/// <summary> /// 得到一个对象实体 /// </summary> public RESULT_ZYJS GetModel(string strJCLSH) { string strSql = ""; strSql += "select * from RESULT_ZYJS"; strSql += " where "; strSql += " JCLSH='" + strJCLSH + "'"; DataTable dtTemp = new DataTable(); DbHelper.GetTable(Conn, strSql, ref dtTemp); RESULT_ZYJS model = new RESULT_ZYJS(); if (dtTemp.Rows.Count > 0) { model = new RESULT_ZYJS(); model.ID = dtTemp.Rows[0]["ID"] == DBNull.Value ? 0 : Convert.ToInt32(dtTemp.Rows[0]["ID"]); model.ZYJSJCCS = dtTemp.Rows[0]["ZYJSJCCS"] == DBNull.Value ? "" : dtTemp.Rows[0]["ZYJSJCCS"].ToString(); model.JCLSH = dtTemp.Rows[0]["JCLSH"] == DBNull.Value ? "" : dtTemp.Rows[0]["JCLSH"].ToString(); model.ZYJSJG1 = dtTemp.Rows[0]["ZYJSJG1"] == DBNull.Value ? "" : dtTemp.Rows[0]["ZYJSJG1"].ToString(); model.ZYJSJG2 = dtTemp.Rows[0]["ZYJSJG2"] == DBNull.Value ? "" : dtTemp.Rows[0]["ZYJSJG2"].ToString(); model.ZYJSJG3 = dtTemp.Rows[0]["ZYJSJG3"] == DBNull.Value ? "" : dtTemp.Rows[0]["ZYJSJG3"].ToString(); model.ZYJSJG4 = dtTemp.Rows[0]["ZYJSJG4"] == DBNull.Value ? "" : dtTemp.Rows[0]["ZYJSJG4"].ToString(); model.ZYJSPJZ = dtTemp.Rows[0]["ZYJSPJZ"] == DBNull.Value ? "" : dtTemp.Rows[0]["ZYJSPJZ"].ToString(); model.ZYJSXZ = dtTemp.Rows[0]["ZYJSXZ"] == DBNull.Value ? "" : dtTemp.Rows[0]["ZYJSXZ"].ToString(); model.ZYJS_PD = dtTemp.Rows[0]["ZYJS_PD"] == DBNull.Value ? "" : dtTemp.Rows[0]["ZYJS_PD"].ToString(); model.ZYJSYW = dtTemp.Rows[0]["ZYJSYW"] == DBNull.Value ? "" : dtTemp.Rows[0]["ZYJSYW"].ToString(); model.ZYJSDSZS = dtTemp.Rows[0]["ZYJSDSZS"] == DBNull.Value ? "" : dtTemp.Rows[0]["ZYJSDSZS"].ToString(); model.ZYJSWD = dtTemp.Rows[0]["ZYJSWD"] == DBNull.Value ? "" : dtTemp.Rows[0]["ZYJSWD"].ToString(); model.ZYJSDQY = dtTemp.Rows[0]["ZYJSDQY"] == DBNull.Value ? "" : dtTemp.Rows[0]["ZYJSDQY"].ToString(); model.ZYJSSD = dtTemp.Rows[0]["ZYJSSD"] == DBNull.Value ? "" : dtTemp.Rows[0]["ZYJSSD"].ToString(); model.KSSJ = dtTemp.Rows[0]["KSSJ"] == DBNull.Value ? "" : dtTemp.Rows[0]["KSSJ"].ToString(); model.JSSJ = dtTemp.Rows[0]["JSSJ"] == DBNull.Value ? "" : dtTemp.Rows[0]["JSSJ"].ToString(); model.SFLZS = dtTemp.Rows[0]["SFLZS"] == DBNull.Value ? "" : dtTemp.Rows[0]["SFLZS"].ToString(); model.PT_ZYJSJG2 = dtTemp.Rows[0]["PT_ZYJSJG2"] == DBNull.Value ? "" : dtTemp.Rows[0]["PT_ZYJSJG2"].ToString(); model.PT_ZYJSJG3 = dtTemp.Rows[0]["PT_ZYJSJG3"] == DBNull.Value ? "" : dtTemp.Rows[0]["PT_ZYJSJG3"].ToString(); model.PT_ZYJSJG4 = dtTemp.Rows[0]["PT_ZYJSJG4"] == DBNull.Value ? "" : dtTemp.Rows[0]["PT_ZYJSJG4"].ToString(); model.PT_ZYJSPJZ = dtTemp.Rows[0]["PT_ZYJSPJZ"] == DBNull.Value ? "" : dtTemp.Rows[0]["PT_ZYJSPJZ"].ToString(); model.PT_ZYJSDSZS = dtTemp.Rows[0]["PT_ZYJSDSZS"] == DBNull.Value ? "" : dtTemp.Rows[0]["PT_ZYJSDSZS"].ToString(); model.PT_ZYJS_PD = dtTemp.Rows[0]["PT_ZYJS_PD"] == DBNull.Value ? "" : dtTemp.Rows[0]["PT_ZYJS_PD"].ToString(); model.ZYJSZS1 = dtTemp.Rows[0]["ZYJSZS1"] == DBNull.Value ? "" : dtTemp.Rows[0]["ZYJSZS1"].ToString(); model.ZYJSZS2 = dtTemp.Rows[0]["ZYJSZS2"] == DBNull.Value ? "" : dtTemp.Rows[0]["ZYJSZS2"].ToString(); model.ZYJSZS3 = dtTemp.Rows[0]["ZYJSZS3"] == DBNull.Value ? "" : dtTemp.Rows[0]["ZYJSZS3"].ToString(); model.ZYJSZS4 = dtTemp.Rows[0]["ZYJSZS4"] == DBNull.Value ? "" : dtTemp.Rows[0]["ZYJSZS4"].ToString(); } dtTemp.Dispose(); return(model); }
/// <summary> /// 得到一个对象实体 /// </summary> public RESULT_OBD GetModel(int intID) { string strSql = ""; strSql += "select * from RESULT_OBD"; strSql += " where "; strSql += " ID=" + intID + ""; DataTable dtTemp = new DataTable(); DbHelper.GetTable(Conn, strSql, ref dtTemp); RESULT_OBD model = new RESULT_OBD(); if (dtTemp.Rows.Count > 0) { model = new RESULT_OBD(); model.ID = dtTemp.Rows[0]["ID"] == DBNull.Value ? 0 : Convert.ToInt32(dtTemp.Rows[0]["ID"]); model.JCLSH = dtTemp.Rows[0]["JCLSH"] == DBNull.Value ? "" : dtTemp.Rows[0]["JCLSH"].ToString(); model.VIN = dtTemp.Rows[0]["VIN"] == DBNull.Value ? "" : dtTemp.Rows[0]["VIN"].ToString(); model.testdate = dtTemp.Rows[0]["testdate"] == DBNull.Value ? Convert.ToDateTime("1900-01-01") : Convert.ToDateTime(dtTemp.Rows[0]["testdate"]); model.isupdated = dtTemp.Rows[0]["isupdated"] == DBNull.Value ? 0 : Convert.ToInt32(dtTemp.Rows[0]["isupdated"]); model.ZSD_PD = dtTemp.Rows[0]["ZSD_PD"] == DBNull.Value ? "" : dtTemp.Rows[0]["ZSD_PD"].ToString(); model.GZ_PD = dtTemp.Rows[0]["GZ_PD"] == DBNull.Value ? "" : dtTemp.Rows[0]["GZ_PD"].ToString(); model.ECU_VIN = dtTemp.Rows[0]["ECU_VIN"] == DBNull.Value ? "" : dtTemp.Rows[0]["ECU_VIN"].ToString(); model.ECU_CALID = dtTemp.Rows[0]["ECU_CALID"] == DBNull.Value ? "" : dtTemp.Rows[0]["ECU_CALID"].ToString(); model.ECU_CVN = dtTemp.Rows[0]["ECU_CVN"] == DBNull.Value ? "" : dtTemp.Rows[0]["ECU_CVN"].ToString(); model.ECU_PD = dtTemp.Rows[0]["ECU_PD"] == DBNull.Value ? "" : dtTemp.Rows[0]["ECU_PD"].ToString(); model.TX_PD = dtTemp.Rows[0]["TX_PD"] == DBNull.Value ? "" : dtTemp.Rows[0]["TX_PD"].ToString(); model.JX_PD = dtTemp.Rows[0]["JX_PD"] == DBNull.Value ? "" : dtTemp.Rows[0]["JX_PD"].ToString(); model.ALL_PD = dtTemp.Rows[0]["ALL_PD"] == DBNull.Value ? "" : dtTemp.Rows[0]["ALL_PD"].ToString(); model.FreezeData = dtTemp.Rows[0]["FreezeData"] == DBNull.Value ? "" : dtTemp.Rows[0]["FreezeData"].ToString(); model.ECUInfo = dtTemp.Rows[0]["ECUInfo"] == DBNull.Value ? "" : dtTemp.Rows[0]["ECUInfo"].ToString(); model.IUPR = dtTemp.Rows[0]["IUPR"] == DBNull.Value ? "" : dtTemp.Rows[0]["IUPR"].ToString(); model.SystemCheckState = dtTemp.Rows[0]["SystemCheckState"] == DBNull.Value ? "" : dtTemp.Rows[0]["SystemCheckState"].ToString(); model.RTData = dtTemp.Rows[0]["RTData"] == DBNull.Value ? "" : dtTemp.Rows[0]["RTData"].ToString(); model.SRTData = dtTemp.Rows[0]["SRTData"] == DBNull.Value ? "" : dtTemp.Rows[0]["SRTData"].ToString(); model.DTC = dtTemp.Rows[0]["DTC"] == DBNull.Value ? "" : dtTemp.Rows[0]["DTC"].ToString(); model.TX_BHGYY = dtTemp.Rows[0]["TX_BHGYY"] == DBNull.Value ? "" : dtTemp.Rows[0]["TX_BHGYY"].ToString(); model.TX_GZDZT = dtTemp.Rows[0]["TX_GZDZT"] == DBNull.Value ? "" : dtTemp.Rows[0]["TX_GZDZT"].ToString(); } dtTemp.Dispose(); return(model); }
/// <summary> /// 得到对象集合 /// </summary> public void GetModelList(ref DataTable p_dtData, string p_strWhere, string p_strOrder, int p_intPageNumber, int p_intPageSize) { p_dtData.Clear(); int m_intPageNumber = p_intPageNumber; int m_intPageCount = GetPageCount(p_strWhere, p_intPageSize); if ((m_intPageNumber < 1) || (m_intPageNumber == 0)) { m_intPageNumber = 1; } if (m_intPageNumber == -1) { m_intPageNumber = m_intPageCount; } if (m_intPageNumber > m_intPageCount) { m_intPageNumber = m_intPageCount; } string strSql = ""; strSql += "select * from DEV_STANDARD_SDS"; if (p_strWhere.Trim().Length > 0) { strSql += " where " + p_strWhere; } if (p_strOrder.Trim().Length > 0) { strSql += " order by " + p_strOrder; } if (p_intPageSize > 0) { DbHelper.GetTable(Conn, strSql, ref p_dtData, (m_intPageNumber - 1) * p_intPageSize, p_intPageSize); } else { DbHelper.GetTable(Conn, strSql, ref p_dtData); } }
/// <summary> /// 得到一个对象实体 /// </summary> public INSPECTION_DEV_REG_INFO GetModel(int intID) { string strSql = ""; strSql += "select * from INSPECTION_DEV_REG_INFO"; strSql += " where "; strSql += " ID=" + intID + ""; DataTable dtTemp = new DataTable(); DbHelper.GetTable(Conn, strSql, ref dtTemp); INSPECTION_DEV_REG_INFO model = new INSPECTION_DEV_REG_INFO(); if (dtTemp.Rows.Count > 0) { model = new INSPECTION_DEV_REG_INFO(); model.ID = dtTemp.Rows[0]["ID"] == DBNull.Value ? 0 : Convert.ToInt32(dtTemp.Rows[0]["ID"]); model.JCXH = dtTemp.Rows[0]["JCXH"] == DBNull.Value ? 0 : Convert.ToInt32(dtTemp.Rows[0]["JCXH"]); model.SBLX = dtTemp.Rows[0]["SBLX"] == DBNull.Value ? "" : dtTemp.Rows[0]["SBLX"].ToString(); model.SBMC = dtTemp.Rows[0]["SBMC"] == DBNull.Value ? "" : dtTemp.Rows[0]["SBMC"].ToString(); model.SBMCDH = dtTemp.Rows[0]["SBMCDH"] == DBNull.Value ? "" : dtTemp.Rows[0]["SBMCDH"].ToString(); model.SBZZC = dtTemp.Rows[0]["SBZZC"] == DBNull.Value ? "" : dtTemp.Rows[0]["SBZZC"].ToString(); model.SBXH = dtTemp.Rows[0]["SBXH"] == DBNull.Value ? "" : dtTemp.Rows[0]["SBXH"].ToString(); model.SBCCBH = dtTemp.Rows[0]["SBCCBH"] == DBNull.Value ? "" : dtTemp.Rows[0]["SBCCBH"].ToString(); model.SBCCRQ = dtTemp.Rows[0]["SBCCRQ"] == DBNull.Value ? "" : dtTemp.Rows[0]["SBCCRQ"].ToString(); model.SBRZBH = dtTemp.Rows[0]["SBRZBH"] == DBNull.Value ? "" : dtTemp.Rows[0]["SBRZBH"].ToString(); model.SBRZRQ = dtTemp.Rows[0]["SBRZRQ"] == DBNull.Value ? "" : dtTemp.Rows[0]["SBRZRQ"].ToString(); model.SBRZYXQZ = dtTemp.Rows[0]["SBRZYXQZ"] == DBNull.Value ? "" : dtTemp.Rows[0]["SBRZYXQZ"].ToString(); model.JLBDBH = dtTemp.Rows[0]["JLBDBH"] == DBNull.Value ? "" : dtTemp.Rows[0]["JLBDBH"].ToString(); model.JLBDRQ = dtTemp.Rows[0]["JLBDRQ"] == DBNull.Value ? "" : dtTemp.Rows[0]["JLBDRQ"].ToString(); model.JLBDYXQZ = dtTemp.Rows[0]["JLBDYXQZ"] == DBNull.Value ? "" : dtTemp.Rows[0]["JLBDYXQZ"].ToString(); model.BZ = dtTemp.Rows[0]["BZ"] == DBNull.Value ? "" : dtTemp.Rows[0]["BZ"].ToString(); } dtTemp.Dispose(); return(model); }
/// <summary> /// 判断数据是否存在 /// </summary> public bool Exists(int intID) { bool bolResult = false; string strSql = ""; strSql += "select count(1) as c from DEV_STANDARD_SDS"; strSql += " where "; strSql += " ID='" + intID + "'"; DataTable dtTemp = new DataTable(); DbHelper.GetTable(Conn, strSql, ref dtTemp); if (dtTemp.Rows.Count > 0) { bolResult = Convert.ToInt32(dtTemp.Rows[0]["c"]) > 0; } dtTemp.Dispose(); return(bolResult); }
/// <summary> /// 得到对象集合 /// </summary> public DEV_STANDARD_SDS[] GetModelList(string p_strWhere, string p_strOrder, int p_intPageNumber, int p_intPageSize) { int m_intPageNumber = p_intPageNumber; int m_intPageCount = GetPageCount(p_strWhere, p_intPageSize); if ((m_intPageNumber < 1) || (m_intPageNumber == 0)) { m_intPageNumber = 1; } if (m_intPageNumber == -1) { m_intPageNumber = m_intPageCount; } if (m_intPageNumber > m_intPageCount) { m_intPageNumber = m_intPageCount; } string strSql = ""; strSql += "select * from DEV_STANDARD_SDS"; if (p_strWhere.Trim().Length > 0) { strSql += " where " + p_strWhere; } if (p_strOrder.Trim().Length > 0) { strSql += " order by " + p_strOrder; } DataTable dtTemp = new DataTable(); if (p_intPageSize > 0) { DbHelper.GetTable(Conn, strSql, ref dtTemp, (m_intPageNumber - 1) * p_intPageSize, p_intPageSize); } else { DbHelper.GetTable(Conn, strSql, ref dtTemp); } DEV_STANDARD_SDS[] arrModel = new DEV_STANDARD_SDS[dtTemp.Rows.Count]; for (int N = 0; N < dtTemp.Rows.Count; N++) { arrModel[N] = new DEV_STANDARD_SDS(); arrModel[N].ID = dtTemp.Rows[N]["ID"] == DBNull.Value ? 0 : Convert.ToInt32(dtTemp.Rows[N]["ID"]); arrModel[N].SEARCH_CONDITION = dtTemp.Rows[N]["SEARCH_CONDITION"] == DBNull.Value ? "" : dtTemp.Rows[N]["SEARCH_CONDITION"].ToString(); arrModel[N].ZXMC = dtTemp.Rows[N]["ZXMC"] == DBNull.Value ? "" : dtTemp.Rows[N]["ZXMC"].ToString(); arrModel[N].GDSCOXZ = dtTemp.Rows[N]["GDSCOXZ"] == DBNull.Value ? "" : dtTemp.Rows[N]["GDSCOXZ"].ToString(); arrModel[N].GDSHCXZ = dtTemp.Rows[N]["GDSHCXZ"] == DBNull.Value ? "" : dtTemp.Rows[N]["GDSHCXZ"].ToString(); arrModel[N].DSCOXZ = dtTemp.Rows[N]["DSCOXZ"] == DBNull.Value ? "" : dtTemp.Rows[N]["DSCOXZ"].ToString(); arrModel[N].DSHCXZ = dtTemp.Rows[N]["DSHCXZ"] == DBNull.Value ? "" : dtTemp.Rows[N]["DSHCXZ"].ToString(); arrModel[N].GLKQXSSX = dtTemp.Rows[N]["GLKQXSSX"] == DBNull.Value ? "" : dtTemp.Rows[N]["GLKQXSSX"].ToString(); arrModel[N].GLKQXSXX = dtTemp.Rows[N]["GLKQXSXX"] == DBNull.Value ? "" : dtTemp.Rows[N]["GLKQXSXX"].ToString(); arrModel[N].IS_SHOW = dtTemp.Rows[N]["IS_SHOW"] == DBNull.Value ? 0 : Convert.ToInt32(dtTemp.Rows[N]["IS_SHOW"]); arrModel[N].AREA_NAME = dtTemp.Rows[N]["AREA_NAME"] == DBNull.Value ? "" : dtTemp.Rows[N]["AREA_NAME"].ToString(); arrModel[N].UTYPE = dtTemp.Rows[N]["UTYPE"] == DBNull.Value ? 0 : Convert.ToInt32(dtTemp.Rows[N]["UTYPE"]); } dtTemp.Dispose(); return(arrModel); }
/// <summary> /// 得到对象集合 /// </summary> public INSPECTION_DEV_REG_INFO[] GetModelList(string p_strWhere, string p_strOrder, int p_intPageNumber, int p_intPageSize) { int m_intPageNumber = p_intPageNumber; int m_intPageCount = GetPageCount(p_strWhere, p_intPageSize); if ((m_intPageNumber < 1) || (m_intPageNumber == 0)) { m_intPageNumber = 1; } if (m_intPageNumber == -1) { m_intPageNumber = m_intPageCount; } if (m_intPageNumber > m_intPageCount) { m_intPageNumber = m_intPageCount; } string strSql = ""; strSql += "select * from INSPECTION_DEV_REG_INFO"; if (p_strWhere.Trim().Length > 0) { strSql += " where " + p_strWhere; } if (p_strOrder.Trim().Length > 0) { strSql += " order by " + p_strOrder; } DataTable dtTemp = new DataTable(); if (p_intPageSize > 0) { DbHelper.GetTable(Conn, strSql, ref dtTemp, (m_intPageNumber - 1) * p_intPageSize, p_intPageSize); } else { DbHelper.GetTable(Conn, strSql, ref dtTemp); } INSPECTION_DEV_REG_INFO[] arrModel = new INSPECTION_DEV_REG_INFO[dtTemp.Rows.Count]; for (int N = 0; N < dtTemp.Rows.Count; N++) { arrModel[N] = new INSPECTION_DEV_REG_INFO(); arrModel[N].ID = dtTemp.Rows[N]["ID"] == DBNull.Value ? 0 : Convert.ToInt32(dtTemp.Rows[N]["ID"]); arrModel[N].JCXH = dtTemp.Rows[N]["JCXH"] == DBNull.Value ? 0 : Convert.ToInt32(dtTemp.Rows[N]["JCXH"]); arrModel[N].SBLX = dtTemp.Rows[N]["SBLX"] == DBNull.Value ? "" : dtTemp.Rows[N]["SBLX"].ToString(); arrModel[N].SBMC = dtTemp.Rows[N]["SBMC"] == DBNull.Value ? "" : dtTemp.Rows[N]["SBMC"].ToString(); arrModel[N].SBMCDH = dtTemp.Rows[N]["SBMCDH"] == DBNull.Value ? "" : dtTemp.Rows[N]["SBMCDH"].ToString(); arrModel[N].SBZZC = dtTemp.Rows[N]["SBZZC"] == DBNull.Value ? "" : dtTemp.Rows[N]["SBZZC"].ToString(); arrModel[N].SBXH = dtTemp.Rows[N]["SBXH"] == DBNull.Value ? "" : dtTemp.Rows[N]["SBXH"].ToString(); arrModel[N].SBCCBH = dtTemp.Rows[N]["SBCCBH"] == DBNull.Value ? "" : dtTemp.Rows[N]["SBCCBH"].ToString(); arrModel[N].SBCCRQ = dtTemp.Rows[N]["SBCCRQ"] == DBNull.Value ? "" : dtTemp.Rows[N]["SBCCRQ"].ToString(); arrModel[N].SBRZBH = dtTemp.Rows[N]["SBRZBH"] == DBNull.Value ? "" : dtTemp.Rows[N]["SBRZBH"].ToString(); arrModel[N].SBRZRQ = dtTemp.Rows[N]["SBRZRQ"] == DBNull.Value ? "" : dtTemp.Rows[N]["SBRZRQ"].ToString(); arrModel[N].SBRZYXQZ = dtTemp.Rows[N]["SBRZYXQZ"] == DBNull.Value ? "" : dtTemp.Rows[N]["SBRZYXQZ"].ToString(); arrModel[N].JLBDBH = dtTemp.Rows[N]["JLBDBH"] == DBNull.Value ? "" : dtTemp.Rows[N]["JLBDBH"].ToString(); arrModel[N].JLBDRQ = dtTemp.Rows[N]["JLBDRQ"] == DBNull.Value ? "" : dtTemp.Rows[N]["JLBDRQ"].ToString(); arrModel[N].JLBDYXQZ = dtTemp.Rows[N]["JLBDYXQZ"] == DBNull.Value ? "" : dtTemp.Rows[N]["JLBDYXQZ"].ToString(); arrModel[N].BZ = dtTemp.Rows[N]["BZ"] == DBNull.Value ? "" : dtTemp.Rows[N]["BZ"].ToString(); } dtTemp.Dispose(); return(arrModel); }
/// <summary> /// 得到对象集合 /// </summary> public RESULT_OBD[] GetModelList(string p_strWhere, string p_strOrder, int p_intPageNumber, int p_intPageSize) { int m_intPageNumber = p_intPageNumber; int m_intPageCount = GetPageCount(p_strWhere, p_intPageSize); if ((m_intPageNumber < 1) || (m_intPageNumber == 0)) { m_intPageNumber = 1; } if (m_intPageNumber == -1) { m_intPageNumber = m_intPageCount; } if (m_intPageNumber > m_intPageCount) { m_intPageNumber = m_intPageCount; } string strSql = ""; strSql += "select * from RESULT_OBD"; if (p_strWhere.Trim().Length > 0) { strSql += " where " + p_strWhere; } if (p_strOrder.Trim().Length > 0) { strSql += " order by " + p_strOrder; } DataTable dtTemp = new DataTable(); if (p_intPageSize > 0) { DbHelper.GetTable(Conn, strSql, ref dtTemp, (m_intPageNumber - 1) * p_intPageSize, p_intPageSize); } else { DbHelper.GetTable(Conn, strSql, ref dtTemp); } RESULT_OBD[] arrModel = new RESULT_OBD[dtTemp.Rows.Count]; for (int N = 0; N < dtTemp.Rows.Count; N++) { arrModel[N] = new RESULT_OBD(); arrModel[N].ID = dtTemp.Rows[N]["ID"] == DBNull.Value ? 0 : Convert.ToInt32(dtTemp.Rows[N]["ID"]); arrModel[N].JCLSH = dtTemp.Rows[N]["JCLSH"] == DBNull.Value ? "" : dtTemp.Rows[N]["JCLSH"].ToString(); arrModel[N].VIN = dtTemp.Rows[N]["VIN"] == DBNull.Value ? "" : dtTemp.Rows[N]["VIN"].ToString(); arrModel[N].testdate = dtTemp.Rows[N]["testdate"] == DBNull.Value ? Convert.ToDateTime("1900-01-01") : Convert.ToDateTime(dtTemp.Rows[N]["testdate"]); arrModel[N].isupdated = dtTemp.Rows[N]["isupdated"] == DBNull.Value ? 0 : Convert.ToInt32(dtTemp.Rows[N]["isupdated"]); arrModel[N].ZSD_PD = dtTemp.Rows[N]["ZSD_PD"] == DBNull.Value ? "" : dtTemp.Rows[N]["ZSD_PD"].ToString(); arrModel[N].GZ_PD = dtTemp.Rows[N]["GZ_PD"] == DBNull.Value ? "" : dtTemp.Rows[N]["GZ_PD"].ToString(); arrModel[N].ECU_VIN = dtTemp.Rows[N]["ECU_VIN"] == DBNull.Value ? "" : dtTemp.Rows[N]["ECU_VIN"].ToString(); arrModel[N].ECU_CALID = dtTemp.Rows[N]["ECU_CALID"] == DBNull.Value ? "" : dtTemp.Rows[N]["ECU_CALID"].ToString(); arrModel[N].ECU_CVN = dtTemp.Rows[N]["ECU_CVN"] == DBNull.Value ? "" : dtTemp.Rows[N]["ECU_CVN"].ToString(); arrModel[N].ECU_PD = dtTemp.Rows[N]["ECU_PD"] == DBNull.Value ? "" : dtTemp.Rows[N]["ECU_PD"].ToString(); arrModel[N].TX_PD = dtTemp.Rows[N]["TX_PD"] == DBNull.Value ? "" : dtTemp.Rows[N]["TX_PD"].ToString(); arrModel[N].JX_PD = dtTemp.Rows[N]["JX_PD"] == DBNull.Value ? "" : dtTemp.Rows[N]["JX_PD"].ToString(); arrModel[N].ALL_PD = dtTemp.Rows[N]["ALL_PD"] == DBNull.Value ? "" : dtTemp.Rows[N]["ALL_PD"].ToString(); arrModel[N].FreezeData = dtTemp.Rows[N]["FreezeData"] == DBNull.Value ? "" : dtTemp.Rows[N]["FreezeData"].ToString(); arrModel[N].ECUInfo = dtTemp.Rows[N]["ECUInfo"] == DBNull.Value ? "" : dtTemp.Rows[N]["ECUInfo"].ToString(); arrModel[N].IUPR = dtTemp.Rows[N]["IUPR"] == DBNull.Value ? "" : dtTemp.Rows[N]["IUPR"].ToString(); arrModel[N].SystemCheckState = dtTemp.Rows[N]["SystemCheckState"] == DBNull.Value ? "" : dtTemp.Rows[N]["SystemCheckState"].ToString(); arrModel[N].RTData = dtTemp.Rows[N]["RTData"] == DBNull.Value ? "" : dtTemp.Rows[N]["RTData"].ToString(); arrModel[N].SRTData = dtTemp.Rows[N]["SRTData"] == DBNull.Value ? "" : dtTemp.Rows[N]["SRTData"].ToString(); arrModel[N].DTC = dtTemp.Rows[N]["DTC"] == DBNull.Value ? "" : dtTemp.Rows[N]["DTC"].ToString(); arrModel[N].TX_BHGYY = dtTemp.Rows[N]["TX_BHGYY"] == DBNull.Value ? "" : dtTemp.Rows[N]["TX_BHGYY"].ToString(); arrModel[N].TX_GZDZT = dtTemp.Rows[N]["TX_GZDZT"] == DBNull.Value ? "" : dtTemp.Rows[N]["TX_GZDZT"].ToString(); } dtTemp.Dispose(); return(arrModel); }
/// <summary> /// 得到对象集合 /// </summary> public RESULT_ZYJS[] GetModelList(string p_strWhere, string p_strOrder, int p_intPageNumber, int p_intPageSize) { int m_intPageNumber = p_intPageNumber; int m_intPageCount = GetPageCount(p_strWhere, p_intPageSize); if ((m_intPageNumber < 1) || (m_intPageNumber == 0)) { m_intPageNumber = 1; } if (m_intPageNumber == -1) { m_intPageNumber = m_intPageCount; } if (m_intPageNumber > m_intPageCount) { m_intPageNumber = m_intPageCount; } string strSql = ""; strSql += "select * from RESULT_ZYJS"; if (p_strWhere.Trim().Length > 0) { strSql += " where " + p_strWhere; } if (p_strOrder.Trim().Length > 0) { strSql += " order by " + p_strOrder; } DataTable dtTemp = new DataTable(); if (p_intPageSize > 0) { DbHelper.GetTable(Conn, strSql, ref dtTemp, (m_intPageNumber - 1) * p_intPageSize, p_intPageSize); } else { DbHelper.GetTable(Conn, strSql, ref dtTemp); } RESULT_ZYJS[] arrModel = new RESULT_ZYJS[dtTemp.Rows.Count]; for (int N = 0; N < dtTemp.Rows.Count; N++) { arrModel[N] = new RESULT_ZYJS(); arrModel[N].ID = dtTemp.Rows[N]["ID"] == DBNull.Value ? 0 : Convert.ToInt32(dtTemp.Rows[N]["ID"]); arrModel[N].ZYJSJCCS = dtTemp.Rows[N]["ZYJSJCCS"] == DBNull.Value ? "" : dtTemp.Rows[N]["ZYJSJCCS"].ToString(); arrModel[N].JCLSH = dtTemp.Rows[N]["JCLSH"] == DBNull.Value ? "" : dtTemp.Rows[N]["JCLSH"].ToString(); arrModel[N].ZYJSJG1 = dtTemp.Rows[N]["ZYJSJG1"] == DBNull.Value ? "" : dtTemp.Rows[N]["ZYJSJG1"].ToString(); arrModel[N].ZYJSJG2 = dtTemp.Rows[N]["ZYJSJG2"] == DBNull.Value ? "" : dtTemp.Rows[N]["ZYJSJG2"].ToString(); arrModel[N].ZYJSJG3 = dtTemp.Rows[N]["ZYJSJG3"] == DBNull.Value ? "" : dtTemp.Rows[N]["ZYJSJG3"].ToString(); arrModel[N].ZYJSJG4 = dtTemp.Rows[N]["ZYJSJG4"] == DBNull.Value ? "" : dtTemp.Rows[N]["ZYJSJG4"].ToString(); arrModel[N].ZYJSPJZ = dtTemp.Rows[N]["ZYJSPJZ"] == DBNull.Value ? "" : dtTemp.Rows[N]["ZYJSPJZ"].ToString(); arrModel[N].ZYJSXZ = dtTemp.Rows[N]["ZYJSXZ"] == DBNull.Value ? "" : dtTemp.Rows[N]["ZYJSXZ"].ToString(); arrModel[N].ZYJS_PD = dtTemp.Rows[N]["ZYJS_PD"] == DBNull.Value ? "" : dtTemp.Rows[N]["ZYJS_PD"].ToString(); arrModel[N].ZYJSYW = dtTemp.Rows[N]["ZYJSYW"] == DBNull.Value ? "" : dtTemp.Rows[N]["ZYJSYW"].ToString(); arrModel[N].ZYJSDSZS = dtTemp.Rows[N]["ZYJSDSZS"] == DBNull.Value ? "" : dtTemp.Rows[N]["ZYJSDSZS"].ToString(); arrModel[N].ZYJSWD = dtTemp.Rows[N]["ZYJSWD"] == DBNull.Value ? "" : dtTemp.Rows[N]["ZYJSWD"].ToString(); arrModel[N].ZYJSDQY = dtTemp.Rows[N]["ZYJSDQY"] == DBNull.Value ? "" : dtTemp.Rows[N]["ZYJSDQY"].ToString(); arrModel[N].ZYJSSD = dtTemp.Rows[N]["ZYJSSD"] == DBNull.Value ? "" : dtTemp.Rows[N]["ZYJSSD"].ToString(); arrModel[N].KSSJ = dtTemp.Rows[N]["KSSJ"] == DBNull.Value ? "" : dtTemp.Rows[N]["KSSJ"].ToString(); arrModel[N].JSSJ = dtTemp.Rows[N]["JSSJ"] == DBNull.Value ? "" : dtTemp.Rows[N]["JSSJ"].ToString(); arrModel[N].SFLZS = dtTemp.Rows[N]["SFLZS"] == DBNull.Value ? "" : dtTemp.Rows[N]["SFLZS"].ToString(); arrModel[N].PT_ZYJSJG2 = dtTemp.Rows[N]["PT_ZYJSJG2"] == DBNull.Value ? "" : dtTemp.Rows[N]["PT_ZYJSJG2"].ToString(); arrModel[N].PT_ZYJSJG3 = dtTemp.Rows[N]["PT_ZYJSJG3"] == DBNull.Value ? "" : dtTemp.Rows[N]["PT_ZYJSJG3"].ToString(); arrModel[N].PT_ZYJSJG4 = dtTemp.Rows[N]["PT_ZYJSJG4"] == DBNull.Value ? "" : dtTemp.Rows[N]["PT_ZYJSJG4"].ToString(); arrModel[N].PT_ZYJSPJZ = dtTemp.Rows[N]["PT_ZYJSPJZ"] == DBNull.Value ? "" : dtTemp.Rows[N]["PT_ZYJSPJZ"].ToString(); arrModel[N].PT_ZYJSDSZS = dtTemp.Rows[N]["PT_ZYJSDSZS"] == DBNull.Value ? "" : dtTemp.Rows[N]["PT_ZYJSDSZS"].ToString(); arrModel[N].PT_ZYJS_PD = dtTemp.Rows[N]["PT_ZYJS_PD"] == DBNull.Value ? "" : dtTemp.Rows[N]["PT_ZYJS_PD"].ToString(); arrModel[N].ZYJSZS1 = dtTemp.Rows[N]["ZYJSZS1"] == DBNull.Value ? "" : dtTemp.Rows[N]["ZYJSZS1"].ToString(); arrModel[N].ZYJSZS2 = dtTemp.Rows[N]["ZYJSZS2"] == DBNull.Value ? "" : dtTemp.Rows[N]["ZYJSZS2"].ToString(); arrModel[N].ZYJSZS3 = dtTemp.Rows[N]["ZYJSZS3"] == DBNull.Value ? "" : dtTemp.Rows[N]["ZYJSZS3"].ToString(); arrModel[N].ZYJSZS4 = dtTemp.Rows[N]["ZYJSZS4"] == DBNull.Value ? "" : dtTemp.Rows[N]["ZYJSZS4"].ToString(); } dtTemp.Dispose(); return(arrModel); }