private void m_SaveSds_Click(object sender, EventArgs e) { string GDSCO = m_EditGDSCO.Text, GDSHC = m_EditGDSHC.Text, DSCO = m_EditDSCO.Text, DSHC = m_EditDSHC.Text, MIN_LAMBDA = m_EditLXX.Text, MAX_LAMBDA = m_EditLSX.Text; if (GDSCO.IsNumeric() && GDSHC.IsNumeric() && DSCO.IsNumeric() && DSHC.IsNumeric() && MIN_LAMBDA.IsNumeric() && MAX_LAMBDA.IsNumeric()) { BLL.DEV_STANDARD_SDS_BLL bll = new BLL.DEV_STANDARD_SDS_BLL(); if (m_sds == null) { m_sds = new DEV_STANDARD_SDS(); m_sds.SEARCH_CONDITION = m_VehModel.SelectedItem.ToString(); m_sds.ZXMC = "双怠速法"; m_sds.GDSCOXZ = GDSCO; m_sds.GDSHCXZ = GDSHC; m_sds.DSCOXZ = DSCO; m_sds.DSHCXZ = DSHC; m_sds.GLKQXSSX = MAX_LAMBDA; m_sds.GLKQXSXX = MIN_LAMBDA; m_sds.IS_SHOW = 1; m_sds.AREA_NAME = "新国标"; m_sds.UTYPE = 0; bll.Insert(m_sds); UpdateCostumeModelLimitTable(m_VehModel.SelectedItem.ToString(), "SDS"); } else { m_sds.GDSCOXZ = GDSCO; m_sds.GDSHCXZ = GDSHC; m_sds.DSCOXZ = DSCO; m_sds.DSHCXZ = DSHC; bll.Update(m_sds, m_sds.ID); } ResetTextBox(); MessageBox.Show("设置成功"); m_VehModel.ClearSelected(); } else { MessageBox.Show("输入文本必须是纯数字"); } }
/// <summary> /// 得到一个对象实体 /// </summary> public DEV_STANDARD_SDS GetModel(int intID) { string strSql = ""; strSql += "select * from DEV_STANDARD_SDS"; strSql += " where "; strSql += " ID=" + intID + ""; DataTable dtTemp = new DataTable(); DbHelper.GetTable(Conn, strSql, ref dtTemp); DEV_STANDARD_SDS model = new DEV_STANDARD_SDS(); if (dtTemp.Rows.Count > 0) { model = new DEV_STANDARD_SDS(); 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.GDSCOXZ = dtTemp.Rows[0]["GDSCOXZ"] == DBNull.Value ? "" : dtTemp.Rows[0]["GDSCOXZ"].ToString(); model.GDSHCXZ = dtTemp.Rows[0]["GDSHCXZ"] == DBNull.Value ? "" : dtTemp.Rows[0]["GDSHCXZ"].ToString(); model.DSCOXZ = dtTemp.Rows[0]["DSCOXZ"] == DBNull.Value ? "" : dtTemp.Rows[0]["DSCOXZ"].ToString(); model.DSHCXZ = dtTemp.Rows[0]["DSHCXZ"] == DBNull.Value ? "" : dtTemp.Rows[0]["DSHCXZ"].ToString(); model.GLKQXSSX = dtTemp.Rows[0]["GLKQXSSX"] == DBNull.Value ? "" : dtTemp.Rows[0]["GLKQXSSX"].ToString(); model.GLKQXSXX = dtTemp.Rows[0]["GLKQXSXX"] == DBNull.Value ? "" : dtTemp.Rows[0]["GLKQXSXX"].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 UpdateAllSQL(DEV_STANDARD_SDS model) { string strUpdateSQL = ""; strUpdateSQL += ",SEARCH_CONDITION='" + model.SEARCH_CONDITION.ToString().Replace("'", "''") + "'"; strUpdateSQL += ",ZXMC='" + model.ZXMC.ToString().Replace("'", "''") + "'"; strUpdateSQL += ",GDSCOXZ='" + model.GDSCOXZ.ToString().Replace("'", "''") + "'"; strUpdateSQL += ",GDSHCXZ='" + model.GDSHCXZ.ToString().Replace("'", "''") + "'"; strUpdateSQL += ",DSCOXZ='" + model.DSCOXZ.ToString().Replace("'", "''") + "'"; strUpdateSQL += ",DSHCXZ='" + model.DSHCXZ.ToString().Replace("'", "''") + "'"; strUpdateSQL += ",GLKQXSSX='" + model.GLKQXSSX.ToString().Replace("'", "''") + "'"; strUpdateSQL += ",GLKQXSXX='" + model.GLKQXSXX.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_SDS set "; strSql += strUpdateSQL.Substring(1); return(strSql); }
/// <summary> /// 添加一条数据 SQL /// </summary> public string InsertSQL(DEV_STANDARD_SDS model) { return(g_DAL.InsertSQL(model)); }
/// <summary> /// 修改全部数据 /// </summary> public bool UpdateAll(DEV_STANDARD_SDS model) { return(g_DAL.UpdateAll(model)); }
/// <summary> /// 修改全部数据 SQL /// </summary> public string UpdateAllSQL(DEV_STANDARD_SDS model) { return(g_DAL.UpdateAllSQL(model)); }
/// <summary> /// 修改一个集合 /// </summary> public bool UpdateRange(DEV_STANDARD_SDS model, string p_strWhere) { return(g_DAL.UpdateRange(model, p_strWhere)); }
/// <summary> /// 修改一个集合 SQL /// </summary> public string UpdateRangeSQL(DEV_STANDARD_SDS model, string p_strWhere) { return(g_DAL.UpdateRangeSQL(model, p_strWhere)); }
/// <summary> /// 修改一条数据 /// </summary> public bool Update(DEV_STANDARD_SDS model, int intID) { return(g_DAL.Update(model, intID)); }
/// <summary> /// 添加一条数据 /// </summary> public bool Insert(DEV_STANDARD_SDS 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_SDS model) { return(DbHelper.ExecuteSql(Conn, UpdateAllSQL(model))); }
/// <summary> /// 修改一个集合 /// </summary> public bool UpdateRange(DEV_STANDARD_SDS model, string p_strWhere) { return(DbHelper.ExecuteSql(Conn, UpdateRangeSQL(model, p_strWhere))); }
/// <summary> /// 修改一个集合 SQL /// </summary> public string UpdateRangeSQL(DEV_STANDARD_SDS 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("GDSCOXZ") == true && model.GDSCOXZ != null) { strUpdateSQL += ",GDSCOXZ='" + model.GDSCOXZ.ToString().Replace("'", "''") + "'"; } if (model.Changed("GDSHCXZ") == true && model.GDSHCXZ != null) { strUpdateSQL += ",GDSHCXZ='" + model.GDSHCXZ.ToString().Replace("'", "''") + "'"; } if (model.Changed("DSCOXZ") == true && model.DSCOXZ != null) { strUpdateSQL += ",DSCOXZ='" + model.DSCOXZ.ToString().Replace("'", "''") + "'"; } if (model.Changed("DSHCXZ") == true && model.DSHCXZ != null) { strUpdateSQL += ",DSHCXZ='" + model.DSHCXZ.ToString().Replace("'", "''") + "'"; } if (model.Changed("GLKQXSSX") == true && model.GLKQXSSX != null) { strUpdateSQL += ",GLKQXSSX='" + model.GLKQXSSX.ToString().Replace("'", "''") + "'"; } if (model.Changed("GLKQXSXX") == true && model.GLKQXSXX != null) { strUpdateSQL += ",GLKQXSXX='" + model.GLKQXSXX.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_SDS set "; strSql += strUpdateSQL.Substring(1); strSql += " where " + p_strWhere; return(strSql); }
/// <summary> /// 修改一条数据 /// </summary> public bool Update(DEV_STANDARD_SDS model, int intID) { return(DbHelper.ExecuteSql(Conn, UpdateSQL(model, intID))); }
/// <summary> /// 添加一条数据 /// </summary> public bool Insert(DEV_STANDARD_SDS model) { return(g_DAL.Insert(model)); }
/// <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> /// 修改一条数据 SQL /// </summary> public string UpdateSQL(DEV_STANDARD_SDS model, int intID) { return(g_DAL.UpdateSQL(model, intID)); }
/// <summary> /// 添加一条数据 SQL /// </summary> public string InsertSQL(DEV_STANDARD_SDS 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("GDSCOXZ") == true && model.GDSCOXZ != null) { strFieldSQL += ",GDSCOXZ"; strValueSQL += ",'" + model.GDSCOXZ.ToString().Replace("'", "''") + "'"; } if (model.Changed("GDSHCXZ") == true && model.GDSHCXZ != null) { strFieldSQL += ",GDSHCXZ"; strValueSQL += ",'" + model.GDSHCXZ.ToString().Replace("'", "''") + "'"; } if (model.Changed("DSCOXZ") == true && model.DSCOXZ != null) { strFieldSQL += ",DSCOXZ"; strValueSQL += ",'" + model.DSCOXZ.ToString().Replace("'", "''") + "'"; } if (model.Changed("DSHCXZ") == true && model.DSHCXZ != null) { strFieldSQL += ",DSHCXZ"; strValueSQL += ",'" + model.DSHCXZ.ToString().Replace("'", "''") + "'"; } if (model.Changed("GLKQXSSX") == true && model.GLKQXSSX != null) { strFieldSQL += ",GLKQXSSX"; strValueSQL += ",'" + model.GLKQXSSX.ToString().Replace("'", "''") + "'"; } if (model.Changed("GLKQXSXX") == true && model.GLKQXSXX != null) { strFieldSQL += ",GLKQXSXX"; strValueSQL += ",'" + model.GLKQXSXX.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_SDS"; strSql += "("; strSql += strFieldSQL.Substring(1); strSql += ")"; strSql += " values"; strSql += "("; strSql += strValueSQL.Substring(1); strSql += ")"; return(strSql); }