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)));
}
