/// <summary> /// 得到一个对象实体 /// </summary> public RelayTest.Model.ModelOPERATIONLOG GetModel(decimal F_ID) { try { Log.Info("DalOPERATIONLOG->GetModel---START"); StringBuilder strSql = new StringBuilder(); strSql.Append("select F_ID, F_DATE, F_USER_ID, F_MODULE_NAME "); strSql.Append(" from T_OPERATIONLOG "); strSql.Append(" where 1=1 AND F_ID=:F_ID "); OracleParameter[] parameters = { new OracleParameter(":F_ID", OracleType.Number, 18) }; parameters[0].Value = F_ID; RelayTest.Model.ModelOPERATIONLOG model = new RelayTest.Model.ModelOPERATIONLOG(); DataSet ds = Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows[0]["F_ID"].ToString() != "") { model.F_ID = decimal.Parse(ds.Tables[0].Rows[0]["F_ID"].ToString()); } if (ds.Tables[0].Rows[0]["F_DATE"].ToString() != "") { model.F_DATE = DateTime.Parse(ds.Tables[0].Rows[0]["F_DATE"].ToString()); } model.F_USER_ID = ds.Tables[0].Rows[0]["F_USER_ID"].ToString(); model.F_MODULE_NAME = ds.Tables[0].Rows[0]["F_MODULE_NAME"].ToString(); return(model); } else { return(null); } } catch (Exception ex) { Log.Error("DalOPERATIONLOG->GetModel---FAILED", ex); throw ex; } }
/// <summary> /// 获得数据列表 /// </summary> public List <RelayTest.Model.ModelOPERATIONLOG> DataTableToList(DataTable dt) { try { Log.Info("BllOPERATIONLOG->DataTableToList---START"); ConnectionOpen(); dal.SetDBAccess(GetDBAccess()); List <RelayTest.Model.ModelOPERATIONLOG> modelList = new List <RelayTest.Model.ModelOPERATIONLOG>(); int rowsCount = dt.Rows.Count; if (rowsCount > 0) { RelayTest.Model.ModelOPERATIONLOG model; for (int n = 0; n < rowsCount; n++) { model = new RelayTest.Model.ModelOPERATIONLOG(); if (dt.Rows[n]["F_ID"].ToString() != "") { model.F_ID = decimal.Parse(dt.Rows[n]["F_ID"].ToString()); } if (dt.Rows[n]["F_DATE"].ToString() != "") { model.F_DATE = DateTime.Parse(dt.Rows[n]["F_DATE"].ToString()); } model.F_USER_ID = dt.Rows[n]["F_USER_ID"].ToString(); model.F_MODULE_NAME = dt.Rows[n]["F_MODULE_NAME"].ToString(); modelList.Add(model); } } return(modelList); } catch (Exception ex) { Log.Error("BllOPERATIONLOG->DataTableToList---FAILED", ex); throw ex; } finally { ConnectionClose(); Log.Info("BllOPERATIONLOG->DataTableToList---finally"); } }
/// <summary> /// 更新一条数据 /// </summary> /// <param name="model">相应的数据实体</param> /// <returns>真表示有记录被更新,否表示没有记录被更新</returns> public bool Update(RelayTest.Model.ModelOPERATIONLOG model) { try { Log.Info("BllOPERATIONLOG->Update---START"); ConnectionOpen(); dal.SetDBAccess(GetDBAccess()); return(dal.Update(model)); } catch (Exception ex) { Log.Error("BllOPERATIONLOG->Update---FAILED", ex); throw ex; } finally { ConnectionClose(); Log.Info("BllOPERATIONLOG->Update---finally"); } }
/// <summary> /// 增加一条数据 /// </summary> public void Add(RelayTest.Model.ModelOPERATIONLOG model) { try { Log.Info("BllOPERATIONLOG->Add---START"); ConnectionOpen(); dal.SetDBAccess(GetDBAccess()); dal.Add(model); } catch (Exception ex) { Log.Error("BllOPERATIONLOG->Add---FAILED", ex); throw ex; } finally { ConnectionClose(); Log.Info("BllOPERATIONLOG->Add---finally"); } }
/// <summary> /// 增加一条数据 /// </summary> public void Add(RelayTest.Model.ModelOPERATIONLOG model) { try { Log.Info("DalOPERATIONLOG->Add---START"); StringBuilder strSql = new StringBuilder(); strSql.Append("insert into T_OPERATIONLOG("); strSql.Append("F_ID,F_DATE,F_USER_ID,F_MODULE_NAME"); strSql.Append(") values ("); strSql.Append(":F_ID,:F_DATE,:F_USER_ID,:F_MODULE_NAME"); strSql.Append(") "); OracleParameter[] parameters = { new OracleParameter(":F_ID", OracleType.Number, 18), new OracleParameter(":F_DATE", OracleType.DateTime), new OracleParameter(":F_USER_ID", OracleType.VarChar, 10), new OracleParameter(":F_MODULE_NAME", OracleType.VarChar, 200) }; if (model.F_ID == null) { parameters[0].Value = DBNull.Value; } else { parameters[0].Value = model.F_ID; } if (model.F_DATE == null) { parameters[1].Value = DBNull.Value; } else { parameters[1].Value = model.F_DATE; } if (model.F_USER_ID == null) { parameters[2].Value = DBNull.Value; } else { parameters[2].Value = model.F_USER_ID; } if (model.F_MODULE_NAME == null) { parameters[3].Value = DBNull.Value; } else { parameters[3].Value = model.F_MODULE_NAME; } ExecuteSql(strSql.ToString(), parameters); } catch (Exception ex) { Log.Error("DalOPERATIONLOG->Add---FAILED", ex); throw ex; } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(RelayTest.Model.ModelOPERATIONLOG model) { try { Log.Info("DalOPERATIONLOG->Update---START"); StringBuilder strSql = new StringBuilder(); strSql.Append("update T_OPERATIONLOG set "); strSql.Append(" F_ID = :F_ID , "); strSql.Append(" F_DATE = :F_DATE , "); strSql.Append(" F_USER_ID = :F_USER_ID , "); strSql.Append(" F_MODULE_NAME = :F_MODULE_NAME "); strSql.Append(" where F_ID=:F_ID "); OracleParameter[] parameters = { new OracleParameter(":F_ID", OracleType.Number, 18), new OracleParameter(":F_DATE", OracleType.DateTime), new OracleParameter(":F_USER_ID", OracleType.VarChar, 10), new OracleParameter(":F_MODULE_NAME", OracleType.VarChar, 200) }; if (model.F_ID == null) { parameters[0].Value = DBNull.Value; } else { parameters[0].Value = model.F_ID; } if (model.F_DATE == null) { parameters[1].Value = DBNull.Value; } else { parameters[1].Value = model.F_DATE; } if (model.F_USER_ID == null) { parameters[2].Value = DBNull.Value; } else { parameters[2].Value = model.F_USER_ID; } if (model.F_MODULE_NAME == null) { parameters[3].Value = DBNull.Value; } else { parameters[3].Value = model.F_MODULE_NAME; } int rows = ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } } catch (Exception ex) { Log.Error("DalOPERATIONLOG->Update---FAILED", ex); throw ex; } }