/// <summary>
/// 删除
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void ActivityFiling_OnItemCommand(object sender, GridCommandEventArgs e)
{
var item = e.Item as GridDataItem;
if (item != null)
{
var personnelInfo = CurrentSession.Personnel.Get();
var dataItem = item;
var id = new Guid(dataItem.GetDataKeyValue("ID").ToString());
if (e.CommandName == "Delete")
{
var result = _activityFilingWrite.UpdateFilingState(id, (int)ActivityFilingState.FilingDelete);
if (result)
{
var activityOperateLogModel = new ActivityOperateLogModel
{
OperatePersonnelID = personnelInfo.PersonnelId,
OperatePersonnelName = personnelInfo.RealName,
OperateDate = DateTime.Now,
ActivityFilingID = id
};
activityOperateLogModel.Description = "[" + activityOperateLogModel.OperateDate + "]" + activityOperateLogModel.OperatePersonnelName + "删除活动报备单";
_activityOperateLog.InsertLog(activityOperateLogModel);
ActivityFilingRad.Rebind();
}
}
}
}
/// <summary>
/// 添加操作日志
/// </summary>
/// <param name="activityOperateLogModel"></param>
/// <returns></returns>
public bool InsertLog(ActivityOperateLogModel activityOperateLogModel)
{
const string SQL = @"
insert into ActivityOperateLog(ID, ActivityFilingID, OperatePersonnelID, OperatePersonnelName, Description, OperateDate)
values(newid(), @ActivityFilingID, @OperatePersonnelID, @OperatePersonnelName, @Description, @OperateDate)
";
using (SqlConnection conn = Databases.GetSqlConnection(GlobalConfig.ERP_DB_NAME, false))
{
return(conn.Execute(SQL, new {
ActivityFilingID = activityOperateLogModel.ActivityFilingID,
OperatePersonnelID = activityOperateLogModel.OperatePersonnelID,
OperatePersonnelName = activityOperateLogModel.OperatePersonnelName,
Description = activityOperateLogModel.Description,
OperateDate = activityOperateLogModel.OperateDate,
}) > 0);
}
}
protected void LB_Save_OncLick(object sender, EventArgs e)
{
if (!CanSubmit())
{
RAM.Alert("请不要重复提交!");
return;
}
ExecuteSubmit((ctx) =>
{
if (!string.IsNullOrEmpty(RTB_RemarkInput.Text))
{
var personnelInfo = CurrentSession.Personnel.Get();
var activityLogModel = new ActivityOperateLogModel
{
OperatePersonnelID = personnelInfo.PersonnelId,
OperatePersonnelName = personnelInfo.RealName,
OperateDate = DateTime.Now,
ActivityFilingID = new Guid(HF_ActivityFilingID.Value),
Description = "[" + DateTime.Now + personnelInfo.RealName + "]" + RTB_RemarkInput.Text
};
var result = _activityOperateLog.InsertLog(activityLogModel);
if (result)
{
var list = _activityOperateLog.SelectLogModels(new Guid(HF_ActivityFilingID.Value));
RP_Clew.DataSource = list;
RP_Clew.DataBind();
RTB_RemarkInput.Text = "";
}
else
{
ctx.SetFail();
}
}
else
{
RAM.Alert("日志内容不允许为空！");
ctx.SetFail();
}
});
}
