/// <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); } }