public int WriteOperateLog(OperateLogObject operateLogObject)
{
operateLogObject.UserID = Tool.InspectBitLength(operateLogObject.UserID, 20, "");
operateLogObject.IPAddress = Tool.InspectBitLength(operateLogObject.IPAddress, 40, "");
operateLogObject.ClientType = Tool.InspectLength(operateLogObject.ClientType, 10);
operateLogObject.OperateData = Tool.InspectLength(operateLogObject.OperateData, 1000);
operateLogObject.OperateKey = Tool.InspectLength(operateLogObject.OperateKey, 100);
operateLogObject.OperateMethod = Tool.InspectLength(operateLogObject.OperateMethod, 100);
operateLogObject.OperateTable = Tool.InspectLength(operateLogObject.OperateTable, 100);
LogHelpDataAccess logHelpDataAccess = new LogHelpDataAccess(this.dbkey);
return(logHelpDataAccess.InsertOperateLog(operateLogObject));
}
internal int InsertOperateLog(OperateLogObject InsertObject)
{
string text = " Insert into OperateLog(";
string text2 = "";
DbParameter[] dBParms = Service.GetIDBparm("sql").GetDBParms(9);
if (InsertObject.ClientType != null)
{
text += "ClientType,";
text2 += "@ClientType,";
dBParms[0] = Service.GetIDBparm("sql").GetDBParm("@ClientType", InsertObject.ClientType);
}
if (InsertObject.UserID != null)
{
text += "UserID,";
text2 += "@UserID,";
dBParms[1] = Service.GetIDBparm("sql").GetDBParm("@UserID", InsertObject.UserID);
}
if (InsertObject.IPAddress != null)
{
text += "IPAddress,";
text2 += "@IPAddress,";
dBParms[2] = Service.GetIDBparm("sql").GetDBParm("@IPAddress", InsertObject.IPAddress);
}
if (InsertObject.OperateData != null)
{
text += "OperateData,";
text2 += "@OperateData,";
dBParms[3] = Service.GetIDBparm("sql").GetDBParm("@OperateData", InsertObject.OperateData);
}
if (InsertObject.OperateKey != null)
{
text += "OperateKey,";
text2 += "@OperateKey,";
dBParms[4] = Service.GetIDBparm("sql").GetDBParm("@OperateKey", InsertObject.OperateKey);
}
if (InsertObject.OperateMethod != null)
{
text += "OperateMethod,";
text2 += "@OperateMethod,";
dBParms[5] = Service.GetIDBparm("sql").GetDBParm("@OperateMethod", InsertObject.OperateMethod);
}
if (InsertObject.OperateTable != null)
{
text += "OperateTable,";
text2 += "@OperateTable,";
dBParms[6] = Service.GetIDBparm("sql").GetDBParm("@OperateTable", InsertObject.OperateTable);
}
if (InsertObject.OperatetyeGuid.HasValue)
{
text += "OperatetyeGuid,";
text2 += "@OperatetyeGuid,";
dBParms[7] = Service.GetIDBparm("sql").GetDBParm("@OperatetyeGuid", InsertObject.OperatetyeGuid);
}
text += "Operatetype,";
text2 += "@Operatetype,";
dBParms[8] = Service.GetIDBparm("sql").GetDBParm("@Operatetype", InsertObject.Operatetype.ToString());
text = text.Substring(0, text.Length - 1);
text2 = text2.Substring(0, text2.Length - 1);
text = text + ")values(" + text2 + ")";
return(this.ish.ExecuteNonQuery(DBEnum.log, CommandType.Text, text, dBParms));
}
