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