/// <summary>
/// 得到一个对象实体
/// </summary>
public EDRS.Model.XT_DZJZ_JZMBML GetModel(string MBJZBH, string MLBH)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select MBJZBH,MLBH,FMLBH,MLXSMC,MLBM,MLLX,MLXX,MLSXH,SSLBBM,SSLBMC,SFBX,SFBXQFBXH from XT_DZJZ_JZMBML ");
strSql.Append(ConfigHelper.GetConfigString("OrcDBLinq"));
strSql.Append(" where MBJZBH=:MBJZBH and MLBH=:MLBH ");
OracleParameter[] parameters =
{
new OracleParameter(":MBJZBH", OracleType.Char, 14),
new OracleParameter(":MLBH", OracleType.VarChar, 100)
};
parameters[0].Value = MBJZBH;
parameters[1].Value = MLBH;
EDRS.Model.XT_DZJZ_JZMBML model = new EDRS.Model.XT_DZJZ_JZMBML();
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_DZJZ_JZMBML GetModel(string MBJZBH,string MLBH)", "EDRS.OracleDAL.XT_DZJZ_JZMBML", strSql.ToString(), parameters);
}
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public EDRS.Model.XT_DZJZ_JZMBML DataRowToModel(DataRow row)
{
EDRS.Model.XT_DZJZ_JZMBML model = new EDRS.Model.XT_DZJZ_JZMBML();
if (row != null)
{
if (row["MBJZBH"] != null)
{
model.MBJZBH = row["MBJZBH"].ToString();
}
if (row["MLBH"] != null)
{
model.MLBH = row["MLBH"].ToString();
}
if (row["FMLBH"] != null)
{
model.FMLBH = row["FMLBH"].ToString();
}
if (row["MLXSMC"] != null)
{
model.MLXSMC = row["MLXSMC"].ToString();
}
if (row["MLBM"] != null)
{
model.MLBM = row["MLBM"].ToString();
}
if (row["MLLX"] != null)
{
model.MLLX = row["MLLX"].ToString();
}
if (row["MLXX"] != null)
{
model.MLXX = row["MLXX"].ToString();
}
if (row["MLSXH"] != null && row["MLSXH"].ToString() != "")
{
model.MLSXH = decimal.Parse(row["MLSXH"].ToString());
}
if (row["SSLBBM"] != null)
{
model.SSLBBM = row["SSLBBM"].ToString();
}
if (row["SSLBMC"] != null)
{
model.SSLBMC = row["SSLBMC"].ToString();
}
if (row["SFBX"] != null)
{
model.SFBX = row["SFBX"].ToString();
}
if (row["SFBXQFBXH"] != null)
{
model.SFBXQFBXH = row["SFBXQFBXH"].ToString();
}
}
return(model);
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(EDRS.Model.XT_DZJZ_JZMBML model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into XT_DZJZ_JZMBML(");
strSql.Append("MBJZBH,MLBH,FMLBH,MLXSMC,MLBM,MLLX,MLXX,MLSXH,SSLBBM,SSLBMC,SFBX,SFBXQFBXH)");
strSql.Append(" values (");
strSql.Append(":MBJZBH,:MLBH,:FMLBH,:MLXSMC,:MLBM,:MLLX,:MLXX,:MLSXH,:SSLBBM,:SSLBMC,:SFBX,:SFBXQFBXH)");
OracleParameter[] parameters =
{
new OracleParameter(":MBJZBH", OracleType.Char, 14),
new OracleParameter(":MLBH", OracleType.VarChar, 100),
new OracleParameter(":FMLBH", OracleType.VarChar, 100),
new OracleParameter(":MLXSMC", OracleType.VarChar, 300),
new OracleParameter(":MLBM", OracleType.VarChar, 300),
new OracleParameter(":MLLX", OracleType.Char, 1),
new OracleParameter(":MLXX", OracleType.VarChar, 500),
new OracleParameter(":MLSXH", OracleType.Number, 4),
new OracleParameter(":SSLBBM", OracleType.Char, 13),
new OracleParameter(":SSLBMC", OracleType.VarChar, 300),
new OracleParameter(":SFBX", OracleType.Char, 1),
new OracleParameter(":SFBXQFBXH", OracleType.Char, 1)
};
parameters[0].Value = model.MBJZBH;
parameters[1].Value = model.MLBH;
parameters[2].Value = model.FMLBH;
parameters[3].Value = model.MLXSMC;
parameters[4].Value = model.MLBM;
parameters[5].Value = model.MLLX;
parameters[6].Value = model.MLXX;
parameters[7].Value = model.MLSXH;
parameters[8].Value = model.SSLBBM;
parameters[9].Value = model.SSLBMC;
parameters[10].Value = model.SFBX;
parameters[11].Value = model.SFBXQFBXH;
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_DZJZ_JZMBML model)", "EDRS.OracleDAL.XT_DZJZ_JZMBML", strSql.ToString(), parameters);
}
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
