/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Model.CHANGELOG model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update CHANGELOG set ");
strSql.Append("ACT_DATE=:ACT_DATE,");
strSql.Append("OURNO=:OURNO,");
strSql.Append("ACTION=:ACTION,");
strSql.Append("COL_NAME=:COL_NAME,");
strSql.Append("OLD_VAL=:OLD_VAL,");
strSql.Append("NEW_VAL=:NEW_VAL,");
strSql.Append("CUR_USER=:CUR_USER");
strSql.Append(" where ");
OracleParameter[] parameters =
{
new OracleParameter(":ACT_DATE", OracleType.DateTime),
new OracleParameter(":OURNO", OracleType.VarChar, 24),
new OracleParameter(":ACTION", OracleType.Char, 1),
new OracleParameter(":COL_NAME", OracleType.VarChar, 20),
new OracleParameter(":OLD_VAL", OracleType.VarChar, 300),
new OracleParameter(":NEW_VAL", OracleType.VarChar, 300),
new OracleParameter(":CUR_USER", OracleType.VarChar, 20)
};
parameters[0].Value = model.ACT_DATE;
parameters[1].Value = model.OURNO;
parameters[2].Value = model.ACTION;
parameters[3].Value = model.COL_NAME;
parameters[4].Value = model.OLD_VAL;
parameters[5].Value = model.NEW_VAL;
parameters[6].Value = model.CUR_USER;
int rows = DbHelperOra.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Model.CHANGELOG GetModel()
{
//该表无主键信息，请自定义主键/条件字段
StringBuilder strSql = new StringBuilder();
strSql.Append("select ACT_DATE,OURNO,ACTION,COL_NAME,OLD_VAL,NEW_VAL,CUR_USER from CHANGELOG ");
strSql.Append(" where ");
OracleParameter[] parameters =
{
};
Model.CHANGELOG model = new Model.CHANGELOG();
DataSet ds = DbHelperOra.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 Add(Model.CHANGELOG model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into CHANGELOG(");
strSql.Append("ACT_DATE,OURNO,ACTION,COL_NAME,OLD_VAL,NEW_VAL,CUR_USER)");
strSql.Append(" values (");
strSql.Append(":ACT_DATE,:OURNO,:ACTION,:COL_NAME,:OLD_VAL,:NEW_VAL,:CUR_USER)");
OracleParameter[] parameters =
{
new OracleParameter(":ACT_DATE", OracleType.DateTime),
new OracleParameter(":OURNO", OracleType.VarChar, 24),
new OracleParameter(":ACTION", OracleType.Char, 1),
new OracleParameter(":COL_NAME", OracleType.VarChar, 20),
new OracleParameter(":OLD_VAL", OracleType.VarChar, 300),
new OracleParameter(":NEW_VAL", OracleType.VarChar, 300),
new OracleParameter(":CUR_USER", OracleType.VarChar, 20)
};
parameters[0].Value = model.ACT_DATE;
parameters[1].Value = model.OURNO;
parameters[2].Value = model.ACTION;
parameters[3].Value = model.COL_NAME;
parameters[4].Value = model.OLD_VAL;
parameters[5].Value = model.NEW_VAL;
parameters[6].Value = model.CUR_USER;
int rows = DbHelperOra.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Model.CHANGELOG DataRowToModel(DataRow row)
{
Model.CHANGELOG model = new Model.CHANGELOG();
if (row != null)
{
if (row["ACT_DATE"] != null && row["ACT_DATE"].ToString() != "")
{
model.ACT_DATE = DateTime.Parse(row["ACT_DATE"].ToString());
}
if (row["OURNO"] != null)
{
model.OURNO = row["OURNO"].ToString();
}
if (row["ACTION"] != null)
{
model.ACTION = row["ACTION"].ToString();
}
if (row["COL_NAME"] != null)
{
model.COL_NAME = row["COL_NAME"].ToString();
}
if (row["OLD_VAL"] != null)
{
model.OLD_VAL = row["OLD_VAL"].ToString();
}
if (row["NEW_VAL"] != null)
{
model.NEW_VAL = row["NEW_VAL"].ToString();
}
if (row["CUR_USER"] != null)
{
model.CUR_USER = row["CUR_USER"].ToString();
}
}
return(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Model.CHANGELOG model)
{
return(dal.Update(model));
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(Model.CHANGELOG model)
{
return(dal.Add(model));
}
