/// <summary>
/// 得到一个对象实体
/// </summary>
public EDRS.Model.YX_DZJZ_LSAJWJFP DataRowToModel(DataRow row)
{
EDRS.Model.YX_DZJZ_LSAJWJFP model = new EDRS.Model.YX_DZJZ_LSAJWJFP();
if (row != null)
{
if (row["FPBM"] != null)
{
model.FPBM = row["FPBM"].ToString();
}
if (row["YJXH"] != null)
{
model.YJXH = row["YJXH"].ToString();
}
if (row["WJXH"] != null)
{
model.WJXH = row["WJXH"].ToString();
}
if (row["ADDTIME"] != null)
{
model.ADDTIME = Convert.ToDateTime(row["ADDTIME"]);
}
if (row["SFSC"] != null)
{
model.SFSC = row["SFSC"].ToString();
}
}
return(model);
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public EDRS.Model.YX_DZJZ_LSAJWJFP GetModel(string FPBM)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select FPBM,YJXH,WJXH,ADDTIME,SFSC from YX_DZJZ_LSAJWJFP ");
strSql.Append(ConfigHelper.GetConfigString("OrcDBLinq"));
strSql.Append(" where FPBM=:FPBM ");
OracleParameter[] parameters =
{
new OracleParameter(":FPBM", OracleType.VarChar, 100)
};
parameters[0].Value = FPBM;
EDRS.Model.YX_DZJZ_LSAJWJFP model = new EDRS.Model.YX_DZJZ_LSAJWJFP();
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.YX_DZJZ_LSAJWJFP GetModel(string FPBM)", "EDRS.OracleDAL.YX_DZJZ_LSAJWJFP", 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(EDRS.Model.YX_DZJZ_LSAJWJFP model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update YX_DZJZ_LSAJWJFP set ");
strSql.Append("YJXH=:YJXH,");
strSql.Append("WJXH=:WJXH,");
strSql.Append("SFSC=:SFSC");
strSql.Append(" where FPBM=:FPBM ");
OracleParameter[] parameters =
{
new OracleParameter(":YJXH", OracleType.VarChar, 50),
new OracleParameter(":WJXH", OracleType.VarChar, 100),
new OracleParameter(":SFSC", OracleType.Char, 1),
new OracleParameter(":FPBM", OracleType.VarChar, 50)
};
parameters[0].Value = model.YJXH;
parameters[1].Value = model.WJXH;
parameters[2].Value = model.SFSC;
parameters[3].Value = model.FPBM;
int rows = 0;
try
{
rows = DbHelperOra.ExecuteSql(strSql.ToString(), parameters);
}
catch (Exception ex)
{
EDRS.Common.LogHelper.LogError(this.context, "Exception", ex.Message, "public bool Update(EDRS.Model.YX_DZJZ_LSAJWJFP model)", "EDRS.OracleDAL.YX_DZJZ_LSAJWJFP", strSql.ToString(), parameters);
}
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(EDRS.Model.YX_DZJZ_LSAJWJFP model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into YX_DZJZ_LSAJWJFP(");
strSql.Append("YJXH,WJXH,SFSC)");
strSql.Append(" values (");
strSql.Append(":YJXH,:WJXH,:SFSC)");
OracleParameter[] parameters =
{
new OracleParameter(":YJXH", OracleType.VarChar, 50),
new OracleParameter(":WJXH", OracleType.VarChar, 100),
new OracleParameter(":SFSC", OracleType.Char, 1)
};
parameters[0].Value = model.YJXH;
parameters[1].Value = model.WJXH;
parameters[2].Value = model.SFSC;
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.YX_DZJZ_LSAJWJFP model)", "EDRS.OracleDAL.YX_DZJZ_LSAJWJFP", strSql.ToString(), parameters);
}
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}