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