/// <summary> /// 得到一个对象实体 /// </summary> public EDRS.Model.XY_DZJZ_SBDJ GetModel(string MAC, string DEVSN) { StringBuilder strSql = new StringBuilder(); strSql.Append("select MAC,DEVSN,DEVTYPE,DEVFACTORY,DEVUSETIME,IP,DWBM from XY_DZJZ_SBDJ "); strSql.Append(ConfigHelper.GetConfigString("OrcDBLinq")); strSql.Append(" where MAC=:MAC and DEVSN=:DEVSN "); OracleParameter[] parameters = { new OracleParameter(":MAC", OracleType.VarChar, 20), new OracleParameter(":DEVSN", OracleType.VarChar, 50) }; parameters[0].Value = MAC; parameters[1].Value = DEVSN; EDRS.Model.XY_DZJZ_SBDJ model = new EDRS.Model.XY_DZJZ_SBDJ(); 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.XY_DZJZ_SBDJ GetModel(string MAC,string DEVSN)", "EDRS.OracleDAL.XY_DZJZ_SBDJ", strSql.ToString(), parameters); } if (ds != null && ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(EDRS.Model.XY_DZJZ_SBDJ model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update XY_DZJZ_SBDJ set "); strSql.Append("DEVTYPE=:DEVTYPE,"); strSql.Append("DEVFACTORY=:DEVFACTORY,"); strSql.Append("DEVUSETIME=:DEVUSETIME,"); strSql.Append("IP=:IP"); strSql.Append("DWBM=:DWBM"); strSql.Append(" where MAC=:MAC and DEVSN=:DEVSN "); OracleParameter[] parameters = { new OracleParameter(":DEVTYPE", OracleType.VarChar, 50), new OracleParameter(":DEVFACTORY", OracleType.VarChar, 50), new OracleParameter(":DEVUSETIME", OracleType.DateTime), new OracleParameter(":IP", OracleType.VarChar, 20), new OracleParameter(":DWBM", OracleType.VarChar, 50), new OracleParameter(":MAC", OracleType.VarChar, 20), new OracleParameter(":DEVSN", OracleType.VarChar, 50) }; parameters[0].Value = model.DEVTYPE; parameters[1].Value = model.DEVFACTORY; parameters[2].Value = model.DEVUSETIME; parameters[3].Value = model.IP; parameters[4].Value = model.DWBM; parameters[5].Value = model.MAC; parameters[6].Value = model.DEVSN; 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.XY_DZJZ_SBDJ model)", "EDRS.OracleDAL.XY_DZJZ_SBDJ", strSql.ToString(), parameters); } if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(EDRS.Model.XY_DZJZ_SBDJ model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into XY_DZJZ_SBDJ("); strSql.Append("MAC,DEVSN,DEVTYPE,DEVFACTORY,DEVUSETIME,IP,DWBM)"); strSql.Append(" values ("); strSql.Append(":MAC,:DEVSN,:DEVTYPE,:DEVFACTORY,:DEVUSETIME,:IP,:DWBM)"); OracleParameter[] parameters = { new OracleParameter(":MAC", OracleType.VarChar, 20), new OracleParameter(":DEVSN", OracleType.VarChar, 50), new OracleParameter(":DEVTYPE", OracleType.VarChar, 50), new OracleParameter(":DEVFACTORY", OracleType.VarChar, 50), new OracleParameter(":DEVUSETIME", OracleType.DateTime), new OracleParameter(":IP", OracleType.VarChar, 20), new OracleParameter(":DWBM", OracleType.VarChar, 50) }; parameters[0].Value = model.MAC; parameters[1].Value = model.DEVSN; parameters[2].Value = model.DEVTYPE; parameters[3].Value = model.DEVFACTORY; parameters[4].Value = model.DEVUSETIME; parameters[5].Value = model.IP; parameters[6].Value = model.DWBM; 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.XY_DZJZ_SBDJ model)", "EDRS.OracleDAL.XY_DZJZ_SBDJ", strSql.ToString(), parameters); } if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public EDRS.Model.XY_DZJZ_SBDJ DataRowToModel(DataRow row) { EDRS.Model.XY_DZJZ_SBDJ model = new EDRS.Model.XY_DZJZ_SBDJ(); if (row != null) { if (row["MAC"] != null) { model.MAC = row["MAC"].ToString(); } if (row["DEVSN"] != null) { model.DEVSN = row["DEVSN"].ToString(); } if (row["DEVTYPE"] != null) { model.DEVTYPE = row["DEVTYPE"].ToString(); } if (row["DEVFACTORY"] != null) { model.DEVFACTORY = row["DEVFACTORY"].ToString(); } if (row["DEVUSETIME"] != null && row["DEVUSETIME"].ToString() != "") { model.DEVUSETIME = DateTime.Parse(row["DEVUSETIME"].ToString()); } if (row["IP"] != null) { model.IP = row["IP"].ToString(); } if (row["DWBM"] != null) { model.DWBM = row["DWBM"].ToString(); } } return(model); }