private void m_SaveFa_Click(object sender, EventArgs e) { string FABTG = m_EditFaBTG.Text, FAHSU = m_EditBTGHSU.Text; if (FABTG.IsNumeric() && FAHSU.IsNumeric()) { BLL.DEV_STANDARD_ZYJS_BLL bll = new BLL.DEV_STANDARD_ZYJS_BLL(); if (m_fa == null) { m_fa = new DEV_STANDARD_ZYJS(); m_fa.SEARCH_CONDITION = m_VehModel.SelectedItem.ToString(); m_fa.ZXMC = "不透光"; m_fa.ZYJSXZ = FABTG; m_fa.IS_SHOW = 1; m_fa.AREA_NAME = "新国标"; m_fa.UTYPE = 0; m_fa.HSUXZ = FAHSU; bll.Insert(m_fa); UpdateCostumeModelLimitTable(m_VehModel.SelectedItem.ToString(), "FA"); } else { m_fa.ZYJSXZ = FABTG; m_fa.HSUXZ = FAHSU; bll.Update(m_fa, m_fa.ID); } ResetTextBox(); MessageBox.Show("设置成功"); m_VehModel.ClearSelected(); } else { MessageBox.Show("输入文本必须是纯数字"); } }
/// <summary> /// 添加一条数据 SQL /// </summary> public string InsertSQL(DEV_STANDARD_ZYJS 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("ZYJSXZ") == true && model.ZYJSXZ != null) { strFieldSQL += ",ZYJSXZ"; strValueSQL += ",'" + model.ZYJSXZ.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("HSUXZ") == true && model.HSUXZ != null) { strFieldSQL += ",HSUXZ"; strValueSQL += ",'" + model.HSUXZ.ToString().Replace("'", "''") + "'"; } string strSql = ""; strSql += "insert into DEV_STANDARD_ZYJS"; strSql += "("; strSql += strFieldSQL.Substring(1); strSql += ")"; strSql += " values"; strSql += "("; strSql += strValueSQL.Substring(1); strSql += ")"; return(strSql); }
/// <summary> /// 得到一个对象实体 /// </summary> public DEV_STANDARD_ZYJS GetModel(int intID) { string strSql = ""; strSql += "select * from DEV_STANDARD_ZYJS"; strSql += " where "; strSql += " ID=" + intID + ""; DataTable dtTemp = new DataTable(); DbHelper.GetTable(Conn, strSql, ref dtTemp); DEV_STANDARD_ZYJS model = new DEV_STANDARD_ZYJS(); if (dtTemp.Rows.Count > 0) { model = new DEV_STANDARD_ZYJS(); 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.ZYJSXZ = dtTemp.Rows[0]["ZYJSXZ"] == DBNull.Value ? "" : dtTemp.Rows[0]["ZYJSXZ"].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.HSUXZ = dtTemp.Rows[0]["HSUXZ"] == DBNull.Value ? "" : dtTemp.Rows[0]["HSUXZ"].ToString(); } dtTemp.Dispose(); return(model); }
/// <summary> /// 修改一条数据 SQL /// </summary> public string UpdateSQL(DEV_STANDARD_ZYJS model, int intID) { 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("ZYJSXZ") == true && model.ZYJSXZ != null) { strUpdateSQL += ",ZYJSXZ='" + model.ZYJSXZ.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("HSUXZ") == true && model.HSUXZ != null) { strUpdateSQL += ",HSUXZ='" + model.HSUXZ.ToString().Replace("'", "''") + "'"; } string strSql = ""; strSql += "update DEV_STANDARD_ZYJS set "; strSql += strUpdateSQL.Substring(1); strSql += " where "; strSql += " ID=" + intID + ""; return(strSql); }
/// <summary> /// 修改全部数据 SQL /// </summary> public string UpdateAllSQL(DEV_STANDARD_ZYJS model) { string strUpdateSQL = ""; strUpdateSQL += ",SEARCH_CONDITION='" + model.SEARCH_CONDITION.ToString().Replace("'", "''") + "'"; strUpdateSQL += ",ZXMC='" + model.ZXMC.ToString().Replace("'", "''") + "'"; strUpdateSQL += ",ZYJSXZ='" + model.ZYJSXZ.ToString().Replace("'", "''") + "'"; strUpdateSQL += ",IS_SHOW=" + model.IS_SHOW + ""; strUpdateSQL += ",AREA_NAME='" + model.AREA_NAME.ToString().Replace("'", "''") + "'"; strUpdateSQL += ",UTYPE=" + model.UTYPE + ""; strUpdateSQL += ",HSUXZ='" + model.HSUXZ.ToString().Replace("'", "''") + "'"; string strSql = ""; strSql += "update DEV_STANDARD_ZYJS set "; strSql += strUpdateSQL.Substring(1); return(strSql); }
/// <summary> /// 添加一条数据 SQL /// </summary> public string InsertSQL(DEV_STANDARD_ZYJS model) { return(g_DAL.InsertSQL(model)); }
/// <summary> /// 修改全部数据 /// </summary> public bool UpdateAll(DEV_STANDARD_ZYJS model) { return(g_DAL.UpdateAll(model)); }
/// <summary> /// 修改全部数据 SQL /// </summary> public string UpdateAllSQL(DEV_STANDARD_ZYJS model) { return(g_DAL.UpdateAllSQL(model)); }
/// <summary> /// 修改一个集合 /// </summary> public bool UpdateRange(DEV_STANDARD_ZYJS model, string p_strWhere) { return(g_DAL.UpdateRange(model, p_strWhere)); }
/// <summary> /// 修改一个集合 SQL /// </summary> public string UpdateRangeSQL(DEV_STANDARD_ZYJS model, string p_strWhere) { return(g_DAL.UpdateRangeSQL(model, p_strWhere)); }
/// <summary> /// 修改一条数据 /// </summary> public bool Update(DEV_STANDARD_ZYJS model, int intID) { return(g_DAL.Update(model, intID)); }
/// <summary> /// 修改一条数据 /// </summary> public bool Update(DEV_STANDARD_ZYJS model, int intID) { return(DbHelper.ExecuteSql(Conn, UpdateSQL(model, intID))); }
/// <summary> /// 添加一条数据 /// </summary> public bool Insert(DEV_STANDARD_ZYJS model) { return(DbHelper.ExecuteSql(Conn, InsertSQL(model))); }
/// <summary> /// 得到对象集合 /// </summary> public DEV_STANDARD_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 DEV_STANDARD_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); } DEV_STANDARD_ZYJS[] arrModel = new DEV_STANDARD_ZYJS[dtTemp.Rows.Count]; for (int N = 0; N < dtTemp.Rows.Count; N++) { arrModel[N] = new DEV_STANDARD_ZYJS(); 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].ZYJSXZ = dtTemp.Rows[N]["ZYJSXZ"] == DBNull.Value ? "" : dtTemp.Rows[N]["ZYJSXZ"].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].HSUXZ = dtTemp.Rows[N]["HSUXZ"] == DBNull.Value ? "" : dtTemp.Rows[N]["HSUXZ"].ToString(); } dtTemp.Dispose(); return(arrModel); }
/// <summary> /// 修改全部数据 /// </summary> public bool UpdateAll(DEV_STANDARD_ZYJS model) { return(DbHelper.ExecuteSql(Conn, UpdateAllSQL(model))); }
/// <summary> /// 修改一个集合 /// </summary> public bool UpdateRange(DEV_STANDARD_ZYJS model, string p_strWhere) { return(DbHelper.ExecuteSql(Conn, UpdateRangeSQL(model, p_strWhere))); }
/// <summary> /// 添加一条数据 /// </summary> public bool Insert(DEV_STANDARD_ZYJS model) { return(g_DAL.Insert(model)); }
/// <summary> /// 修改一条数据 SQL /// </summary> public string UpdateSQL(DEV_STANDARD_ZYJS model, int intID) { return(g_DAL.UpdateSQL(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; } } } } } }