/// <summary> /// 向数据库中插入一条新记录。 /// </summary> /// <param name="FOUNDERPCB_OPERATION_LOG">founderpcb_operation_log对象</param> /// <returns>新插入记录的编号</returns> public int Add(FOUNDERPCB_OPERATION_LOG founderpcb_operation_log) { #region 调用SQL存储过程进行添加 string sql = "sp_FOUNDERPCB_OPERATION_LOG_Add"; ///存储过程名 SqlParameter[] parameters = { new SqlParameter("@returnID", SqlDbType.Int), new SqlParameter("@userAD", SqlDbType.VarChar), ///new SqlParameter("@RKEY",SqlDbType.Decimal,9), new SqlParameter("@RKEY", SqlDbType.Float), new SqlParameter("@PRO_RKEY", SqlDbType.Decimal, 9), new SqlParameter("@MODULE_ID", SqlDbType.VarChar, 10), new SqlParameter("@MODULE_NAME", SqlDbType.VarChar, 30), new SqlParameter("@ACTION", SqlDbType.VarChar, 30), new SqlParameter("@MEMO", SqlDbType.VarChar, 1000), new SqlParameter("@DO_DATE", SqlDbType.DateTime, 8) }; parameters[0].Value = 0; parameters[0].Direction = ParameterDirection.InputOutput; parameters[1].Value = this.userAD; parameters[2].Direction = ParameterDirection.InputOutput; parameters[2].Value = founderpcb_operation_log.RKEY; parameters[3].Value = founderpcb_operation_log.PRO_RKEY; parameters[4].Value = founderpcb_operation_log.MODULE_ID; parameters[5].Value = founderpcb_operation_log.MODULE_NAME; parameters[6].Value = founderpcb_operation_log.ACTION; parameters[7].Value = founderpcb_operation_log.MEMO; if (founderpcb_operation_log.DO_DATE == DateTime.Parse("1900-1-1") || founderpcb_operation_log.DO_DATE == DateTime.Parse("0001-1-1")) { parameters[8].Value = null; } else { parameters[8].Value = founderpcb_operation_log.DO_DATE; } #endregion #region 数据库操作 int result = 0; try { dbHelper.ExecuteCommandProc(sql, parameters); result = int.Parse(parameters[0].Value.ToString()); founderpcb_operation_log.RKEY = decimal.Parse(parameters[2].Value.ToString()); //log.Info("FID="+this.factoryID.ToString()+";userAD="+this.userAD+";FOUNDERPCB_OPERATION_LOG,save successful"); } catch (Exception e) { ///message ID result = 2; // log.Error("FID="+this.factoryID.ToString()+";userAD="+this.userAD+";"+e.Message,e); } #endregion return(result); }
///<sumary> /// 通过SQL语句获取数据对象 ///</sumary> /// <param name="sqlWhere">sqlWhere参数条件</param> ///<returns>IList<FOUNDERPCB_OPERATION_LOG>数据集合</returns> public IList <FOUNDERPCB_OPERATION_LOG> FindBySql(string sqlWhere) { #region SQL string sql = @"select isNull(rkey,0) as rkey , isNull(pro_rkey,0) as pro_rkey , isNull(module_id,'') as module_id , isNull(module_name,'') as module_name , isNull(action,'') as action , isNull(memo,'') as memo , isNull(do_date,'1900-1-1') as do_date from FOUNDERPCB_OPERATION_LOG with (nolock)" ; if (sqlWhere.Length > 0) { sql = sql + " where " + sqlWhere; } #endregion IList <FOUNDERPCB_OPERATION_LOG> resultList = new List <FOUNDERPCB_OPERATION_LOG>(); #region 操作 try { using (DataTable tb = dbHelper.GetDataSet(sql)) { foreach (DataRow row in tb.Rows) { FOUNDERPCB_OPERATION_LOG founderpcb_operation_log = new FOUNDERPCB_OPERATION_LOG(); founderpcb_operation_log.RKEY = decimal.Parse(row["RKEY"].ToString()); founderpcb_operation_log.PRO_RKEY = decimal.Parse(row["PRO_RKEY"].ToString()); founderpcb_operation_log.MODULE_ID = row["MODULE_ID"].ToString(); founderpcb_operation_log.MODULE_NAME = row["MODULE_NAME"].ToString(); founderpcb_operation_log.ACTION = row["ACTION"].ToString(); founderpcb_operation_log.MEMO = row["MEMO"].ToString(); founderpcb_operation_log.DO_DATE = DateTime.Parse(row["DO_DATE"].ToString()); resultList.Add(founderpcb_operation_log); } } } catch (Exception e) { log.Info("FID=" + this.factoryID.ToString() + ";userAD=" + this.userAD + ";FindBySql function:" + e.Message, e); throw e; } #endregion return(resultList); }
public int Add(SqlCommand cmd, SqlConnection conn, SqlTransaction trans, FOUNDERPCB_OPERATION_LOG founderpcb_operation_log) { // Validate input if (founderpcb_operation_log == null) { return(0); } return(founderpcb_operation_logDal.Add(cmd, conn, trans, founderpcb_operation_log)); }
/// <summary> /// 向数据库中插入一条新记录。 /// </summary> /// <param name="FOUNDERPCB_OPERATION_LOG">founderpcb_operation_log对象</param> /// <returns>新插入记录的编号</returns> public int Add(FOUNDERPCB_OPERATION_LOG founderpcb_operation_log) { // Validate input if (founderpcb_operation_log == null) { return(0); } return(founderpcb_operation_logDal.Add(founderpcb_operation_log)); }
public void Update(SqlCommand cmd, SqlConnection conn, SqlTransaction trans, FOUNDERPCB_OPERATION_LOG founderpcb_operation_log) { // Validate input if (founderpcb_operation_log == null) { return; } founderpcb_operation_logDal.Update(cmd, conn, trans, founderpcb_operation_log); }
///<sumary> /// 通过主键获取数据对象 ///</sumary> /// <param name="RKEY">rkey</param> ///<returns>FOUNDERPCB_OPERATION_LOG对象</returns> public FOUNDERPCB_OPERATION_LOG getFOUNDERPCB_OPERATION_LOGByRKEY(decimal rkey) { #region SQL string sql = @"select top 1 isNull(rkey,0) as rkey , isNull(pro_rkey,0) as pro_rkey , isNull(module_id,'') as module_id , isNull(module_name,'') as module_name , isNull(action,'') as action , isNull(memo,'') as memo , isNull(do_date,'1900-1-1') as do_date from FOUNDERPCB_OPERATION_LOG with (nolock) where RKEY='{0}'" ; #endregion ///定义返回对象 FOUNDERPCB_OPERATION_LOG founderpcb_operation_log = null; #region 数据库操作 try { founderpcb_operation_log = new FOUNDERPCB_OPERATION_LOG(); using (DataTable tb = dbHelper.GetDataSet(string.Format(sql, rkey))) { foreach (DataRow row in tb.Rows) { founderpcb_operation_log.RKEY = decimal.Parse(row["RKEY"].ToString()); founderpcb_operation_log.PRO_RKEY = decimal.Parse(row["PRO_RKEY"].ToString()); founderpcb_operation_log.MODULE_ID = row["MODULE_ID"].ToString(); founderpcb_operation_log.MODULE_NAME = row["MODULE_NAME"].ToString(); founderpcb_operation_log.ACTION = row["ACTION"].ToString(); founderpcb_operation_log.MEMO = row["MEMO"].ToString(); founderpcb_operation_log.DO_DATE = DateTime.Parse(row["DO_DATE"].ToString()); } } } catch (Exception e) { //Console.WriteLine(e.Message); log.Info("FID=" + this.factoryID.ToString() + ";userAD=" + this.userAD + ";get function:" + e.Message, e); } #endregion return(founderpcb_operation_log); }
///<sumary> /// 删除 ///</sumary> /// <param name="founderpcb_operation_log">对象</param> ///<returns>返回INT类型号, 0为操作成功, 非0操作失败.</returns> public int Delete(FOUNDERPCB_OPERATION_LOG founderpcb_operation_log) { #region 调用SQL存储过程进行删除 string sql = "sp_FOUNDERPCB_OPERATION_LOG_Delete"; //========================= SqlParameter[] parameters = { new SqlParameter("@returnID", SqlDbType.Int), new SqlParameter("@userAD", SqlDbType.VarChar), new SqlParameter("@RKEY", SqlDbType.Decimal, 9) }; parameters[0].Value = 1; parameters[0].Direction = ParameterDirection.InputOutput; parameters[1].Value = this.userAD; parameters[2].Value = founderpcb_operation_log.RKEY; //========================= #endregion #region 数据库操作 int result = 0; try { dbHelper.ExecuteCommandProc(sql, parameters); result = int.Parse(parameters[0].Value.ToString()); // log.Info("FID="+this.factoryID.ToString()+";userAD="+this.userAD+";FOUNDERPCB_OPERATION_LOG,delete successful"); } catch (Exception e) { result = 2; log.Info("FID=" + this.factoryID.ToString() + ";userAD=" + this.userAD + ";" + e.Message, e); } #endregion return(result); }
public void Update(SqlCommand cmd, SqlConnection conn, SqlTransaction trans, FOUNDERPCB_OPERATION_LOG founderpcb_operation_log) { #region 创建语法 StringBuilder strSql = new StringBuilder(); strSql.Append("update FOUNDERPCB_OPERATION_LOG set "); strSql.Append("PRO_RKEY=@PRO_RKEY,"); strSql.Append("MODULE_ID=@MODULE_ID,"); strSql.Append("MODULE_NAME=@MODULE_NAME,"); strSql.Append("ACTION=@ACTION,"); strSql.Append("MEMO=@MEMO,"); strSql.Append("DO_DATE=@DO_DATE"); strSql.Append(" where RKEY=@RKEY "); SqlParameter[] parameters = { new SqlParameter("@RKEY", SqlDbType.Decimal, 9), new SqlParameter("@PRO_RKEY", SqlDbType.Decimal, 9), new SqlParameter("@MODULE_ID", SqlDbType.VarChar, 10), new SqlParameter("@MODULE_NAME", SqlDbType.VarChar, 30), new SqlParameter("@ACTION", SqlDbType.VarChar, 30), new SqlParameter("@MEMO", SqlDbType.VarChar, 1000), new SqlParameter("@DO_DATE", SqlDbType.DateTime, 8) }; parameters[0].Value = founderpcb_operation_log.RKEY; parameters[1].Value = founderpcb_operation_log.PRO_RKEY; parameters[2].Value = founderpcb_operation_log.MODULE_ID; parameters[3].Value = founderpcb_operation_log.MODULE_NAME; parameters[4].Value = founderpcb_operation_log.ACTION; parameters[5].Value = founderpcb_operation_log.MEMO; if (founderpcb_operation_log.DO_DATE == DateTime.Parse("1900-1-1") || founderpcb_operation_log.DO_DATE == DateTime.Parse("0001-1-1")) { parameters[6].Value = null; } else { parameters[6].Value = founderpcb_operation_log.DO_DATE; } #endregion #region 操作 if (conn.State != ConnectionState.Open) { conn.Open(); } cmd.Connection = conn; cmd.CommandText = strSql.ToString(); cmd.Transaction = trans; cmd.CommandType = CommandType.Text;//cmdType; if (parameters != null) { foreach (SqlParameter parameter in parameters) { if ((parameter.Direction == ParameterDirection.InputOutput || parameter.Direction == ParameterDirection.Input) && (parameter.Value == null)) { parameter.Value = DBNull.Value; } cmd.Parameters.Add(parameter); } } cmd.ExecuteNonQuery(); cmd.Parameters.Clear(); #endregion }
public int Add(SqlCommand cmd, SqlConnection conn, SqlTransaction trans, FOUNDERPCB_OPERATION_LOG founderpcb_operation_log) { #region 创建SQL语法 StringBuilder strSql = new StringBuilder(); strSql.Append("insert into FOUNDERPCB_OPERATION_LOG("); strSql.Append("PRO_RKEY,MODULE_ID,MODULE_NAME,ACTION,MEMO,DO_DATE"); strSql.Append(" ) values ("); strSql.Append("@PRO_RKEY,@MODULE_ID,@MODULE_NAME,@ACTION,@MEMO,@DO_DATE"); strSql.Append(");select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@PRO_RKEY", SqlDbType.Decimal, 9), new SqlParameter("@MODULE_ID", SqlDbType.VarChar, 10), new SqlParameter("@MODULE_NAME", SqlDbType.VarChar, 30), new SqlParameter("@ACTION", SqlDbType.VarChar, 30), new SqlParameter("@MEMO", SqlDbType.VarChar, 1000), new SqlParameter("@DO_DATE", SqlDbType.DateTime, 8) }; parameters[0].Value = founderpcb_operation_log.PRO_RKEY; parameters[1].Value = founderpcb_operation_log.MODULE_ID; parameters[2].Value = founderpcb_operation_log.MODULE_NAME; parameters[3].Value = founderpcb_operation_log.ACTION; parameters[4].Value = founderpcb_operation_log.MEMO; if (founderpcb_operation_log.DO_DATE == DateTime.Parse("1900-1-1") || founderpcb_operation_log.DO_DATE == DateTime.Parse("0001-1-1")) { parameters[5].Value = null; } else { parameters[5].Value = founderpcb_operation_log.DO_DATE; } #endregion #region 操作 if (conn.State != ConnectionState.Open) { conn.Open(); } cmd.Connection = conn; cmd.CommandText = strSql.ToString(); cmd.Transaction = trans; cmd.CommandType = CommandType.Text;//cmdType; if (parameters != null) { foreach (SqlParameter parameter in parameters) { if ((parameter.Direction == ParameterDirection.InputOutput || parameter.Direction == ParameterDirection.Input) && (parameter.Value == null)) { parameter.Value = DBNull.Value; } cmd.Parameters.Add(parameter); } } int indentity = 0; object obj = cmd.ExecuteScalar(); cmd.Parameters.Clear(); if ((Object.Equals(obj, null)) || (Object.Equals(obj, System.DBNull.Value))) { indentity = 0; } else { indentity = int.Parse(obj.ToString()); } #endregion return(indentity); }
private static void WriteFile(string s_msg, string s_mode, Exception ex) { DBHelper dbhelper = new DBHelper(0); FOUNDERPCB_OPERATION_LOG loginfo = new FOUNDERPCB_OPERATION_LOG(); FOUNDERPCB_OPERATION_LOGBLL logbll = new FOUNDERPCB_OPERATION_LOGBLL(dbhelper); string s_proc_name1 = "", s_proc_name2 = "", s_proc_name3 = "", s_proc_name4 = ""; string s_proc_dll_name1 = "", s_proc_dll_name2 = "", s_proc_dll_name3 = "", s_proc_dll_name4 = ""; string s_user = ""; string s_write = ""; try { if (s_msg.IndexOf("COMMIT TRANSACTION 请求没有对应的 BEGIN TRANSACTION") >= 0) { return; } if (s_msg.IndexOf("SQL 语法:COMMIT TRAN") > 0) { return; } s_proc_dll_name1 = (new StackTrace()).GetFrame(2).GetMethod().ReflectedType.FullName; //类名 s_proc_name1 = (new StackTrace()).GetFrame(2).GetMethod().Name; //方法 s_proc_dll_name2 = (new StackTrace()).GetFrame(3).GetMethod().ReflectedType.FullName; //类名 s_proc_name2 = (new StackTrace()).GetFrame(3).GetMethod().Name; //方法 s_proc_dll_name3 = (new StackTrace()).GetFrame(4).GetMethod().ReflectedType.FullName; //类名 s_proc_name3 = (new StackTrace()).GetFrame(4).GetMethod().Name; //方法 s_proc_dll_name4 = (new StackTrace()).GetFrame(5).GetMethod().ReflectedType.FullName; //类名 s_proc_name4 = (new StackTrace()).GetFrame(5).GetMethod().Name; //方法 s_user = GlobalVal.UserInfo.LoginName; } catch { } if (ex != null) { //获得字节数组 s_write = s_write + "域 帐 号:" + s_user + GlobalVal.UserInfo.IP + "\r\n"; s_write = s_write + "日志类名:" + s_proc_dll_name1 + "中的" + s_proc_name1 + "\r\n"; s_write = s_write + " " + s_proc_dll_name2 + "中的" + s_proc_name2 + "\r\n"; s_write = s_write + " " + s_proc_dll_name3 + "中的" + s_proc_name3 + "\r\n"; s_write = s_write + " " + s_proc_dll_name4 + "中的" + s_proc_name4 + "\r\n"; s_write = s_write + "日志级别:" + s_mode + "\r\n"; if (ex == null) { s_write = s_write + "日 志 类:\r\n"; } else { s_write = s_write + "日 志 类:" + ex.StackTrace.ToString().Trim() + "\r\n"; } s_write = s_write + "返回信息:" + s_msg; } else { s_write = "返回信息:" + s_msg; } loginfo.PRO_RKEY = 0; loginfo.MODULE_ID = ""; loginfo.MODULE_NAME = ""; loginfo.ACTION = s_proc_name1; loginfo.MEMO = s_write; loginfo.DO_DATE = Func.GetNowDate(); logbll.Add(loginfo); }