public Dictionary<int, OperateLog> GetAllOperateLogs(ref string errMessage)
{
Database db = DatabaseFactory.CreateDatabase();
errMessage = "";
var list = new Dictionary<int, OperateLog>();
try
{
DataSet ds = OperateLogDataAccess.GetAllOperateLogs(db);
OperateLog operateLog;
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
operateLog = new OperateLog(ds.Tables[0].Rows[i]);
list.Add(operateLog.Id, operateLog);
}
return list;
}
catch (Exception ex)
{
errMessage = ex.Message + ex.StackTrace;
Logger.Error("Error Message:" + ex.Message + " Trace:" + ex.StackTrace);
return null;
}
}
private void simpleButton1AddCamera_Click(object sender, EventArgs e)
{
int cameraid;
cameraid = int.Parse(treeList1DecoderCamera.FocusedNode.Tag.ToString().Split(';')[0]);
switch(Opt1)
{
case Util.OptionSelect.Decoder:
int id= DecoderBusiness.Instance.InsertCamera(ref errMessage, DecoderID, cameraid);
if (-1==id)
{
XtraMessageBox.Show("对不起，您添加的摄像头已经被其他的解码器使用，请另选");
}
else
{
OperateLog ol = new OperateLog
{
HappenTime = DateTime.Now,
OperateTypeId = (int)(OperateLogTypeId.CameraAddInDecoder),
OperateTypeName = OperateLogTypeName.CameraAddInDecoder,
Content = id.ToString(),
OperateUserName = MainForm.CurrentUser.UserName,
ClientUserName = MainForm.CurrentUser.UserName,
ClientUserId = MainForm.CurrentUser.UserId
};
OperateLogBusiness.Instance.Insert(ref errMessage, ol);
}
break;
case Util.OptionSelect.Recognizer:
int recognizerid = RecognizerBusiness.Instance.InsertCamera(ref errMessage, RecognizerID, cameraid);
if (-1 == recognizerid)
{
XtraMessageBox.Show("对不起，您添加的摄像头已经被其他的识别器使用，请另选");
}
else
{
OperateLog ol = new OperateLog
{
HappenTime = DateTime.Now,
OperateTypeId = (int)(OperateLogTypeId.CameraAddInRecognizer),
OperateTypeName = OperateLogTypeName.CameraAddInRecognizer,
Content = recognizerid.ToString(),
OperateUserName = MainForm.CurrentUser.UserName,
ClientUserName = MainForm.CurrentUser.UserName,
ClientUserId = MainForm.CurrentUser.UserId
};
OperateLogBusiness.Instance.Insert(ref errMessage, ol);
}
break;
}
Close();
Dispose();
}
private void buttonOK_Click(object sender, EventArgs e)
{
string errMessage = "";
if (!dxValidationProvider1.Validate())
{
return;
}
var ui = new UserInfo
{
UserName = textEditUserName.Text,
Password = textEditPassword.Text,
CreateDateTime = DateTime.Now,
UserTypeName = comboBoxEditUserType.Text,
UserTypeId = comboBoxEditUserType.Text == "管理员" ? 1 : 2
};
switch (userMode)
{
case UserMode.Add:
UserBusiness.Instance.Insert(ref errMessage, ui);
ui = UserBusiness.Instance.GetUserInfo(ref errMessage, ui.UserName);
OperateLog ol = new OperateLog
{
HappenTime = DateTime.Now,
OperateTypeId = (int)(OperateLogTypeId.UserAdd),
OperateTypeName = OperateLogTypeName.UserAdd,
Content = ui.ToString(),
OperateUserName = MainForm.CurrentUser.UserName,
ClientUserName = MainForm.CurrentUser.UserName,
ClientUserId = MainForm.CurrentUser.UserId
};
OperateLogBusiness.Instance.Insert(ref errMessage, ol);
break;
case UserMode.UPDATE:
UserBusiness.Instance.UpdatePassword(ref errMessage, userInfo.UserId, textEditPassword.Text);
OperateLogBusiness.Instance.Insert(ref errMessage, new OperateLog
{
HappenTime = DateTime.Now,
OperateTypeId = (int)(OperateLogTypeId.UserUpdate),
OperateTypeName = OperateLogTypeName.SynGroupUpdate,
Content = ui.ToString(),
OperateUserName = MainForm.CurrentUser.UserName,
ClientUserName = MainForm.CurrentUser.UserName,
ClientUserId = MainForm.CurrentUser.UserId
});
break;
default:
break;
}
Close();
Dispose();
}
public static int Insert(Database db, OperateLog operateLog)
{
StringBuilder sbField = new StringBuilder();
StringBuilder sbValue = new StringBuilder();
sbField.Append("INSERT INTO OperateLog(");
sbValue.Append("values(");
sbField.Append("GroupID");
sbValue.AppendFormat("{0}", operateLog.GroupId);
sbField.Append(",DeviceID");
sbValue.AppendFormat(",{0}", operateLog.DeviceId);
sbField.Append(",CameraId");
sbValue.AppendFormat(",{0}", operateLog.CameraId);
sbField.Append(",Happentime");
sbValue.AppendFormat(",'{0}'", operateLog.HappenTime);
sbField.Append(",operatetypeid");
sbValue.AppendFormat(",{0}", operateLog.OperateTypeId);
sbField.Append(",operatetypename");
sbValue.AppendFormat(",'{0}'", operateLog.OperateTypeName);
sbField.Append(",content");
sbValue.AppendFormat(",'{0}'", operateLog.Content);
sbField.Append(",operateusername");
sbValue.AppendFormat(",'{0}'", operateLog.OperateUserName);
sbField.Append(",clientusername");
sbValue.AppendFormat(",'{0}'", operateLog.ClientUserName);
sbField.Append(",clientuserid)");
sbValue.AppendFormat(",{0})", operateLog.ClientUserId);
string cmdText = sbField.ToString() + " " + sbValue.ToString();
try
{
cmdText = cmdText.Replace("\r\n", "");
return db.ExecuteNonQuery(CommandType.Text, cmdText);
}
catch (Exception ex)
{
throw ex;
}
}
public int Insert(ref string errMessage, OperateLog operateLog)
{
Database db = DatabaseFactory.CreateDatabase();
errMessage = "";
try
{
return OperateLogDataAccess.Insert(db, operateLog);
}
catch (Exception ex)
{
errMessage = ex.Message + ex.StackTrace;
Logger.Error("Error Message:" + ex.Message + " Trace:" + ex.StackTrace);
return -1;
}
}
/// <summary>
/// 增加识别器
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void simpleButtonOk_Click(object sender, EventArgs e)
{
if (!dxValidationProvider1.Validate())
{
return;
}
RecognizerInfo ri = new RecognizerInfo();
ri.Id = Id;
ri.Name = textEditname.Text;
ri.Port = int.Parse(textEditport.Text);
ri.Ip = textEditIp.Text;
ri.MaxRecogNumber = int.Parse(textEditmax.Text);
if (comboBoxEdit_Type.Text == "Event")
ri.RecogType = (int)E_Type.E_Event;
if (comboBoxEdit_Type.Text == "Vehicle")
ri.RecogType = (int)E_Type.E_Vehicle;
if (comboBoxEdit_Type.Text == "Face")
ri.RecogType = (int)E_Type.E_Face;
switch (Opt)
{
case Util.Operateion.Add:
RecognizerBusiness.Instance.Insert(ref errMessage, ri);
OperateLog ol = new OperateLog
{
HappenTime = DateTime.Now,
OperateTypeId = (int)(OperateLogTypeId.RecognizerAdd),
OperateTypeName = OperateLogTypeName.RecognizerAdd,
Content = ri.ToString(),
Id = ri.Id,
OperateUserName = MainForm.CurrentUser.UserName,
ClientUserName = MainForm.CurrentUser.UserName,
ClientUserId = MainForm.CurrentUser.UserId
};
OperateLogBusiness.Instance.Insert(ref errMessage, ol);
break;
case Util.Operateion.Update:
ri = RecognizerBusiness.Instance.GetRecognizerInfoByRecognizerId(ref errMessage,Id);
ri.Name = textEditname.Text;
ri.Port = int.Parse(textEditport.Text);
ri.Ip = textEditIp.Text;
ri.MaxRecogNumber = int.Parse(textEditmax.Text);
Id = RecognizerBusiness.Instance.Update(ref errMessage, ri);
OperateLogBusiness.Instance.Insert(ref errMessage, new OperateLog
{
HappenTime = DateTime.Now,
OperateTypeId = (int)(OperateLogTypeId.RecognizerUpdate),
OperateTypeName = OperateLogTypeName.RecognizerUpdate,
Content = ri.ToString(),
Id = ri.Id,
OperateUserName = MainForm.CurrentUser.UserName,
ClientUserName = MainForm.CurrentUser.UserName,
ClientUserId = MainForm.CurrentUser.UserId
});
break;
case Util.Operateion.Delete:
break;
default:
break;
}
Close();
Dispose();
}
private void AddDecoderButton(object sender, EventArgs e)
{
if (!dxValidationProvider1.Validate())
{
return;
}
//string errMessage = "";
DecoderInfo di = new DecoderInfo();
di.id = Id;
di.Name = textEditname.Text;
di.Port = int.Parse(textEditport.Text);
di.Ip = textEditIp.Text;
di.MaxDecodeChannelNo = int.Parse(textEditmax.Text);
switch(Opt)
{
case Util.Operateion.Add:
DecoderBusiness.Instance.Insert(ref errMessage, di);
OperateLog ol = new OperateLog
{
HappenTime = DateTime.Now,
OperateTypeId = (int)(OperateLogTypeId.DecoderAdd),
OperateTypeName = OperateLogTypeName.DecoderAdd,
Content = di.ToString(),
Id = di.id,
OperateUserName = MainForm.CurrentUser.UserName,
ClientUserName = MainForm.CurrentUser.UserName,
ClientUserId = MainForm.CurrentUser.UserId
};
OperateLogBusiness.Instance.Insert(ref errMessage, ol);
break;
case Util.Operateion.Update:
di = DecoderBusiness.Instance.GetDecoderInfoByDecoderId(ref errMessage, Id);
di.Name = textEditname.Text;
di.Port = int.Parse(textEditport.Text);
di.Ip = textEditIp.Text;
di.MaxDecodeChannelNo = int.Parse(textEditmax.Text);
Id = DecoderBusiness.Instance.Update(ref errMessage, di);
OperateLogBusiness.Instance.Insert(ref errMessage, new OperateLog
{
HappenTime = DateTime.Now,
OperateTypeId = (int)(OperateLogTypeId.DecoderUpdate),
OperateTypeName = OperateLogTypeName.DecoderUpdate,
Content = di.ToString(),
Id = di.id,
OperateUserName = MainForm.CurrentUser.UserName,
ClientUserName = MainForm.CurrentUser.UserName,
ClientUserId = MainForm.CurrentUser.UserId
});
break;
case Util.Operateion.Delete:
break;
default:
break;
}
Close();
Dispose();
}