private Boolean UpdateCostumeModelLimitTable(string searchCondition, string method) { COSTUME_MODEL_LIMIT instance = m_db.Find <COSTUME_MODEL_LIMIT>("MODEL_NAME", searchCondition); int r = 0; if (instance.MODEL_NAME.IsEffective()) { if (instance.METHOD_NAME.Contains(method)) { return(false); } else { instance.METHOD_NAME = instance.METHOD_NAME + "&" + method; r = m_db.Update(instance, "MODEL_NAME"); for (int i = 0; i < m_relations.Count; i++) { if (m_relations[i].MODEL_NAME == searchCondition) { m_relations[i].METHOD_NAME += "&" + method; } } } } return(r > 0); }
/// <summary> /// 得到一个对象实体 /// </summary> public COSTUME_MODEL_LIMIT GetModel(string strMODEL_NAME) { string strSql = ""; strSql += "select * from COSTUME_MODEL_LIMIT"; strSql += " where "; strSql += " MODEL_NAME='" + strMODEL_NAME + "'"; DataTable dtTemp = new DataTable(); DbHelper.GetTable(Conn, strSql, ref dtTemp); COSTUME_MODEL_LIMIT model = new COSTUME_MODEL_LIMIT(); if (dtTemp.Rows.Count > 0) { model = new COSTUME_MODEL_LIMIT(); model.MODEL_NAME = dtTemp.Rows[0]["MODEL_NAME"] == DBNull.Value ? "" : dtTemp.Rows[0]["MODEL_NAME"].ToString(); model.METHOD_NAME = dtTemp.Rows[0]["METHOD_NAME"] == DBNull.Value ? "" : dtTemp.Rows[0]["METHOD_NAME"].ToString(); } dtTemp.Dispose(); return(model); }
/// <summary> /// 添加一条数据 SQL /// </summary> public string InsertSQL(COSTUME_MODEL_LIMIT model) { string strFieldSQL = ""; string strValueSQL = ""; if (model.Changed("MODEL_NAME") == true && model.MODEL_NAME != null) { strFieldSQL += ",MODEL_NAME"; strValueSQL += ",'" + model.MODEL_NAME.ToString().Replace("'", "''") + "'"; } if (model.Changed("METHOD_NAME") == true && model.METHOD_NAME != null) { strFieldSQL += ",METHOD_NAME"; strValueSQL += ",'" + model.METHOD_NAME.ToString().Replace("'", "''") + "'"; } string strSql = ""; strSql += "insert into COSTUME_MODEL_LIMIT"; strSql += "("; strSql += strFieldSQL.Substring(1); strSql += ")"; strSql += " values"; strSql += "("; strSql += strValueSQL.Substring(1); strSql += ")"; return(strSql); }
/// <summary> /// 得到对象集合 /// </summary> public COSTUME_MODEL_LIMIT[] 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 COSTUME_MODEL_LIMIT"; 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); } COSTUME_MODEL_LIMIT[] arrModel = new COSTUME_MODEL_LIMIT[dtTemp.Rows.Count]; for (int N = 0; N < dtTemp.Rows.Count; N++) { arrModel[N] = new COSTUME_MODEL_LIMIT(); arrModel[N].MODEL_NAME = dtTemp.Rows[N]["MODEL_NAME"] == DBNull.Value ? "" : dtTemp.Rows[N]["MODEL_NAME"].ToString(); arrModel[N].METHOD_NAME = dtTemp.Rows[N]["METHOD_NAME"] == DBNull.Value ? "" : dtTemp.Rows[N]["METHOD_NAME"].ToString(); } dtTemp.Dispose(); return(arrModel); }
private bool InsertCostumeLimitTable(COSTUME_MODEL_LIMIT entity) { if (Exist(entity.MODEL_NAME)) { MessageBox.Show("该车型已存在自定义限值 不用添加"); return(false); } else { BLL.COSTUME_MODEL_LIMIT_BLL bll = new BLL.COSTUME_MODEL_LIMIT_BLL(); return(bll.Insert(entity)); } }
/// <summary> /// 修改全部数据 SQL /// </summary> public string UpdateAllSQL(COSTUME_MODEL_LIMIT model) { string strUpdateSQL = ""; strUpdateSQL += ",MODEL_NAME='" + model.MODEL_NAME.ToString().Replace("'", "''") + "'"; strUpdateSQL += ",METHOD_NAME='" + model.METHOD_NAME.ToString().Replace("'", "''") + "'"; string strSql = ""; strSql += "update COSTUME_MODEL_LIMIT set "; strSql += strUpdateSQL.Substring(1); return(strSql); }
private void m_btnConfirm_Click(object sender, EventArgs e) { COSTUME_MODEL_LIMIT model = new COSTUME_MODEL_LIMIT(); model.MODEL_NAME = textBox1.Text; model.METHOD_NAME = ""; if (InsertCostumeLimitTable(model)) { MessageBox.Show("车型添加成功"); this.fptrDialogResult(textBox1.Text); this.Close(); } else { MessageBox.Show("车型添加失败"); } }
/// <summary> /// 修改一个集合 SQL /// </summary> public string UpdateRangeSQL(COSTUME_MODEL_LIMIT model, string p_strWhere) { string strUpdateSQL = ""; if (model.Changed("MODEL_NAME") == true && model.MODEL_NAME != null) { strUpdateSQL += ",MODEL_NAME='" + model.MODEL_NAME.ToString().Replace("'", "''") + "'"; } if (model.Changed("METHOD_NAME") == true && model.METHOD_NAME != null) { strUpdateSQL += ",METHOD_NAME='" + model.METHOD_NAME.ToString().Replace("'", "''") + "'"; } string strSql = ""; strSql += "update COSTUME_MODEL_LIMIT set "; strSql += strUpdateSQL.Substring(1); strSql += " where " + p_strWhere; return(strSql); }
/// <summary> /// 修改一条数据 SQL /// </summary> public string UpdateSQL(COSTUME_MODEL_LIMIT model, string strMODEL_NAME) { return(g_DAL.UpdateSQL(model, strMODEL_NAME)); }
/// <summary> /// 添加一条数据 /// </summary> public bool Insert(COSTUME_MODEL_LIMIT model) { return(g_DAL.Insert(model)); }
/// <summary> /// 添加一条数据 SQL /// </summary> public string InsertSQL(COSTUME_MODEL_LIMIT model) { return(g_DAL.InsertSQL(model)); }
/// <summary> /// 修改全部数据 /// </summary> public bool UpdateAll(COSTUME_MODEL_LIMIT model) { return(g_DAL.UpdateAll(model)); }
/// <summary> /// 修改全部数据 SQL /// </summary> public string UpdateAllSQL(COSTUME_MODEL_LIMIT model) { return(g_DAL.UpdateAllSQL(model)); }
/// <summary> /// 修改一个集合 /// </summary> public bool UpdateRange(COSTUME_MODEL_LIMIT model, string p_strWhere) { return(g_DAL.UpdateRange(model, p_strWhere)); }
/// <summary> /// 修改一个集合 SQL /// </summary> public string UpdateRangeSQL(COSTUME_MODEL_LIMIT model, string p_strWhere) { return(g_DAL.UpdateRangeSQL(model, p_strWhere)); }
/// <summary> /// 修改一条数据 /// </summary> public bool Update(COSTUME_MODEL_LIMIT model, string strMODEL_NAME) { return(g_DAL.Update(model, strMODEL_NAME)); }
/// <summary> /// 添加一条数据 /// </summary> public bool Insert(COSTUME_MODEL_LIMIT model) { return(DbHelper.ExecuteSql(Conn, InsertSQL(model))); }
/// <summary> /// 修改一条数据 /// </summary> public bool Update(COSTUME_MODEL_LIMIT model, string strMODEL_NAME) { return(DbHelper.ExecuteSql(Conn, UpdateSQL(model, strMODEL_NAME))); }
/// <summary> /// 修改全部数据 /// </summary> public bool UpdateAll(COSTUME_MODEL_LIMIT model) { return(DbHelper.ExecuteSql(Conn, UpdateAllSQL(model))); }
/// <summary> /// 修改一个集合 /// </summary> public bool UpdateRange(COSTUME_MODEL_LIMIT model, string p_strWhere) { return(DbHelper.ExecuteSql(Conn, UpdateRangeSQL(model, p_strWhere))); }