public static int Delete(TaskLevelEntity entity)
{
string sql = "DELETE FROM TASK_LEVEL WHERE T_ID = " + entity.ID;
IMapper map = DatabaseInstance.Instance();
return(map.Execute(sql));
}
private void gridView1_FocusedRowChanged(object sender, DevExpress.XtraGrid.Views.Base.FocusedRowChangedEventArgs e)
{
TaskLevelEntity entity = this.gridView1.GetFocusedRow() as TaskLevelEntity;
if (entity == null)
{
return;
}
//this.cboTaskType.EditValue = entity.TaskType;
//this.editTaskLevel.EditValue = entity.TaskLevel;
this.editBeginTime.EditValue = entity.BeginTime;
this.editEndTime.EditValue = entity.EndTime;
}
public static int Insert(TaskLevelEntity entity)
{
string sql = "INSERT TASK_LEVEL(TASK_TYPE, TASK_LEVEL, BEGIN_TIME, END_TIME, DIFF_VALUE) " +
"VALUES(@TaskType, @TaskLevel, @BeginTime, @EndTime, @DiffValue)";
IMapper map = DatabaseInstance.Instance();
return(map.Execute(sql, new
{
TaskType = entity.TaskType,
TaskLevel = entity.TaskLevel,
BeginTime = entity.BeginTime,
EndTime = entity.EndTime,
DiffValue = entity.DiffValue
}));
}
public static int Update(TaskLevelEntity entity)
{
string sql = "UPDATE TASK_LEVEL SET TASK_TYPE = @TaskType, TASK_LEVEL = @TaskLevel, " +
"BEGIN_TIME = @BeginTime, END_TIME = @EndTime, DIFF_VALUE = @DiffValue " +
"WHERE T_ID = @ID ";
IMapper map = DatabaseInstance.Instance();
return(map.Execute(sql, new
{
TaskType = entity.TaskType,
TaskLevel = entity.TaskLevel,
BeginTime = entity.BeginTime,
EndTime = entity.EndTime,
DiffValue = entity.DiffValue,
ID = entity.ID
}));
}
/// <summary>
/// 任务池管理(新)--任务优先级管理--保存insert
/// </summary>
/// <param name="entity"></param>
/// <returns></returns>
public bool InsertZLM(TaskLevelEntity entity)
{
try
{
#region 请求数据
System.Text.StringBuilder loStr = new System.Text.StringBuilder();
loStr.Append("taskType=").Append(entity.TaskType).Append("&");
loStr.Append("taskLevel=").Append(entity.TaskLevel).Append("&");
loStr.Append("beginTime=").Append(entity.BeginTime).Append("&");
loStr.Append("endTime=").Append(entity.EndTime).Append("&");
loStr.Append("diffValue=").Append(entity.DiffValue);
string jsonQuery = WebWork.SendRequest(loStr.ToString(), WebWork.URL_InsertZLM);
if (string.IsNullOrEmpty(jsonQuery))
{
MsgBox.Warn(WebWork.RESULT_NULL);
//LogHelper.InfoLog(WebWork.RESULT_NULL);
return(false);
}
#endregion
#region 正常错误处理
Sucess bill = JsonConvert.DeserializeObject <Sucess>(jsonQuery);
if (bill == null)
{
MsgBox.Warn(WebWork.JSON_DATA_NULL);
return(false);
}
if (bill.flag != 0)
{
MsgBox.Warn(bill.error);
return(false);
}
#endregion
return(true);
}
catch (Exception ex)
{
MsgBox.Err(ex.Message);
}
return(false);
}
/// <summary>
/// 任务优先级-
/// </summary>
/// <returns></returns>
public List <TaskLevelEntity> Select()
{
List <TaskLevelEntity> list = new List <TaskLevelEntity>();
try
{
#region 请求数据
System.Text.StringBuilder loStr = new System.Text.StringBuilder();
//loStr.Append("beginTime=").Append(beginTime).Append("&");
//loStr.Append("endTime=").Append(endTime);
string jsonQuery = WebWork.SendRequest(string.Empty, WebWork.URL_SelectZLM);
if (string.IsNullOrEmpty(jsonQuery))
{
MsgBox.Warn(WebWork.RESULT_NULL);
//LogHelper.InfoLog(WebWork.RESULT_NULL);
return(list);
}
#endregion
#region 正常错误处理
JsonSelectZLM bill = JsonConvert.DeserializeObject <JsonSelectZLM>(jsonQuery);
if (bill == null)
{
MsgBox.Warn(WebWork.JSON_DATA_NULL);
return(list);
}
if (bill.flag != 0)
{
MsgBox.Warn(bill.error);
return(list);
}
#endregion
#region 赋值数据
foreach (JsonSelectZLMResult jbr in bill.result)
{
TaskLevelEntity asnEntity = new TaskLevelEntity();
#region 0-10
asnEntity.DiffValue = Convert.ToInt32(jbr.diffValue);
asnEntity.TaskLevel = Convert.ToInt32(jbr.taskLevel);
asnEntity.TaskType = Convert.ToInt32(jbr.taskType);
asnEntity.TaskTypeDesc = jbr.taskTypeDesc;
asnEntity.ID = Convert.ToInt32(jbr.tId);
#endregion
#region
try
{
if (!string.IsNullOrEmpty(jbr.beginTime))
{
asnEntity.BeginTime = Convert.ToDateTime(jbr.beginTime);
}
}
catch (Exception msg)
{
MsgBox.Warn(msg.Message);
//LogHelper.errorLog("FrmVehicle+QueryNotRelatedBills", msg);
}
#endregion
#region
try
{
if (!string.IsNullOrEmpty(jbr.endTime))
{
asnEntity.EndTime = Convert.ToDateTime(jbr.endTime);
}
}
catch (Exception msg)
{
MsgBox.Warn(msg.Message);
//LogHelper.errorLog("FrmVehicle+QueryNotRelatedBills", msg);
}
#endregion
list.Add(asnEntity);
}
return(list);
#endregion
}
catch (Exception ex)
{
MsgBox.Err(ex.Message);
}
return(list);
}
private void CreateTaskLevel()
{
List <BaseCodeEntity> codeList = this.bindingSource2.DataSource as List <BaseCodeEntity>;
try
{
DateTime beginTime = ConvertUtil.ToDatetime(this.editBeginTime.EditValue);
DateTime endTime = ConvertUtil.ToDatetime(this.editEndTime.EditValue);
int diffValue = 0;
if (beginTime > endTime)
{
diffValue = ConvertUtil.ToInt(Math.Abs((endTime.AddDays(1) - beginTime).TotalMinutes));
endTime = endTime.AddDays(1);
}
else
{
diffValue = ConvertUtil.ToInt(Math.Abs((beginTime - endTime).TotalMinutes));
}
if (beginTime == endTime)
{
MsgBox.Warn("<开始时段>不能等于<结束时段>！");
return;
}
if (codeList == null || codeList.Count == 0)
{
MsgBox.Warn("未找到可保存的数据！");
return;
}
if (codeList.Exists(u => string.IsNullOrEmpty(u.Level)))
{
MsgBox.Warn("还有未选择优先级的任务，请全部选择优先级！");
return;
}
// 验证在同一时段内，不允许出现优先级相等的情况
bool state = false;
for (int i = 0; i < codeList.Count; i++)
{
BaseCodeEntity entityI = codeList[i];
for (int j = 1; j < codeList.Count; j++)
{
BaseCodeEntity entityJ = codeList[j];
if (entityI.ItemValue != entityJ.ItemValue && entityI.Level == entityJ.Level)
{
state = true;
break;
}
}
}
if (state)
{
MsgBox.Warn("在同一时段内，不允许出现优先级相等的情况!");
return;
}
// 在同一时段内，不允许出现两个相同的任务类型
List <TaskLevelEntity> taskLevel = this.bindingSource1.DataSource as List <TaskLevelEntity>;
state = taskLevel.Find(u => (beginTime.TimeOfDay < u.EndTime.TimeOfDay)) != null;
if (state)
{
MsgBox.Warn("该时段内已有相同的任务类型!");
return;
}
if (MsgBox.AskOK("是否确认保存?") != DialogResult.OK)
{
return;
}
List <TaskLevelEntity> taskLevelList = new List <TaskLevelEntity>();
foreach (BaseCodeEntity baseCode in codeList)
{
TaskLevelEntity entity = new TaskLevelEntity()
{
TaskType = ConvertUtil.ToInt(baseCode.ItemValue),
TaskLevel = ConvertUtil.ToInt(baseCode.Level),
BeginTime = beginTime,
EndTime = endTime,
DiffValue = ConvertUtil.ToInt(Math.Abs((beginTime - endTime).TotalMinutes))
};
taskLevelList.Add(entity);
}
if (InsertFor(taskLevelList) > 0)
{
this.LoadData();
}
else
{
MsgBox.Warn("创建任务优先级失败!");
}
}
catch (Exception ex)
{
MsgBox.Err("错误:" + ex.Message);
}
}
