//角色授权
private bool RoleAuthorize(string data)
{
JObject jobj = JObject.Parse(data);
DataTableModel dtm = SqlModel.Select(BASBUTTON.ID, BASBUTTON.BUTTONTEXT, BASBUTTON.BUTTONTAG)
.From(DB.BASBUTTON).ExecToTableModel();
var roleId = jobj["roleId"];
var menus = jobj["menus"];
var navs = menus.Where(m => m["buttons"].Count() > 0);
BASROLENAVBTNModel delModel = new BASROLENAVBTNModel();
delModel.Delete(BASROLENAVBTN.ROLEID == roleId.ToString());
using (TranModel tran = new DBTranModel())
{
//BASROLENAVBTNModel delModel = new BASROLENAVBTNModel();
//delModel.Deleting(tran, BASROLENAVBTN.ROLEID == roleId.ToString());
BASROLENAVBTNModel insModel = null;
DataRowModel rm = null;
foreach (var nav in navs)
{
foreach (var btn in nav["buttons"])
{
rm = dtm.Find(m => m[BASBUTTON.BUTTONTAG].ToString() == btn.ToString());
insModel = new BASROLENAVBTNModel();
insModel.ROLEID = roleId.ToString().ToInt32();
insModel.NAVID = nav["navid"].ToString().ToInt32();
insModel.BTNID = rm[BASBUTTON.ID].ToInt32();
insModel.Inserting(tran);
}
}
return(tran.Execute());
}
}
public ActionResult SaveUserRole(RequestData data)
{
bool isSuccess = false;
PostResult result = new PostResult();
string userId = data.Get("userId");
string roleIdString = data.Get("roleIdString");
string[] roleIdArray = roleIdString.Split(',');
BASUSERROLEModel delModel = new BASUSERROLEModel();
result.Success = delModel.Delete(BASUSERROLE.USERID == userId);
using (TranModel tran = new DBTranModel())
{
BASUSERROLEModel insModel = null;
for (int i = 0; i < roleIdArray.Length; i++)
{
string roleId = roleIdArray[i];
if (roleId != "")
{
insModel = new BASUSERROLEModel();
insModel.USERID = userId.ToInt32();
insModel.ROLEID = roleId.ToInt32();
insModel.Inserting(tran);
isSuccess = true;
}
}
bool ret = tran.Execute();
result.Success = isSuccess ? ret : result.Success;
}
return(Json(result));
}
public ActionResult SaveNavButton(RequestData data)
{
PostResult result = new PostResult();
string navId = data.Get("navId");
string btnIdString = data.Get("btnIdString");
string[] btnIdArray = btnIdString.Split(',');
using (TranModel tran = new DBTranModel())
{
BASNAVBTNModel delModel = new BASNAVBTNModel();
delModel.Deleting(tran, BASNAVBTN.NAVID == navId);
BASNAVBTNModel insModel = null;
for (int i = 0; i < btnIdArray.Length; i++)
{
string btnId = btnIdArray[i];
insModel = new BASNAVBTNModel();
insModel.NAVID = navId.ToInt32();
insModel.BTNID = btnId.ToInt32();
insModel.SORTNO = i;
insModel.Inserting(tran);
}
bool ret = tran.Execute();
result.Success = ret;
}
return(Json(result));
}
public ActionResult EditDicType(RequestData data)
{
PostResult result = new PostResult();
using (TranModel tran = new DBTranModel())
{
BASDICTYPEModel model = new BASDICTYPEModel();
model.TITLE = data.Get("Title");
model.CODE = data.Get("Code");
model.SORTNO = data.Get("SortNo").ToInt32();
model.REMARK = data.Get("Remark");
model.Updating(tran, BASDICTYPE.ID == data.Get("Id"));
BASDICModel dmodel = new BASDICModel();
dmodel.TYPECODE = data.Get("Code");
dmodel.Updating(tran, BASDIC.TYPEID == data.Get("Id"));
result.Success = tran.Execute();
}
//result.Success = tran.Execute();
return(Json(result));
}
public ActionResult SaveAlertSetting(string data)
{
var msg = new { success = false, data = "保存失败" };
using (TranModel tran = new DBTranModel())
{
try
{
var jo = JObject.Parse(data);
var cas = jo["cas"].ToObject <T_BASE_COMPANY_ASModel>();
var casi = jo["casi"].ToObject <T_BASE_COMPANY_ASIModel[]>();
var ret = tran.DB.ExecuteByTrans(() =>
{
var count = 0;
var sql = "";
cas.UnMartSet(T_BASE_COMPANY_AS.ID);
if (0 == cas.ID)
{
cas.CREATETIME = DateTime.Now;
cas.CREATEUSER = CurrentUser.UserName;
sql = cas.GetInsertSql();
}
else
{
cas.UPDATETIME = DateTime.Now;
cas.UPDATEUSER = CurrentUser.UserName;
sql = cas.GetUpdateSql(T_BASE_COMPANY_AS.ID == cas.ID, true);
}
count = tran.DB.ExecuteNonQuery4Trans(sql);
if (1 == count)
{
for (var i = 0; i < casi.Length; i++)
{
var si = casi[i];
si.UnMartSet(T_BASE_COMPANY_ASI.ID);
if (0 == si.ID)
{
si.CREATETIME = DateTime.Now;
si.CREATEUSER = CurrentUser.UserName;
sql = si.GetInsertSql();
}
else
{
si.UPDATETIME = DateTime.Now;
si.UPDATEUSER = CurrentUser.UserName;
sql = si.GetUpdateSql(T_BASE_COMPANY_ASI.ID == si.ID, true);
}
count = tran.DB.ExecuteNonQuery4Trans(sql);
if (0 == count)
{
return(false);
}
}
return(true);
}
return(false);
});
msg = new { success = ret, data = ret ? "保存成功" : "保存失败！" };
}
catch (Exception ex) { msg = new { success = false, data = ex.Message }; }
}
return(Json(msg));
}
