/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(STIM.Model.STIM_CONFIG model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update STIM_CONFIG set ");
strSql.Append("SEARCH_FORM_XML=:SEARCH_FORM_XML,DETAIL_FORM_XML=:DETAIL_FORM_XML,DATAGRIDVIEW_XML=:DATAGRIDVIEW_XML,REMARK=:REMARK");
strSql.Append(" where TABLE_NAME=:TABLE_NAME");
OracleParameter[] parameters =
{
new OracleParameter(":SEARCH_FORM_XML", OracleDbType.NClob),
new OracleParameter(":DETAIL_FORM_XML", OracleDbType.NClob),
new OracleParameter(":DATAGRIDVIEW_XML", OracleDbType.NClob),
new OracleParameter(":REMARK", OracleDbType.Varchar2),
new OracleParameter(":TABLE_NAME", OracleDbType.Varchar2)
};
parameters[0].Value = model.SEARCH_FORM_XML;
parameters[1].Value = model.DETAIL_FORM_XML;
parameters[2].Value = model.DATAGRIDVIEW_XML;
parameters[3].Value = model.REMARK;
parameters[4].Value = model.TABLE_NAME;
int rows = ora.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(STIM.Model.STIM_CONFIG model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into STIM_CONFIG(");
strSql.Append("TABLE_NAME,SEARCH_FORM_XML,DETAIL_FORM_XML,DATAGRIDVIEW_XML,REMARK)");
strSql.Append(" values (");
strSql.Append(":TABLE_NAME,:SEARCH_FORM_XML,:DETAIL_FORM_XML,:DATAGRIDVIEW_XML,:REMARK)");
OracleParameter[] parameters =
{
new OracleParameter(":TABLE_NAME", OracleDbType.Varchar2),
new OracleParameter(":SEARCH_FORM_XML", OracleDbType.NClob),
new OracleParameter(":DETAIL_FORM_XML", OracleDbType.NClob),
new OracleParameter(":DATAGRIDVIEW_XML", OracleDbType.NClob),
new OracleParameter(":REMARK", OracleDbType.Varchar2)
};
parameters[0].Value = model.TABLE_NAME;
parameters[1].Value = model.SEARCH_FORM_XML;
parameters[2].Value = model.DETAIL_FORM_XML;
parameters[3].Value = model.DATAGRIDVIEW_XML;
parameters[4].Value = model.REMARK;
int rows = ora.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public STIM.Model.STIM_CONFIG DataRowToModel(DataRow row)
{
STIM.Model.STIM_CONFIG model = new STIM.Model.STIM_CONFIG();
if (row != null)
{
if (row["TABLE_NAME"] != null)
{
model.TABLE_NAME = row["TABLE_NAME"].ToString();
}
if (row["SEARCH_FORM_XML"] != null)
{
model.SEARCH_FORM_XML = row["SEARCH_FORM_XML"].ToString();
}
if (row["DETAIL_FORM_XML"] != null)
{
model.DETAIL_FORM_XML = row["DETAIL_FORM_XML"].ToString();
}
if (row["DATAGRIDVIEW_XML"] != null)
{
model.DATAGRIDVIEW_XML = row["DATAGRIDVIEW_XML"].ToString();
}
if (row["REMARK"] != null)
{
model.REMARK = row["REMARK"].ToString();
}
}
return(model);
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public STIM.Model.STIM_CONFIG GetModel(string TABLE_NAME)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select TABLE_NAME,SEARCH_FORM_XML,DETAIL_FORM_XML,DATAGRIDVIEW_XML,REMARK from STIM_CONFIG ");
strSql.Append(" where TABLE_NAME=:TABLE_NAME ");
OracleParameter[] parameters =
{
new OracleParameter(":TABLE_NAME", OracleDbType.Varchar2)
};
parameters[0].Value = TABLE_NAME;
STIM.Model.STIM_CONFIG model = new STIM.Model.STIM_CONFIG();
DataSet ds = ora.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(STIM.Model.STIM_CONFIG model)
{
return(dal.Update(model));
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(STIM.Model.STIM_CONFIG model)
{
return(dal.Add(model));
}
