/// <summary>
/// 将计划表绑定到计划列表GridView控件
/// </summary>
/// <param name="dtPlans">数据源</param>
private void BindgvPlans(DataTable dtPlans)
{
try
{
DataTable dtActions = (DataTable)ViewState["dtActions"];
//扩展计划表，增加一个字段"Title"，保存操作的名称，也是计划的名称
DataTable dtTemp = dtPlans.Copy();
dtTemp.Columns.Add("Title");
foreach (DataRow drTemp in dtTemp.Rows)
{
int actionId = SystemDataExtension.GetInt16(drTemp, "ActionID");
DataRow drAction = ActionBLL.GetActionByID(actionId, dtActions);
drTemp.BeginEdit();
drTemp["Title"] = drAction["Title"];
drTemp.EndEdit();
}
dtTemp.AcceptChanges();
//绑定分级计划列表
DataTable dtLPlans = TaskBLL.GetTasksWithLevel(dtTemp, "Title", "ParentID", false);
gvPlans.DataSource = dtLPlans;
gvPlans.DataBind();
}
catch (Exception ex)
{
lbErr.Text = ex.ToString();
}
}
public ActionResult CheckActionIDWhenAddFunction(int?actionID, bool functionIsMenu)
{
if (functionIsMenu)
{
return(Json(true));
}
return(Json(!ActionBLL.CheckActionIDHadBeenLinkedWithFunction(actionID.Value)));
}
public ActionResult DeleteAction(FormCollection fc)
{
string[] ids = fc["actid"].Split(',');
var result = ActionBLL.DeleteActions(ids);
base.DoLog(Model.OperationTypeEnum.Delete, result, fc["actid"]);
return(Json(result));
}
protected void submit_Click(object sender, EventArgs e)
{
var md5 = Utility.MD5(password.Value).ToLower();
var name = username.Value.Trim();
name = name.Length >= 30 ? name.Substring(0, 30) : name;
using (var bll = new AccountBLL())
{
var account = bll.Find(f => f.Code.Equals(name));
if (null != account)
{
using (var action = new ActionBLL())
{
if (!account.Password.ToLower().Equals(md5))
{
SaveHistory(new TB_AccountHistory()
{
Account = account.id,
ActionId = action.Find(f => f.Name.Equals("Login")).id,
ObjectA = Utility.GetClientBrowser(Request) + ", login fail: password error"
});
ShowNotification("../default.aspx", "Login fail: password is not correct.", false);
}
else if (account.Locked == true)
{
SaveHistory(new TB_AccountHistory()
{
Account = account.id,
ActionId = action.Find(f => f.Name.Equals("Login")).id,
ObjectA = Utility.GetClientBrowser(Request) + ", login blocked: account has locked"
});
ShowNotification("../default.aspx", "You cannot login: your account has been locked.", false);
}
else
{
SaveHistory(new TB_AccountHistory()
{
Account = account.id,
ActionId = action.Find(f => f.Name.Equals("Login")).id,
ObjectA = Utility.GetClientBrowser(Request)
});
updateAccount(account);
}
}
}
else
{
ShowNotification("../default.aspx", "Login fail: no account exist like your input.", false);
}
}
}
public ActionResult EditActionInfo(int id)
{
var obj = ActionBLL.GetActionByID(id);
if (obj.DataResult == null)
{
return(Content(obj.Message));
}
int areaID = obj.DataResult.AreaID;
obj.DataResult.AreasSelectList = new SelectList(AreaBLL.GetAreas(), "ID", "AreaName", areaID);
obj.DataResult.ControllersSelectList = new SelectList(ControllerBLL.GetControllersByAreaID(areaID), "ID", "ControllerName");
return(PartialView("_EditActionInfo", obj.DataResult));
}
public ActionResult EditActionInfo(Asiatek.Model.ActionEditModel model)
{
if (ModelState.IsValid)
{
var result = ActionBLL.ModifyAction(model, base.UserIDForLog);
base.DoLog(Model.OperationTypeEnum.Edit, result, "ActionID:" + model.ID);
return(Json(result));
}
else
{
int areaID = model.AreaID;
model.AreasSelectList = new SelectList(AreaBLL.GetAreas(), "ID", "AreaName", areaID);
model.ControllersSelectList = new SelectList(ControllerBLL.GetControllersByAreaID(areaID), "ID", "ControllerName", model.ControllerID);
return(PartialView("_EditActionInfo", model));
}
}
public ActionResult EditFunctionInfo(FunctionEditModel model)
{
if (ModelState.IsValid)
{
var result = FunctionBLL.EditFunction(model, base.UserIDForLog);
base.DoLog(OperationTypeEnum.Edit, result, "FunctionID:" + model.ID);
return(Json(result));
}
else
{
if (model.FunctionIsMenu)
{
var aList = AreaBLL.GetAreas();
model.AreasSelectList = new SelectList(aList, "ID", "AreaName");
var cList = ControllerBLL.GetControllersByAreaID(aList.First().ID);
model.ControllersSelectList = new SelectList(cList, "ID", "ControllerName");
var actionList = ActionBLL.GetActionsByControllerID(cList.First().ID);
model.ActionsSelectList = actionList.ToSelectList(m => GetSelectListItem(m.ID, m.ActionName));
var parentFuncList = FunctionBLL.GetFunctions();
model.ParentFunctionsSelectList = new SelectList(FunctionBLL.GetFunctions(model.ID), "ID", "FunctionName");
return(PartialView("_EditFunctionInfo", model));
}
else
{
int areaID = model.AreaID.Value;
int controllerID = model.ControllerID.Value;
int?parentID = model.ParentID;
int actionID = model.ActionID.Value;
model.IsTopFunction = model.ParentID == null;
model.AreasSelectList = new SelectList(AreaBLL.GetAreas(), "ID", "AreaName", areaID);
model.ControllersSelectList = new SelectList(ControllerBLL.GetControllersByAreaID(areaID), "ID", "ControllerName", controllerID);
model.ActionsSelectList = ActionBLL.GetActionsByControllerID(controllerID).ToSelectList(m => GetSelectListItem(m.ID, m.ActionName));
model.ParentFunctionsSelectList = new SelectList(FunctionBLL.GetFunctions(model.ID), "ID", "FunctionName");
return(PartialView("_EditFunctionInfo", model));
}
}
}
/// <summary>
/// 动作设定
/// </summary>
public ActionResult ActionSetting()
{
ActionSettingModel model = new ActionSettingModel();
var areaList = AreaBLL.GetAreas();
model.AreasSelectList = areaList.ToSelectListWithAll(m => GetSelectListItem(m.ID, m.AreaName));
var ctrList = ControllerBLL.GetControllers();
model.ControllersSelectList = ctrList.ToSelectListWithAll(m => GetSelectListItem(m.ID, m.ControllerName));
model.SearchPage = 1;
model.AreaID = -1;
model.ControllerID = -1;
model.PagedDatas = ActionBLL.GetPagedActions(model, PageSize);
return(PartialView("_ActionSetting", model));
}
public ActionResult AddActionInfo(ActionAddModel model)
{
if (ModelState.IsValid)
{
var result = ActionBLL.AddAction(model, base.UserIDForLog);
base.DoLog(Model.OperationTypeEnum.Add, result, "ActionName:" + model.ActionName);
return(Json(result));
}
else
{
int areaID = model.AreaID;
var aList = AreaBLL.GetAreas();
model.AreasSelectList = new SelectList(aList, "ID", "AreaName", areaID);
var cList = ControllerBLL.GetControllersByAreaID(areaID);
model.ControllersSelectList = new SelectList(cList, "ID", "ControllerName", model.ControllerID);
return(PartialView("_AddActionInfo", model));
}
}
//public ActionResult AddFunctionInfo()
//{
// var aList = AreaBLL.GetAreas();
// FunctionAddModel model = new FunctionAddModel();
// model.AreasSelectList = new SelectList(aList, "ID", "AreaName");
// var cList = ControllerBLL.GetControllersByAreaID(aList.First().ID);
// model.ControllersSelectList = new SelectList(cList, "ID", "ControllerName");
// var actionList = ActionBLL.GetActionsByControllerID(cList.First().ID);
// model.ActionsSelectList = new SelectList(actionList, "ID", "ActionName");
// var parentFuncList = FunctionBLL.GetFunctions();
// model.ParentFunctionsSelectList = new SelectList(parentFuncList, "ID", "FunctionName");
// return PartialView("_AddFunctionInfo", model);
//}
public ActionResult AddFunctionInfo()
{
var aList = AreaBLL.GetAreas();
FunctionAddModel model = new FunctionAddModel();
model.OrderIndex = Int32.MaxValue;//默认新增的处于最后的位置
model.AreasSelectList = new SelectList(aList, "ID", "AreaName");
var cList = ControllerBLL.GetControllersByAreaID(aList.First().ID);
model.ControllersSelectList = new SelectList(cList, "ID", "ControllerName");
var actionList = ActionBLL.GetActionsByControllerID(cList.First().ID);
//model.ActionsSelectList = actionList.ToSelectListWithEmpty(m => GetSelectListItem(m.ID, m.ActionName));
model.ActionsSelectList = actionList.ToSelectList(m => GetSelectListItem(m.ID, m.ActionName));
var parentFuncList = FunctionBLL.GetFunctions();
model.ParentFunctionsSelectList = new SelectList(parentFuncList, "ID", "FunctionName", parentFuncList.First().ID);
return(PartialView("_AddFunctionInfo", model));
}
private ActionResult GetActionPagedGridPV(ActionSettingModel model)
{
model.PagedDatas = ActionBLL.GetPagedActions(model, PageSize);
return(PartialView("_ActionPagedGrid", model));
}
public ActionResult CheckAddActionNameExists(string actionName, int controllerID)
{
return(Json(!ActionBLL.CheckActionNameExists(actionName, controllerID)));
}
public ActionResult GetActionDDLByControllerID(int controllerID)
{
var list = ActionBLL.GetActionsByControllerID(controllerID);
return(Json(list, JsonRequestBehavior.AllowGet));
}
//public ActionResult EditFunctionInfo(int id)
//{
// string message = string.Empty;
// var obj = FunctionBLL.GetFunctionByID(id);
// if (obj.DataResult == null)
// {
// return Content(obj.Message);
// }
// var model = obj.DataResult;
// model.IsTopFunction = model.ParentID == null;
// model.AreasSelectList = new SelectList(AreaBLL.GetAreas(), "ID", "AreaName");
// model.ControllersSelectList = new SelectList(ControllerBLL.GetControllersByAreaID(model.AreaID), "ID", "ControllerName");
// model.ActionsSelectList = new SelectList(ActionBLL.GetActionsByControllerID(model.ControllerID), "ID", "ActionName");
// model.ParentFunctionsSelectList = new SelectList(FunctionBLL.GetFunctions(), "ID", "FunctionName");
// return PartialView("_EditFunctionInfo", model);
//}
//[HttpPost, ValidateAntiForgeryToken]
//public ActionResult EditFunctionInfo(FunctionEditModel model)
//{
// if (ModelState.IsValid)
// {
// var result = FunctionBLL.EditFunction(model);
// base.DoLog(OperationTypeEnum.Edit, result, "FunctionID:" + model.ID);
// return Json(result);
// }
// else
// {
// int areaID = model.AreaID;
// int controllerID = model.ControllerID;
// int? parentID = model.ParentID;
// int actionID = model.ActionID;
// model.IsTopFunction = model.ParentID == null;
// model.AreasSelectList = new SelectList(AreaBLL.GetAreas(), "ID", "AreaName", areaID);
// model.ControllersSelectList = new SelectList(ControllerBLL.GetControllersByAreaID(areaID), "ID", "ControllerName", controllerID);
// model.ActionsSelectList = new SelectList(ActionBLL.GetActionsByControllerID(controllerID), "ID", "ActionName", actionID);
// model.ParentFunctionsSelectList = new SelectList(FunctionBLL.GetFunctions(), "ID", "FunctionName", parentID);
// return PartialView("_EditFunctionInfo", model);
// }
//}
public ActionResult EditFunctionInfo(int id)
{
var obj = FunctionBLL.GetFunctionByID(id);
if (obj.DataResult == null)
{
return(Content(obj.Message));
}
var model = obj.DataResult;
model.IsTopFunction = model.ParentID == null;
model.FunctionIsMenu = model.ActionID == null;
var areas = AreaBLL.GetAreas();
model.AreasSelectList = new SelectList(areas, "ID", "AreaName");
List <ControllerDDLModel> controllers;
if (!model.AreaID.HasValue)//没有与Action绑定过的功能
{
controllers = ControllerBLL.GetControllersByAreaID(areas.First().ID);
}
else
{
controllers = ControllerBLL.GetControllersByAreaID(model.AreaID.Value);
}
model.ControllersSelectList = new SelectList(controllers, "ID", "ControllerName");
List <ActionDDLModel> actions;
if (!model.ControllerID.HasValue)//没有与Action绑定过的功能
{
actions = ActionBLL.GetActionsByControllerID(controllers.First().ID);
}
else
{
actions = ActionBLL.GetActionsByControllerID(model.ControllerID.Value);
}
model.ActionsSelectList = actions.ToSelectList(m => GetSelectListItem(m.ID, m.ActionName));
var parentFunctions = FunctionBLL.GetFunctions(model.ID);
//如果是顶级功能，则没有上级功能，所以默认选一个
if (model.IsTopFunction)
{
var tempPid = parentFunctions.First().ID;
model.ParentFunctionsSelectList = new SelectList(parentFunctions, "ID", "FunctionName", tempPid);
model.ParentID = tempPid;
}
else
{
model.ParentFunctionsSelectList = new SelectList(parentFunctions, "ID", "FunctionName", model.ParentID);
}
return(PartialView("_EditFunctionInfo", model));
}
/// <summary>
/// 读取GridView数据到数据表
/// </summary>
/// <param name="gv">GridView控件ID</param>
/// <param name="userId">用户ID</param>
/// <returns></returns>
public string SaveGVToDB()
{
int userId = GetUserId;
string errMsg = "";
DataSet dsMyAction = (DataSet)ViewState["myActions"];
DataTable dtMyAction = dsMyAction.Tables[0].Clone();
int m = 0, n = 0;//m修改个数，n新建个数
for (int rCount = 0; rCount < gvActions.Rows.Count; rCount++)
{
GridViewRow gvr = gvActions.Rows[rCount];
//IsMy 是插入01，更新11，还是未设置0或1
HiddenField hdfisMy = (HiddenField)gvr.FindControl("hdfIsMy");
string isMy = hdfisMy.Value;
//没有修改则不进行遍历
if (isMy == "0" || isMy == "1")
{
continue;
}
DataRow dr = dtMyAction.NewRow();
//用户ID UserID
dr["UserID"] = userId;
//操作ID ActionID
HiddenField hdfacId = (HiddenField)gvr.FindControl("hdfacId");
dr["ActionID"] = hdfacId.Value;
DropDownList ddlFrequency = (DropDownList)gvr.FindControl("ddlFrequency");
if (ddlFrequency.SelectedItem.Value != "0")
{
dr["FrequencyID"] = ddlFrequency.SelectedItem.Value;
}
DropDownList ddlShiDuan = (DropDownList)gvr.FindControl("ddlShiDuan");
if (ddlShiDuan.SelectedItem.Value != "0")
{
dr["ShiduanID"] = ddlShiDuan.SelectedItem.Value;
}
TextBox tbmin = (TextBox)gvr.FindControl("tbMin");
if (tbmin.Text != "")
{
dr["MinDuring"] = tbmin.Text;
}
TextBox tbmax = (TextBox)gvr.FindControl("tbMax");
if (tbmax.Text != "")
{
dr["MaxDuring"] = tbmax.Text;
}
TextBox tbduring = (TextBox)gvr.FindControl("tbNormal");
if (tbduring.Text != "")
{
dr["NormalDuring"] = tbduring.Text;
}
TextBox tbHealthy = (TextBox)gvr.FindControl("tbHealthy");
if (tbHealthy.Text != "")
{
dr["Healthy"] = tbHealthy.Text;
}
TextBox tbInteraction = (TextBox)gvr.FindControl("tbInteraction");
if (tbInteraction.Text != "")
{
dr["Interaction"] = tbInteraction.Text;
}
TextBox tbProbability = (TextBox)gvr.FindControl("tbProbability");
if (tbProbability.Text != "")
{
dr["Probability"] = tbProbability.Text;
}
TextBox tbDesc = (TextBox)gvr.FindControl("tbDesc");
if (tbDesc.Text != "")
{
dr["Description"] = tbDesc.Text;
}
if (isMy == "01")//新设置，做插入操作
{
dr["Created"] = DateTime.Now;
dr["CreatedBy"] = userId;
dr["Modified"] = DateTime.Now;
dr["ModifiedBy"] = userId;
ActionBLL.OptionUserAction(isMy, dr, ref errMsg);
m++;
}
else if (isMy == "11")//非新设置，做更新操作
{
dr["Modified"] = DateTime.Now;
dr["ModifiedBy"] = userId;
ActionBLL.OptionUserAction(isMy, dr, ref errMsg);
n++;
}
if (errMsg != "")
{
break;
}
}
if (m != 0 || n != 0)
{
errMsg += string.Format(";修改操作设置{0}个,新增操作设置{1}个", m, n);
}
else
{
errMsg += ";本次执行未设置任何操作";
}
return(errMsg);
}
