/// <summary> /// 增加一条数据 /// </summary> public void Add(Entity.BASE_BUS_OVERRUN_SUBMIT entity) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into BASE_BUS_OVERRUN_SUBMIT("); strSql.Append("ID,BUSCODE,BUSLONG,BUSWIDTH,BUSHEIGHT,WEIGHT,PHOTO,INNAME,OUTNAME,TICKTIME,USERID,DEPTID,LOCATION,BUSUNIT,REMARKS"); strSql.Append(") values ("); strSql.Append(":ID,:BUSCODE,:BUSLONG,:BUSWIDTH,:BUSHEIGHT,:WEIGHT,:PHOTO,:INNAME,:OUTNAME,:TICKTIME,:USERID,:DEPTID,:LOCATION,:BUSUNIT,:REMARKS"); strSql.Append(") "); OracleParameter[] parameters = { new OracleParameter(":ID", OracleType.Number, 4), new OracleParameter(":BUSCODE", OracleType.VarChar, 20), new OracleParameter(":BUSLONG", OracleType.Number, 4), new OracleParameter(":BUSWIDTH", OracleType.Number, 4), new OracleParameter(":BUSHEIGHT", OracleType.Number, 4), new OracleParameter(":WEIGHT", OracleType.Number, 4), new OracleParameter(":PHOTO", OracleType.VarChar, 200), new OracleParameter(":INNAME", OracleType.VarChar, 50), new OracleParameter(":OUTNAME", OracleType.VarChar, 50), new OracleParameter(":TICKTIME", OracleType.DateTime), new OracleParameter(":USERID", OracleType.Number, 4), new OracleParameter(":DEPTID", OracleType.Number, 4), new OracleParameter(":LOCATION", OracleType.VarChar, 100), new OracleParameter(":BUSUNIT", OracleType.VarChar, 50), new OracleParameter(":REMARKS", OracleType.VarChar, 50) }; parameters[0].Value = entity.ID; parameters[1].Value = entity.BUSCODE; parameters[2].Value = entity.BUSLONG; parameters[3].Value = entity.BUSWIDTH; parameters[4].Value = entity.BUSHEIGHT; parameters[5].Value = entity.WEIGHT; parameters[6].Value = entity.PHOTO; parameters[7].Value = entity.INNAME; parameters[8].Value = entity.OUTNAME; parameters[9].Value = entity.TICKTIME; parameters[10].Value = entity.USERID; parameters[11].Value = entity.DEPTID; parameters[12].Value = entity.LOCATION; parameters[13].Value = entity.BUSUNIT; parameters[14].Value = entity.REMARKS; OracleHelper.ExecuteNonQuery(strSql.ToString(), parameters); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Entity.BASE_BUS_OVERRUN_SUBMIT entity) { StringBuilder strSql = new StringBuilder(); strSql.Append("update BASE_BUS_OVERRUN_SUBMIT set "); strSql.Append(" ID = :ID , "); strSql.Append(" BUSCODE = :BUSCODE , "); strSql.Append(" BUSLONG = :BUSLONG , "); strSql.Append(" BUSWIDTH = :BUSWIDTH , "); strSql.Append(" BUSHEIGHT = :BUSHEIGHT , "); strSql.Append(" WEIGHT = :WEIGHT , "); strSql.Append(" PHOTO = :PHOTO , "); strSql.Append(" INNAME = :INNAME , "); strSql.Append(" OUTNAME = :OUTNAME , "); strSql.Append(" TICKTIME = :TICKTIME , "); strSql.Append(" USERID = :USERID , "); strSql.Append(" DEPTID = :DEPTID , "); strSql.Append(" LOCATION = :LOCATION , "); strSql.Append(" BUSUNIT = :BUSUNIT , "); strSql.Append(" REMARKS = :REMARKS "); strSql.Append(" where ID=:ID "); OracleParameter[] parameters = { new OracleParameter(":ID", OracleType.Number, 4), new OracleParameter(":BUSCODE", OracleType.VarChar, 20), new OracleParameter(":BUSLONG", OracleType.Number, 4), new OracleParameter(":BUSWIDTH", OracleType.Number, 4), new OracleParameter(":BUSHEIGHT", OracleType.Number, 4), new OracleParameter(":WEIGHT", OracleType.Number, 4), new OracleParameter(":PHOTO", OracleType.VarChar, 200), new OracleParameter(":INNAME", OracleType.VarChar, 50), new OracleParameter(":OUTNAME", OracleType.VarChar, 50), new OracleParameter(":TICKTIME", OracleType.DateTime), new OracleParameter(":USERID", OracleType.Number, 4), new OracleParameter(":DEPTID", OracleType.Number, 4), new OracleParameter(":LOCATION", OracleType.VarChar, 100), new OracleParameter(":BUSUNIT", OracleType.VarChar, 50), new OracleParameter(":REMARKS", OracleType.VarChar, 50) }; parameters[15].Value = entity.ID; parameters[16].Value = entity.BUSCODE; parameters[17].Value = entity.BUSLONG; parameters[18].Value = entity.BUSWIDTH; parameters[19].Value = entity.BUSHEIGHT; parameters[20].Value = entity.WEIGHT; parameters[21].Value = entity.PHOTO; parameters[22].Value = entity.INNAME; parameters[23].Value = entity.OUTNAME; parameters[24].Value = entity.TICKTIME; parameters[25].Value = entity.USERID; parameters[26].Value = entity.DEPTID; parameters[27].Value = entity.LOCATION; parameters[28].Value = entity.BUSUNIT; parameters[29].Value = entity.REMARKS; int rows = OracleHelper.ExecuteNonQuery(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public Entity.BASE_BUS_OVERRUN_SUBMIT GetEntity(decimal ID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select ID, BUSCODE, BUSLONG, BUSWIDTH, BUSHEIGHT, WEIGHT, PHOTO, INNAME, OUTNAME, TICKTIME, USERID, DEPTID, LOCATION, BUSUNIT, REMARKS "); strSql.Append(" from BASE_BUS_OVERRUN_SUBMIT "); strSql.Append(" where ID=:ID "); OracleParameter[] parameters = { new OracleParameter(":ID", OracleType.Number, 4) }; parameters[0].Value = ID; Entity.BASE_BUS_OVERRUN_SUBMIT entity = new Entity.BASE_BUS_OVERRUN_SUBMIT(); DataTable dt = OracleHelper.Query(CommandType.Text, strSql.ToString(), parameters); if (dt.Rows.Count > 0) { if (dt.Rows[0]["ID"].ToString() != "") { entity.ID = decimal.Parse(dt.Rows[0]["ID"].ToString()); } entity.BUSCODE = dt.Rows[0]["BUSCODE"].ToString(); if (dt.Rows[0]["BUSLONG"].ToString() != "") { entity.BUSLONG = decimal.Parse(dt.Rows[0]["BUSLONG"].ToString()); } if (dt.Rows[0]["BUSWIDTH"].ToString() != "") { entity.BUSWIDTH = decimal.Parse(dt.Rows[0]["BUSWIDTH"].ToString()); } if (dt.Rows[0]["BUSHEIGHT"].ToString() != "") { entity.BUSHEIGHT = decimal.Parse(dt.Rows[0]["BUSHEIGHT"].ToString()); } if (dt.Rows[0]["WEIGHT"].ToString() != "") { entity.WEIGHT = decimal.Parse(dt.Rows[0]["WEIGHT"].ToString()); } entity.PHOTO = dt.Rows[0]["PHOTO"].ToString(); entity.INNAME = dt.Rows[0]["INNAME"].ToString(); entity.OUTNAME = dt.Rows[0]["OUTNAME"].ToString(); if (dt.Rows[0]["TICKTIME"].ToString() != "") { entity.TICKTIME = DateTime.Parse(dt.Rows[0]["TICKTIME"].ToString()); } if (dt.Rows[0]["USERID"].ToString() != "") { entity.USERID = decimal.Parse(dt.Rows[0]["USERID"].ToString()); } if (dt.Rows[0]["DEPTID"].ToString() != "") { entity.DEPTID = decimal.Parse(dt.Rows[0]["DEPTID"].ToString()); } entity.LOCATION = dt.Rows[0]["LOCATION"].ToString(); entity.BUSUNIT = dt.Rows[0]["BUSUNIT"].ToString(); entity.REMARKS = dt.Rows[0]["REMARKS"].ToString(); return(entity); } else { return(null); } }