/// <summary>
/// 得到一个对象实体
/// </summary>
public EDRS.Model.XT_QX_JSANQX DataRowToModel(DataRow row)
{
EDRS.Model.XT_QX_JSANQX model = new EDRS.Model.XT_QX_JSANQX();
if (row != null)
{
if (row["QXBM"] != null)
{
model.QXBM = row["QXBM"].ToString();
}
if (row["ANBH"] != null)
{
model.ANBH = row["ANBH"].ToString();
}
if (row["DWBM"] != null)
{
model.DWBM = row["DWBM"].ToString();
}
if (row["JSBM"] != null)
{
model.JSBM = row["JSBM"].ToString();
}
if (row["BMBM"] != null)
{
model.BMBM = row["BMBM"].ToString();
}
}
return(model);
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(EDRS.Model.XT_QX_JSANQX model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into XT_QX_JSANQX(");
strSql.Append("ANBH,DWBM,JSBM,BMBM)");
strSql.Append(" values (");
strSql.Append(":ANBH,:DWBM,:JSBM,:BMBM)");
OracleParameter[] parameters =
{
new OracleParameter(":ANBH", OracleType.VarChar, 50),
new OracleParameter(":DWBM", OracleType.VarChar, 50),
new OracleParameter(":JSBM", OracleType.Char, 3),
new OracleParameter(":BMBM", OracleType.Char, 4)
};
parameters[0].Value = model.ANBH;
parameters[1].Value = model.DWBM;
parameters[2].Value = model.JSBM;
parameters[3].Value = model.BMBM;
int rows = DbHelperOra.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(EDRS.Model.XT_QX_JSANQX model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update XT_QX_JSANQX set ");
strSql.Append("QXBM=:QXBM,");
strSql.Append("ANBH=:ANBH,");
strSql.Append("DWBM=:DWBM,");
strSql.Append("JSBM=:JSBM,");
strSql.Append("BMBM=:BMBM");
strSql.Append(" where QXBM=:QXBM ");
OracleParameter[] parameters =
{
new OracleParameter(":QXBM", OracleType.VarChar, 50),
new OracleParameter(":ANBH", OracleType.VarChar, 50),
new OracleParameter(":DWBM", OracleType.VarChar, 50),
new OracleParameter(":JSBM", OracleType.Char, 3),
new OracleParameter(":BMBM", OracleType.Char, 4)
};
parameters[0].Value = model.QXBM;
parameters[1].Value = model.ANBH;
parameters[2].Value = model.DWBM;
parameters[3].Value = model.JSBM;
parameters[4].Value = model.BMBM;
int rows = DbHelperOra.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public EDRS.Model.XT_QX_JSANQX GetModel(string QXBM)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select QXBM,ANBH,DWBM,JSBM,BMBM from XT_QX_JSANQX ");
strSql.Append(" where QXBM=:QXBM ");
OracleParameter[] parameters =
{
new OracleParameter(":QXBM", OracleType.VarChar, 50)
};
parameters[0].Value = QXBM;
EDRS.Model.XT_QX_JSANQX model = new EDRS.Model.XT_QX_JSANQX();
DataSet ds = DbHelperOra.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
