/// <summary>
/// 修改全部数据 SQL
/// </summary>
public string UpdateAllSQL(DEV_STANDARD_ASM model)
{
string strUpdateSQL = "";
strUpdateSQL += ",SEARCH_CONDITION='" + model.SEARCH_CONDITION.ToString().Replace("'", "''") + "'";
strUpdateSQL += ",ZXMC='" + model.ZXMC.ToString().Replace("'", "''") + "'";
strUpdateSQL += ",HC5025XZ='" + model.HC5025XZ.ToString().Replace("'", "''") + "'";
strUpdateSQL += ",CO5025XZ='" + model.CO5025XZ.ToString().Replace("'", "''") + "'";
strUpdateSQL += ",NO5025XZ='" + model.NO5025XZ.ToString().Replace("'", "''") + "'";
strUpdateSQL += ",HC2540XZ='" + model.HC2540XZ.ToString().Replace("'", "''") + "'";
strUpdateSQL += ",CO2540XZ='" + model.CO2540XZ.ToString().Replace("'", "''") + "'";
strUpdateSQL += ",NO2540XZ='" + model.NO2540XZ.ToString().Replace("'", "''") + "'";
strUpdateSQL += ",DSHCXZ='" + model.DSHCXZ.ToString().Replace("'", "''") + "'";
strUpdateSQL += ",DSCOXZ='" + model.DSCOXZ.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_ASM set ";
strSql += strUpdateSQL.Substring(1);
return(strSql);
}
private void m_SaveASM_Click(object sender, EventArgs e)
{
string hc5025 = m_Edit25HC.Text,
co5025 = m_Edit25CO.Text,
no5025 = m_Edit25NO.Text,
hc2540 = m_Edit40HC.Text,
co2540 = m_Edit40CO.Text,
no2540 = m_Edit40NO.Text;
if (hc5025.IsNumeric() && co5025.IsNumeric() && no5025.IsNumeric() &&
hc2540.IsNumeric() && co2540.IsNumeric() && no2540.IsNumeric())
{
BLL.DEV_STANDARD_ASM_BLL bll = new BLL.DEV_STANDARD_ASM_BLL();
if (m_asm == null)
{
m_asm = new DEV_STANDARD_ASM();
m_asm.SEARCH_CONDITION = m_VehModel.SelectedItem.ToString();
m_asm.ZXMC = "A2";
m_asm.HC5025XZ = m_Edit25HC.Text;
m_asm.CO5025XZ = m_Edit25CO.Text;
m_asm.NO5025XZ = m_Edit25NO.Text;
m_asm.HC2540XZ = m_Edit40HC.Text;
m_asm.CO2540XZ = m_Edit40CO.Text;
m_asm.NO2540XZ = m_Edit40NO.Text;
m_asm.IS_SHOW = 1;
m_asm.AREA_NAME = "新国标";
m_asm.UTYPE = 0;
bll.Insert(m_asm);
UpdateCostumeModelLimitTable(m_VehModel.SelectedItem.ToString(), "ASM");
}
else
{
m_asm.HC5025XZ = m_Edit25HC.Text;
m_asm.CO5025XZ = m_Edit25CO.Text;
m_asm.NO5025XZ = m_Edit25NO.Text;
m_asm.HC2540XZ = m_Edit40HC.Text;
m_asm.CO2540XZ = m_Edit40CO.Text;
m_asm.NO2540XZ = m_Edit40NO.Text;
bll.Update(m_asm, m_asm.ID);
}
ResetTextBox();
MessageBox.Show("设置成功");
m_VehModel.ClearSelected();
}
else
{
MessageBox.Show("输入文本必须是纯数字");
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public DEV_STANDARD_ASM GetModel(int intID)
{
string strSql = "";
strSql += "select * from DEV_STANDARD_ASM";
strSql += " where ";
strSql += " ID=" + intID + "";
DataTable dtTemp = new DataTable();
DbHelper.GetTable(Conn, strSql, ref dtTemp);
DEV_STANDARD_ASM model = new DEV_STANDARD_ASM();
if (dtTemp.Rows.Count > 0)
{
model = new DEV_STANDARD_ASM();
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.HC5025XZ = dtTemp.Rows[0]["HC5025XZ"] == DBNull.Value ? "" : dtTemp.Rows[0]["HC5025XZ"].ToString();
model.CO5025XZ = dtTemp.Rows[0]["CO5025XZ"] == DBNull.Value ? "" : dtTemp.Rows[0]["CO5025XZ"].ToString();
model.NO5025XZ = dtTemp.Rows[0]["NO5025XZ"] == DBNull.Value ? "" : dtTemp.Rows[0]["NO5025XZ"].ToString();
model.HC2540XZ = dtTemp.Rows[0]["HC2540XZ"] == DBNull.Value ? "" : dtTemp.Rows[0]["HC2540XZ"].ToString();
model.CO2540XZ = dtTemp.Rows[0]["CO2540XZ"] == DBNull.Value ? "" : dtTemp.Rows[0]["CO2540XZ"].ToString();
model.NO2540XZ = dtTemp.Rows[0]["NO2540XZ"] == DBNull.Value ? "" : dtTemp.Rows[0]["NO2540XZ"].ToString();
model.DSHCXZ = dtTemp.Rows[0]["DSHCXZ"] == DBNull.Value ? "" : dtTemp.Rows[0]["DSHCXZ"].ToString();
model.DSCOXZ = dtTemp.Rows[0]["DSCOXZ"] == DBNull.Value ? "" : dtTemp.Rows[0]["DSCOXZ"].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>
/// 修改一条数据 SQL
/// </summary>
public string UpdateSQL(DEV_STANDARD_ASM model, int intID)
{
return(g_DAL.UpdateSQL(model, intID));
}
/// <summary>
/// 添加一条数据 SQL
/// </summary>
public string InsertSQL(DEV_STANDARD_ASM model)
{
return(g_DAL.InsertSQL(model));
}
/// <summary>
/// 添加一条数据
/// </summary>
public bool Insert(DEV_STANDARD_ASM model)
{
return(g_DAL.Insert(model));
}
/// <summary>
/// 修改全部数据 SQL
/// </summary>
public string UpdateAllSQL(DEV_STANDARD_ASM model)
{
return(g_DAL.UpdateAllSQL(model));
}
/// <summary>
/// 修改全部数据
/// </summary>
public bool UpdateAll(DEV_STANDARD_ASM model)
{
return(g_DAL.UpdateAll(model));
}
/// <summary>
/// 修改一个集合 SQL
/// </summary>
public string UpdateRangeSQL(DEV_STANDARD_ASM model, string p_strWhere)
{
return(g_DAL.UpdateRangeSQL(model, p_strWhere));
}
/// <summary>
/// 修改一个集合
/// </summary>
public bool UpdateRange(DEV_STANDARD_ASM model, string p_strWhere)
{
return(g_DAL.UpdateRange(model, p_strWhere));
}
/// <summary>
/// 得到对象集合
/// </summary>
public DEV_STANDARD_ASM[] 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_ASM";
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_ASM[] arrModel = new DEV_STANDARD_ASM[dtTemp.Rows.Count];
for (int N = 0; N < dtTemp.Rows.Count; N++)
{
arrModel[N] = new DEV_STANDARD_ASM();
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].HC5025XZ = dtTemp.Rows[N]["HC5025XZ"] == DBNull.Value ? "" : dtTemp.Rows[N]["HC5025XZ"].ToString();
arrModel[N].CO5025XZ = dtTemp.Rows[N]["CO5025XZ"] == DBNull.Value ? "" : dtTemp.Rows[N]["CO5025XZ"].ToString();
arrModel[N].NO5025XZ = dtTemp.Rows[N]["NO5025XZ"] == DBNull.Value ? "" : dtTemp.Rows[N]["NO5025XZ"].ToString();
arrModel[N].HC2540XZ = dtTemp.Rows[N]["HC2540XZ"] == DBNull.Value ? "" : dtTemp.Rows[N]["HC2540XZ"].ToString();
arrModel[N].CO2540XZ = dtTemp.Rows[N]["CO2540XZ"] == DBNull.Value ? "" : dtTemp.Rows[N]["CO2540XZ"].ToString();
arrModel[N].NO2540XZ = dtTemp.Rows[N]["NO2540XZ"] == DBNull.Value ? "" : dtTemp.Rows[N]["NO2540XZ"].ToString();
arrModel[N].DSHCXZ = dtTemp.Rows[N]["DSHCXZ"] == DBNull.Value ? "" : dtTemp.Rows[N]["DSHCXZ"].ToString();
arrModel[N].DSCOXZ = dtTemp.Rows[N]["DSCOXZ"] == DBNull.Value ? "" : dtTemp.Rows[N]["DSCOXZ"].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 bool Update(DEV_STANDARD_ASM model, int intID)
{
return(g_DAL.Update(model, intID));
}
/// <summary>
/// 修改全部数据
/// </summary>
public bool UpdateAll(DEV_STANDARD_ASM model)
{
return(DbHelper.ExecuteSql(Conn, UpdateAllSQL(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>
/// 添加一条数据 SQL
/// </summary>
public string InsertSQL(DEV_STANDARD_ASM 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("HC5025XZ") == true && model.HC5025XZ != null)
{
strFieldSQL += ",HC5025XZ";
strValueSQL += ",'" + model.HC5025XZ.ToString().Replace("'", "''") + "'";
}
if (model.Changed("CO5025XZ") == true && model.CO5025XZ != null)
{
strFieldSQL += ",CO5025XZ";
strValueSQL += ",'" + model.CO5025XZ.ToString().Replace("'", "''") + "'";
}
if (model.Changed("NO5025XZ") == true && model.NO5025XZ != null)
{
strFieldSQL += ",NO5025XZ";
strValueSQL += ",'" + model.NO5025XZ.ToString().Replace("'", "''") + "'";
}
if (model.Changed("HC2540XZ") == true && model.HC2540XZ != null)
{
strFieldSQL += ",HC2540XZ";
strValueSQL += ",'" + model.HC2540XZ.ToString().Replace("'", "''") + "'";
}
if (model.Changed("CO2540XZ") == true && model.CO2540XZ != null)
{
strFieldSQL += ",CO2540XZ";
strValueSQL += ",'" + model.CO2540XZ.ToString().Replace("'", "''") + "'";
}
if (model.Changed("NO2540XZ") == true && model.NO2540XZ != null)
{
strFieldSQL += ",NO2540XZ";
strValueSQL += ",'" + model.NO2540XZ.ToString().Replace("'", "''") + "'";
}
if (model.Changed("DSHCXZ") == true && model.DSHCXZ != null)
{
strFieldSQL += ",DSHCXZ";
strValueSQL += ",'" + model.DSHCXZ.ToString().Replace("'", "''") + "'";
}
if (model.Changed("DSCOXZ") == true && model.DSCOXZ != null)
{
strFieldSQL += ",DSCOXZ";
strValueSQL += ",'" + model.DSCOXZ.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_ASM";
strSql += "(";
strSql += strFieldSQL.Substring(1);
strSql += ")";
strSql += " values";
strSql += "(";
strSql += strValueSQL.Substring(1);
strSql += ")";
return(strSql);
}
/// <summary>
/// 修改一个集合
/// </summary>
public bool UpdateRange(DEV_STANDARD_ASM model, string p_strWhere)
{
return(DbHelper.ExecuteSql(Conn, UpdateRangeSQL(model, p_strWhere)));
}
/// <summary>
/// 修改一个集合 SQL
/// </summary>
public string UpdateRangeSQL(DEV_STANDARD_ASM 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("HC5025XZ") == true && model.HC5025XZ != null)
{
strUpdateSQL += ",HC5025XZ='" + model.HC5025XZ.ToString().Replace("'", "''") + "'";
}
if (model.Changed("CO5025XZ") == true && model.CO5025XZ != null)
{
strUpdateSQL += ",CO5025XZ='" + model.CO5025XZ.ToString().Replace("'", "''") + "'";
}
if (model.Changed("NO5025XZ") == true && model.NO5025XZ != null)
{
strUpdateSQL += ",NO5025XZ='" + model.NO5025XZ.ToString().Replace("'", "''") + "'";
}
if (model.Changed("HC2540XZ") == true && model.HC2540XZ != null)
{
strUpdateSQL += ",HC2540XZ='" + model.HC2540XZ.ToString().Replace("'", "''") + "'";
}
if (model.Changed("CO2540XZ") == true && model.CO2540XZ != null)
{
strUpdateSQL += ",CO2540XZ='" + model.CO2540XZ.ToString().Replace("'", "''") + "'";
}
if (model.Changed("NO2540XZ") == true && model.NO2540XZ != null)
{
strUpdateSQL += ",NO2540XZ='" + model.NO2540XZ.ToString().Replace("'", "''") + "'";
}
if (model.Changed("DSHCXZ") == true && model.DSHCXZ != null)
{
strUpdateSQL += ",DSHCXZ='" + model.DSHCXZ.ToString().Replace("'", "''") + "'";
}
if (model.Changed("DSCOXZ") == true && model.DSCOXZ != null)
{
strUpdateSQL += ",DSCOXZ='" + model.DSCOXZ.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_ASM set ";
strSql += strUpdateSQL.Substring(1);
strSql += " where " + p_strWhere;
return(strSql);
}
/// <summary>
/// 修改一条数据
/// </summary>
public bool Update(DEV_STANDARD_ASM model, int intID)
{
return(DbHelper.ExecuteSql(Conn, UpdateSQL(model, intID)));
}
/// <summary>
/// 添加一条数据
/// </summary>
public bool Insert(DEV_STANDARD_ASM model)
{
return(DbHelper.ExecuteSql(Conn, InsertSQL(model)));
}