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