public JsonResult AddTable(ScadaTableModel model)
{
model.CreateTime = DateTime.Now;
model.CreateUserId = Operator.UserId;
model.UpdateTime = DateTime.Now;
model.UpdateUserId = Operator.UserId;
model.ColNum = 26;
List <int> colWidths = new List <int>();
List <string> colTitles = new List <string>();
for (int i = 0; i < model.ColNum; i++)
{
colTitles.Add(ExcelConvert.ToName(i));
colWidths.Add(120);
}
model.ColimnWidths = string.Join(",", colWidths.ToArray());
model.ColumnTitles = string.Join(",", colTitles.ToArray());
model.RowNum = 100;
model.FilterRule = "";
int id = 0;
bool isres = TableService.Insert(model, out id);
if (isres)
{
TableUserRoleService.DeleteByWhere(" where TableId=" + id);
if (model.RoleUserID != null)
{
string[] users = model.RoleUserID.Split(',');
for (int i = 0; i < users.Length; i++)
{
ScadaTableUserRoleModel role = new ScadaTableUserRoleModel();
role.CreateTime = DateTime.Now;
role.CreateTime = DateTime.Now;
role.CreateUserId = Operator.UserId;
role.UpdateTime = DateTime.Now;
role.UpdateUserId = Operator.UserId;
role.SortCode = i + 1;
role.TableId = id;
role.UserId = int.Parse(users[i]);
TableUserRoleService.Insert(role);
}
}
}
var result = isres ? SuccessTip("添加成功") : ErrorTip("添加失败");
return(Json(result));
}
public JsonResult EditTable(ScadaTableModel model)
{
var sourmodel = TableService.GetById(model.Id);
model.CreateTime = DateTime.Now;
model.CreateUserId = Operator.UserId;
model.UpdateTime = DateTime.Now;
model.UpdateUserId = Operator.UserId;
model.RowNum = 100;
model.ColNum = 26;
if (sourmodel != null)
{
model.ColimnWidths = sourmodel.ColimnWidths;
model.ColumnTitles = sourmodel.ColumnTitles;
}
bool isres = TableService.UpdateById(model);
if (isres)
{
TableUserRoleService.DeleteByWhere(" where TableId=" + model.Id);
if (model.RoleUserID != null)
{
string[] users = model.RoleUserID.Split(',');
for (int i = 0; i < users.Length; i++)
{
ScadaTableUserRoleModel role = new ScadaTableUserRoleModel();
role.CreateTime = DateTime.Now;
role.CreateTime = DateTime.Now;
role.CreateUserId = Operator.UserId;
role.UpdateTime = DateTime.Now;
role.UpdateUserId = Operator.UserId;
role.SortCode = i + 1;
role.TableId = model.Id;
role.UserId = int.Parse(users[i]);
TableUserRoleService.Insert(role);
}
}
}
var result = isres ? SuccessTip("保存成功") : ErrorTip("保存失败");
return(Json(result));
}
