/// <summary>
/// 得到一个对象实体
/// </summary>
public EDRS.Model.XT_QX_RYJSFP DataRowToModel(DataRow row)
{
EDRS.Model.XT_QX_RYJSFP model = new EDRS.Model.XT_QX_RYJSFP();
if (row != null)
{
if (row["DWBM"] != null)
{
model.DWBM = row["DWBM"].ToString();
}
if (row["BMBM"] != null)
{
model.BMBM = row["BMBM"].ToString();
}
if (row["JSBM"] != null)
{
model.JSBM = row["JSBM"].ToString();
}
if (row["GH"] != null)
{
model.GH = row["GH"].ToString();
}
if (row["ZJLDGH"] != null)
{
model.ZJLDGH = row["ZJLDGH"].ToString();
}
}
return(model);
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(EDRS.Model.XT_QX_RYJSFP model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into XT_QX_RYJSFP(");
strSql.Append("DWBM,BMBM,JSBM,GH,ZJLDGH)");
strSql.Append(" values (");
strSql.Append(":DWBM,:BMBM,:JSBM,:GH,:ZJLDGH)");
OracleParameter[] parameters =
{
new OracleParameter(":DWBM", OracleType.VarChar, 50),
new OracleParameter(":BMBM", OracleType.Char, 4),
new OracleParameter(":JSBM", OracleType.Char, 3),
new OracleParameter(":GH", OracleType.Char, 4),
new OracleParameter(":ZJLDGH", OracleType.Char, 4)
};
parameters[0].Value = model.DWBM;
parameters[1].Value = model.BMBM;
parameters[2].Value = model.JSBM;
parameters[3].Value = model.GH;
parameters[4].Value = model.ZJLDGH;
int rows = 0;
try
{
rows = DbHelperOra.ExecuteSql(strSql.ToString(), parameters);
}
catch (Exception ex)
{
EDRS.Common.LogHelper.LogError(this.context, "Exception", ex.Message, "public bool Add(EDRS.Model.XT_QX_RYJSFP model)", "EDRS.OracleDAL.XT_QX_RYJSFP", strSql.ToString(), parameters);
}
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public EDRS.Model.XT_QX_RYJSFP GetModel(string DWBM, string BMBM, string JSBM, string GH)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select DWBM,BMBM,JSBM,GH,ZJLDGH from XT_QX_RYJSFP ");
strSql.Append(ConfigHelper.GetConfigString("OrcDBLinq"));
strSql.Append(" where DWBM=:DWBM and BMBM=:BMBM and JSBM=:JSBM and GH=:GH ");
OracleParameter[] parameters =
{
new OracleParameter(":DWBM", OracleType.VarChar, 50),
new OracleParameter(":BMBM", OracleType.Char, 4),
new OracleParameter(":JSBM", OracleType.Char, 3),
new OracleParameter(":GH", OracleType.Char, 4)
};
parameters[0].Value = DWBM;
parameters[1].Value = BMBM;
parameters[2].Value = JSBM;
parameters[3].Value = GH;
EDRS.Model.XT_QX_RYJSFP model = new EDRS.Model.XT_QX_RYJSFP();
DataSet ds = null;
try
{
ds = DbHelperOra.Query(strSql.ToString(), parameters);
}
catch (Exception ex)
{
EDRS.Common.LogHelper.LogError(this.context, "Exception", ex.Message, "public EDRS.Model.XT_QX_RYJSFP GetModel(string DWBM,string BMBM,string JSBM,string GH)", "EDRS.OracleDAL.XT_QX_RYJSFP", strSql.ToString(), parameters);
}
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
