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