/// <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);
}
private void m_SaveVmas_Click(object sender, EventArgs e)
{
string HCXZ = m_EditHCXZ.Text,
COXZ = m_EditCOXZ.Text,
NOXZ = m_EditNOXZ.Text,
HCNOXZ = m_EditHCNOXZ.Text;
if (HCXZ.IsNumeric() && COXZ.IsNumeric() &&
NOXZ.IsNumeric() && HCNOXZ.IsNumeric())
{
BLL.DEV_STANDARD_VMAS_BLL bll = new BLL.DEV_STANDARD_VMAS_BLL();
if (m_vmas == null)
{
m_vmas = new DEV_STANDARD_VMAS();
m_vmas.SEARCH_CONDITION = m_VehModel.SelectedItem.ToString();
m_vmas.ZXMC = "";
m_vmas.COXZ = COXZ;
m_vmas.HCXZ = HCXZ;
m_vmas.NOXZ = NOXZ;
m_vmas.HC_NOXZ = HCNOXZ;
m_vmas.PDFS = "0";
m_vmas.IS_SHOW = 1;
m_vmas.AREA_NAME = "新国标";
m_vmas.UTYPE = 0;
bll.Insert(m_vmas);
UpdateCostumeModelLimitTable(m_VehModel.SelectedItem.ToString(), "VMAS");
}
else
{
m_vmas.COXZ = COXZ;
m_vmas.HCXZ = HCXZ;
m_vmas.NOXZ = NOXZ;
m_vmas.HC_NOXZ = HCNOXZ;
bll.Update(m_vmas, m_vmas.ID);
}
ResetTextBox();
MessageBox.Show("设置成功");
m_VehModel.ClearSelected();
}
else
{
MessageBox.Show("输入文本必须是纯数字");
}
}
/// <summary>
/// 修改全部数据 SQL
/// </summary>
public string UpdateAllSQL(DEV_STANDARD_VMAS model)
{
string strUpdateSQL = "";
strUpdateSQL += ",SEARCH_CONDITION='" + model.SEARCH_CONDITION.ToString().Replace("'", "''") + "'";
strUpdateSQL += ",ZXMC='" + model.ZXMC.ToString().Replace("'", "''") + "'";
strUpdateSQL += ",COXZ='" + model.COXZ.ToString().Replace("'", "''") + "'";
strUpdateSQL += ",HCXZ='" + model.HCXZ.ToString().Replace("'", "''") + "'";
strUpdateSQL += ",NOXZ='" + model.NOXZ.ToString().Replace("'", "''") + "'";
strUpdateSQL += ",HC_NOXZ='" + model.HC_NOXZ.ToString().Replace("'", "''") + "'";
strUpdateSQL += ",PDFS='" + model.PDFS.ToString().Replace("'", "''") + "'";
strUpdateSQL += ",IS_SHOW=" + model.IS_SHOW + "";
strUpdateSQL += ",AREA_NAME='" + model.AREA_NAME.ToString().Replace("'", "''") + "'";
strUpdateSQL += ",UTYPE=" + model.UTYPE + "";
string strSql = "";
strSql += "update DEV_STANDARD_VMAS set ";
strSql += strUpdateSQL.Substring(1);
return(strSql);
}
/// <summary>
/// 添加一条数据 SQL
/// </summary>
public string InsertSQL(DEV_STANDARD_VMAS model)
{
return(g_DAL.InsertSQL(model));
}
/// <summary>
/// 修改全部数据
/// </summary>
public bool UpdateAll(DEV_STANDARD_VMAS model)
{
return(g_DAL.UpdateAll(model));
}
/// <summary>
/// 修改全部数据 SQL
/// </summary>
public string UpdateAllSQL(DEV_STANDARD_VMAS model)
{
return(g_DAL.UpdateAllSQL(model));
}
/// <summary>
/// 修改一个集合
/// </summary>
public bool UpdateRange(DEV_STANDARD_VMAS model, string p_strWhere)
{
return(g_DAL.UpdateRange(model, p_strWhere));
}
/// <summary>
/// 修改一个集合 SQL
/// </summary>
public string UpdateRangeSQL(DEV_STANDARD_VMAS model, string p_strWhere)
{
return(g_DAL.UpdateRangeSQL(model, p_strWhere));
}
/// <summary>
/// 修改一条数据
/// </summary>
public bool Update(DEV_STANDARD_VMAS model, int intID)
{
return(g_DAL.Update(model, intID));
}
/// <summary>
/// 添加一条数据
/// </summary>
public bool Insert(DEV_STANDARD_VMAS model)
{
return(DbHelper.ExecuteSql(Conn, InsertSQL(model)));
}
private void m_VehModel_SelectedIndexChanged(object sender, EventArgs e)
{
if (m_VehModel.SelectedItems.Count == 0)
{
return;
}
else
{
ResetTextBox();
string model = m_VehModel.SelectedItem.ToString();
for (int i = 0; i < m_relations.Count; i++)
{
if (m_relations[i].MODEL_NAME == model)
{
string key = "SEARCH_CONDITION";
if (m_relations[i].METHOD_NAME.Contains("ASM"))
{
var m_asm = m_db.Find <DEV_STANDARD_ASM>(key, model);
if (m_asm.ID > 0)
{
m_Edit25HC.Text = m_asm.HC5025XZ;
m_Edit25CO.Text = m_asm.CO5025XZ;
m_Edit25NO.Text = m_asm.NO5025XZ;
m_Edit40HC.Text = m_asm.HC2540XZ;
m_Edit40CO.Text = m_asm.CO2540XZ;
m_Edit40NO.Text = m_asm.NO2540XZ;
}
else
{
m_asm = null;
}
}
if (m_relations[i].METHOD_NAME.Contains("VMAS"))
{
//BLL.DEV_STANDARD_VMAS_BLL bllVmas = new BLL.DEV_STANDARD_VMAS_BLL();
//DEV_STANDARD_VMAS[] arrVmas = bllVmas.GetModelList(condition);
m_vmas = m_db.Find <DEV_STANDARD_VMAS>(key, model);
if (m_vmas.ID > 0)
{
m_EditHCXZ.Text = m_vmas.COXZ;
m_EditCOXZ.Text = m_vmas.HCXZ;
m_EditNOXZ.Text = m_vmas.NOXZ;
m_EditHCNOXZ.Text = m_vmas.HC_NOXZ;
}
else
{
m_vmas = null;
}
}
if (m_relations[i].METHOD_NAME.Contains("SDS"))
{
m_sds = m_db.Find <DEV_STANDARD_SDS>(key, model);
if (m_sds.ID > 0)
{
m_EditGDSCO.Text = m_sds.GDSCOXZ;
m_EditGDSHC.Text = m_sds.GDSHCXZ;
m_EditDSCO.Text = m_sds.DSCOXZ;
m_EditDSHC.Text = m_sds.DSHCXZ;
m_EditLXX.Text = m_sds.GLKQXSXX;
m_EditLSX.Text = m_sds.GLKQXSSX;
}
else
{
m_sds = null;
}
}
if (m_relations[i].METHOD_NAME.Contains("LD"))
{
m_ld = m_db.Find <DEV_STANDARD_LD>(key, model);
if (m_ld.ID > 0)
{
m_EditGXSXS.Text = m_ld.GXSXSXZ;
m_EditGLXZ.Text = m_ld.GLXZ;
m_EditZSXZ.Text = m_ld.ZSXZ;
m_EditLDNO.Text = m_ld.NOXZ;
m_EditLGM.Text = m_ld.LGMXZ;
m_EditHSU.Text = m_ld.HSUXZ;
}
else
{
m_ld = null;
}
}
if (m_relations[i].METHOD_NAME.Contains("FA"))
{
m_fa = m_db.Find <DEV_STANDARD_ZYJS>(key, model);
if (m_fa.ID > 0)
{
m_EditFaBTG.Text = m_fa.ZYJSXZ;
m_EditBTGHSU.Text = m_fa.HSUXZ;
}
else
{
m_fa = null;
}
}
}
}
}
}
/// <summary>
/// 修改全部数据
/// </summary>
public bool UpdateAll(DEV_STANDARD_VMAS model)
{
return(DbHelper.ExecuteSql(Conn, UpdateAllSQL(model)));
}
/// <summary>
/// 修改一个集合
/// </summary>
public bool UpdateRange(DEV_STANDARD_VMAS model, string p_strWhere)
{
return(DbHelper.ExecuteSql(Conn, UpdateRangeSQL(model, p_strWhere)));
}
/// <summary>
/// 修改一个集合 SQL
/// </summary>
public string UpdateRangeSQL(DEV_STANDARD_VMAS model, string p_strWhere)
{
string strUpdateSQL = "";
if (model.Changed("SEARCH_CONDITION") == true && model.SEARCH_CONDITION != null)
{
strUpdateSQL += ",SEARCH_CONDITION='" + model.SEARCH_CONDITION.ToString().Replace("'", "''") + "'";
}
if (model.Changed("ZXMC") == true && model.ZXMC != null)
{
strUpdateSQL += ",ZXMC='" + model.ZXMC.ToString().Replace("'", "''") + "'";
}
if (model.Changed("COXZ") == true && model.COXZ != null)
{
strUpdateSQL += ",COXZ='" + model.COXZ.ToString().Replace("'", "''") + "'";
}
if (model.Changed("HCXZ") == true && model.HCXZ != null)
{
strUpdateSQL += ",HCXZ='" + model.HCXZ.ToString().Replace("'", "''") + "'";
}
if (model.Changed("NOXZ") == true && model.NOXZ != null)
{
strUpdateSQL += ",NOXZ='" + model.NOXZ.ToString().Replace("'", "''") + "'";
}
if (model.Changed("HC_NOXZ") == true && model.HC_NOXZ != null)
{
strUpdateSQL += ",HC_NOXZ='" + model.HC_NOXZ.ToString().Replace("'", "''") + "'";
}
if (model.Changed("PDFS") == true && model.PDFS != null)
{
strUpdateSQL += ",PDFS='" + model.PDFS.ToString().Replace("'", "''") + "'";
}
if (model.Changed("IS_SHOW") == true && model.IS_SHOW != null)
{
strUpdateSQL += ",IS_SHOW=" + model.IS_SHOW + "";
}
if (model.Changed("AREA_NAME") == true && model.AREA_NAME != null)
{
strUpdateSQL += ",AREA_NAME='" + model.AREA_NAME.ToString().Replace("'", "''") + "'";
}
if (model.Changed("UTYPE") == true && model.UTYPE != null)
{
strUpdateSQL += ",UTYPE=" + model.UTYPE + "";
}
string strSql = "";
strSql += "update DEV_STANDARD_VMAS set ";
strSql += strUpdateSQL.Substring(1);
strSql += " where " + p_strWhere;
return(strSql);
}
/// <summary>
/// 修改一条数据
/// </summary>
public bool Update(DEV_STANDARD_VMAS model, int intID)
{
return(DbHelper.ExecuteSql(Conn, UpdateSQL(model, intID)));
}
/// <summary>
/// 添加一条数据
/// </summary>
public bool Insert(DEV_STANDARD_VMAS model)
{
return(g_DAL.Insert(model));
}
/// <summary>
/// 得到对象集合
/// </summary>
public DEV_STANDARD_VMAS[] 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_VMAS";
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_VMAS[] arrModel = new DEV_STANDARD_VMAS[dtTemp.Rows.Count];
for (int N = 0; N < dtTemp.Rows.Count; N++)
{
arrModel[N] = new DEV_STANDARD_VMAS();
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].COXZ = dtTemp.Rows[N]["COXZ"] == DBNull.Value ? "" : dtTemp.Rows[N]["COXZ"].ToString();
arrModel[N].HCXZ = dtTemp.Rows[N]["HCXZ"] == DBNull.Value ? "" : dtTemp.Rows[N]["HCXZ"].ToString();
arrModel[N].NOXZ = dtTemp.Rows[N]["NOXZ"] == DBNull.Value ? "" : dtTemp.Rows[N]["NOXZ"].ToString();
arrModel[N].HC_NOXZ = dtTemp.Rows[N]["HC_NOXZ"] == DBNull.Value ? "" : dtTemp.Rows[N]["HC_NOXZ"].ToString();
arrModel[N].PDFS = dtTemp.Rows[N]["PDFS"] == DBNull.Value ? "" : dtTemp.Rows[N]["PDFS"].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>
/// 修改一条数据 SQL
/// </summary>
public string UpdateSQL(DEV_STANDARD_VMAS model, int intID)
{
return(g_DAL.UpdateSQL(model, intID));
}
/// <summary>
/// 添加一条数据 SQL
/// </summary>
public string InsertSQL(DEV_STANDARD_VMAS model)
{
string strFieldSQL = "";
string strValueSQL = "";
if (model.Changed("SEARCH_CONDITION") == true && model.SEARCH_CONDITION != null)
{
strFieldSQL += ",SEARCH_CONDITION";
strValueSQL += ",'" + model.SEARCH_CONDITION.ToString().Replace("'", "''") + "'";
}
if (model.Changed("ZXMC") == true && model.ZXMC != null)
{
strFieldSQL += ",ZXMC";
strValueSQL += ",'" + model.ZXMC.ToString().Replace("'", "''") + "'";
}
if (model.Changed("COXZ") == true && model.COXZ != null)
{
strFieldSQL += ",COXZ";
strValueSQL += ",'" + model.COXZ.ToString().Replace("'", "''") + "'";
}
if (model.Changed("HCXZ") == true && model.HCXZ != null)
{
strFieldSQL += ",HCXZ";
strValueSQL += ",'" + model.HCXZ.ToString().Replace("'", "''") + "'";
}
if (model.Changed("NOXZ") == true && model.NOXZ != null)
{
strFieldSQL += ",NOXZ";
strValueSQL += ",'" + model.NOXZ.ToString().Replace("'", "''") + "'";
}
if (model.Changed("HC_NOXZ") == true && model.HC_NOXZ != null)
{
strFieldSQL += ",HC_NOXZ";
strValueSQL += ",'" + model.HC_NOXZ.ToString().Replace("'", "''") + "'";
}
if (model.Changed("PDFS") == true && model.PDFS != null)
{
strFieldSQL += ",PDFS";
strValueSQL += ",'" + model.PDFS.ToString().Replace("'", "''") + "'";
}
if (model.Changed("IS_SHOW") == true && model.IS_SHOW != null)
{
strFieldSQL += ",IS_SHOW";
strValueSQL += "," + model.IS_SHOW + "";
}
if (model.Changed("AREA_NAME") == true && model.AREA_NAME != null)
{
strFieldSQL += ",AREA_NAME";
strValueSQL += ",'" + model.AREA_NAME.ToString().Replace("'", "''") + "'";
}
if (model.Changed("UTYPE") == true && model.UTYPE != null)
{
strFieldSQL += ",UTYPE";
strValueSQL += "," + model.UTYPE + "";
}
string strSql = "";
strSql += "insert into DEV_STANDARD_VMAS";
strSql += "(";
strSql += strFieldSQL.Substring(1);
strSql += ")";
strSql += " values";
strSql += "(";
strSql += strValueSQL.Substring(1);
strSql += ")";
return(strSql);
}
