private void m_SaveLD_Click(object sender, EventArgs e)
{
string GXSXS = m_EditGXSXS.Text,
GLXZ = m_EditGLXZ.Text,
ZSXZ = m_EditZSXZ.Text,
NOXZ = m_EditLDNO.Text,
LGM = m_EditLGM.Text,
HSU = m_EditHSU.Text;
if (GXSXS.IsNumeric() && GLXZ.IsNumeric() && ZSXZ.IsNumeric() &&
NOXZ.IsNumeric() && LGM.IsNumeric() && HSU.IsNumeric())
{
BLL.DEV_STANDARD_LD_BLL bll = new BLL.DEV_STANDARD_LD_BLL();
if (m_ld == null)
{
m_ld = new DEV_STANDARD_LD();
m_ld.SEARCH_CONDITION = m_VehModel.SelectedItem.ToString();
m_ld.ZXMC = "加载减速";
m_ld.GXSXSXZ = GXSXS;
m_ld.GLXZ = GLXZ;
m_ld.ZSXZ = ZSXZ;
m_ld.IS_SHOW = 1;
m_ld.AREA_NAME = "新国标";
m_ld.UTYPE = 0;
m_ld.NOXZ = NOXZ;
m_ld.LGMXZ = LGM;
m_ld.HSUXZ = HSU;
bll.Insert(m_ld);
UpdateCostumeModelLimitTable(m_VehModel.SelectedItem.ToString(), "LD");
}
else
{
m_ld.GXSXSXZ = GXSXS;
m_ld.GLXZ = GLXZ;
m_ld.ZSXZ = ZSXZ;
m_ld.NOXZ = NOXZ;
m_ld.LGMXZ = LGM;
m_ld.HSUXZ = HSU;
bll.Update(m_ld, m_ld.ID);
ResetTextBox();
}
ResetTextBox();
MessageBox.Show("设置成功");
m_VehModel.ClearSelected();
}
else
{
MessageBox.Show("输入文本必须是纯数字");
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public DEV_STANDARD_LD GetModel(int intID)
{
string strSql = "";
strSql += "select * from DEV_STANDARD_LD";
strSql += " where ";
strSql += " ID=" + intID + "";
DataTable dtTemp = new DataTable();
DbHelper.GetTable(Conn, strSql, ref dtTemp);
DEV_STANDARD_LD model = new DEV_STANDARD_LD();
if (dtTemp.Rows.Count > 0)
{
model = new DEV_STANDARD_LD();
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.GXSXSXZ = dtTemp.Rows[0]["GXSXSXZ"] == DBNull.Value ? "" : dtTemp.Rows[0]["GXSXSXZ"].ToString();
model.GLXZ = dtTemp.Rows[0]["GLXZ"] == DBNull.Value ? "" : dtTemp.Rows[0]["GLXZ"].ToString();
model.ZSXZ = dtTemp.Rows[0]["ZSXZ"] == DBNull.Value ? "" : dtTemp.Rows[0]["ZSXZ"].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"]);
model.NOXZ = dtTemp.Rows[0]["NOXZ"] == DBNull.Value ? "" : dtTemp.Rows[0]["NOXZ"].ToString();
model.LGMXZ = dtTemp.Rows[0]["LGMXZ"] == DBNull.Value ? "" : dtTemp.Rows[0]["LGMXZ"].ToString();
model.HSUXZ = dtTemp.Rows[0]["HSUXZ"] == DBNull.Value ? "" : dtTemp.Rows[0]["HSUXZ"].ToString();
}
dtTemp.Dispose();
return(model);
}
/// <summary>
/// 修改全部数据 SQL
/// </summary>
public string UpdateAllSQL(DEV_STANDARD_LD model)
{
string strUpdateSQL = "";
strUpdateSQL += ",SEARCH_CONDITION='" + model.SEARCH_CONDITION.ToString().Replace("'", "''") + "'";
strUpdateSQL += ",ZXMC='" + model.ZXMC.ToString().Replace("'", "''") + "'";
strUpdateSQL += ",GXSXSXZ='" + model.GXSXSXZ.ToString().Replace("'", "''") + "'";
strUpdateSQL += ",GLXZ='" + model.GLXZ.ToString().Replace("'", "''") + "'";
strUpdateSQL += ",ZSXZ='" + model.ZSXZ.ToString().Replace("'", "''") + "'";
strUpdateSQL += ",IS_SHOW=" + model.IS_SHOW + "";
strUpdateSQL += ",AREA_NAME='" + model.AREA_NAME.ToString().Replace("'", "''") + "'";
strUpdateSQL += ",UTYPE=" + model.UTYPE + "";
strUpdateSQL += ",NOXZ='" + model.NOXZ.ToString().Replace("'", "''") + "'";
strUpdateSQL += ",LGMXZ='" + model.LGMXZ.ToString().Replace("'", "''") + "'";
strUpdateSQL += ",HSUXZ='" + model.HSUXZ.ToString().Replace("'", "''") + "'";
string strSql = "";
strSql += "update DEV_STANDARD_LD set ";
strSql += strUpdateSQL.Substring(1);
return(strSql);
}
/// <summary>
/// 添加一条数据 SQL
/// </summary>
public string InsertSQL(DEV_STANDARD_LD model)
{
return(g_DAL.InsertSQL(model));
}
/// <summary>
/// 修改全部数据
/// </summary>
public bool UpdateAll(DEV_STANDARD_LD model)
{
return(g_DAL.UpdateAll(model));
}
/// <summary>
/// 修改全部数据 SQL
/// </summary>
public string UpdateAllSQL(DEV_STANDARD_LD model)
{
return(g_DAL.UpdateAllSQL(model));
}
/// <summary>
/// 修改一个集合
/// </summary>
public bool UpdateRange(DEV_STANDARD_LD model, string p_strWhere)
{
return(g_DAL.UpdateRange(model, p_strWhere));
}
/// <summary>
/// 修改一个集合 SQL
/// </summary>
public string UpdateRangeSQL(DEV_STANDARD_LD model, string p_strWhere)
{
return(g_DAL.UpdateRangeSQL(model, p_strWhere));
}
/// <summary>
/// 添加一条数据
/// </summary>
public bool Insert(DEV_STANDARD_LD model)
{
return(DbHelper.ExecuteSql(Conn, InsertSQL(model)));
}
/// <summary>
/// 修改全部数据
/// </summary>
public bool UpdateAll(DEV_STANDARD_LD model)
{
return(DbHelper.ExecuteSql(Conn, UpdateAllSQL(model)));
}
/// <summary>
/// 修改一个集合
/// </summary>
public bool UpdateRange(DEV_STANDARD_LD model, string p_strWhere)
{
return(DbHelper.ExecuteSql(Conn, UpdateRangeSQL(model, p_strWhere)));
}
/// <summary>
/// 修改一个集合 SQL
/// </summary>
public string UpdateRangeSQL(DEV_STANDARD_LD 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("GXSXSXZ") == true && model.GXSXSXZ != null)
{
strUpdateSQL += ",GXSXSXZ='" + model.GXSXSXZ.ToString().Replace("'", "''") + "'";
}
if (model.Changed("GLXZ") == true && model.GLXZ != null)
{
strUpdateSQL += ",GLXZ='" + model.GLXZ.ToString().Replace("'", "''") + "'";
}
if (model.Changed("ZSXZ") == true && model.ZSXZ != null)
{
strUpdateSQL += ",ZSXZ='" + model.ZSXZ.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 + "";
}
if (model.Changed("NOXZ") == true && model.NOXZ != null)
{
strUpdateSQL += ",NOXZ='" + model.NOXZ.ToString().Replace("'", "''") + "'";
}
if (model.Changed("LGMXZ") == true && model.LGMXZ != null)
{
strUpdateSQL += ",LGMXZ='" + model.LGMXZ.ToString().Replace("'", "''") + "'";
}
if (model.Changed("HSUXZ") == true && model.HSUXZ != null)
{
strUpdateSQL += ",HSUXZ='" + model.HSUXZ.ToString().Replace("'", "''") + "'";
}
string strSql = "";
strSql += "update DEV_STANDARD_LD set ";
strSql += strUpdateSQL.Substring(1);
strSql += " where " + p_strWhere;
return(strSql);
}
/// <summary>
/// 修改一条数据
/// </summary>
public bool Update(DEV_STANDARD_LD model, int intID)
{
return(DbHelper.ExecuteSql(Conn, UpdateSQL(model, intID)));
}
/// <summary>
/// 添加一条数据
/// </summary>
public bool Insert(DEV_STANDARD_LD model)
{
return(g_DAL.Insert(model));
}
/// <summary>
/// 得到对象集合
/// </summary>
public DEV_STANDARD_LD[] 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_LD";
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_LD[] arrModel = new DEV_STANDARD_LD[dtTemp.Rows.Count];
for (int N = 0; N < dtTemp.Rows.Count; N++)
{
arrModel[N] = new DEV_STANDARD_LD();
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].GXSXSXZ = dtTemp.Rows[N]["GXSXSXZ"] == DBNull.Value ? "" : dtTemp.Rows[N]["GXSXSXZ"].ToString();
arrModel[N].GLXZ = dtTemp.Rows[N]["GLXZ"] == DBNull.Value ? "" : dtTemp.Rows[N]["GLXZ"].ToString();
arrModel[N].ZSXZ = dtTemp.Rows[N]["ZSXZ"] == DBNull.Value ? "" : dtTemp.Rows[N]["ZSXZ"].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"]);
arrModel[N].NOXZ = dtTemp.Rows[N]["NOXZ"] == DBNull.Value ? "" : dtTemp.Rows[N]["NOXZ"].ToString();
arrModel[N].LGMXZ = dtTemp.Rows[N]["LGMXZ"] == DBNull.Value ? "" : dtTemp.Rows[N]["LGMXZ"].ToString();
arrModel[N].HSUXZ = dtTemp.Rows[N]["HSUXZ"] == DBNull.Value ? "" : dtTemp.Rows[N]["HSUXZ"].ToString();
}
dtTemp.Dispose();
return(arrModel);
}
/// <summary>
/// 修改一条数据 SQL
/// </summary>
public string UpdateSQL(DEV_STANDARD_LD model, int intID)
{
return(g_DAL.UpdateSQL(model, intID));
}
/// <summary>
/// 修改一条数据
/// </summary>
public bool Update(DEV_STANDARD_LD model, int intID)
{
return(g_DAL.Update(model, intID));
}
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_LD 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("GXSXSXZ") == true && model.GXSXSXZ != null)
{
strFieldSQL += ",GXSXSXZ";
strValueSQL += ",'" + model.GXSXSXZ.ToString().Replace("'", "''") + "'";
}
if (model.Changed("GLXZ") == true && model.GLXZ != null)
{
strFieldSQL += ",GLXZ";
strValueSQL += ",'" + model.GLXZ.ToString().Replace("'", "''") + "'";
}
if (model.Changed("ZSXZ") == true && model.ZSXZ != null)
{
strFieldSQL += ",ZSXZ";
strValueSQL += ",'" + model.ZSXZ.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 + "";
}
if (model.Changed("NOXZ") == true && model.NOXZ != null)
{
strFieldSQL += ",NOXZ";
strValueSQL += ",'" + model.NOXZ.ToString().Replace("'", "''") + "'";
}
if (model.Changed("LGMXZ") == true && model.LGMXZ != null)
{
strFieldSQL += ",LGMXZ";
strValueSQL += ",'" + model.LGMXZ.ToString().Replace("'", "''") + "'";
}
if (model.Changed("HSUXZ") == true && model.HSUXZ != null)
{
strFieldSQL += ",HSUXZ";
strValueSQL += ",'" + model.HSUXZ.ToString().Replace("'", "''") + "'";
}
string strSql = "";
strSql += "insert into DEV_STANDARD_LD";
strSql += "(";
strSql += strFieldSQL.Substring(1);
strSql += ")";
strSql += " values";
strSql += "(";
strSql += strValueSQL.Substring(1);
strSql += ")";
return(strSql);
}
