//角色授权
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 void RaiseSelectedDataRowEvent(DataRowModel data)
{
RoutedEventArgs args = new SelectedDataRowEventArgs()
{
Data = data
};
args.RoutedEvent = SelectedDataRowEvent;
RaiseEvent(args);
}
protected override bool DoAdd(RequestData data)
{
DataRowModel rmodel = SqlModel.SelectAll().From(DB.BASDICTYPE).Where(BASDICTYPE.ID == data.Get("TypeId")).ExecToRowModel();
BASDICModel model = new BASDICModel();
model.TITLE = data.Get("Title");
model.CODE = data.Get("Code");
model.TYPEID = data.Get("TypeId").ToInt32();
model.TYPECODE = rmodel[BASDICTYPE.CODE] == null ? "" : rmodel[BASDICTYPE.CODE].ToString();
model.SORTNO = data.Get("SortNo").ToInt32();
model.STATUS = data.Get("Status").ToInt32();
model.REMARK = data.Get("Remark");
return(model.Insert());
}
public static DataSetModel ToDisplayableDataSet(this DataSetModel dataSetModel)
{
var set = new DataSetModel();
foreach (var row in dataSetModel.Values)
{
var rowModel = new DataRowModel(row.Id, new Dictionary <string, object>());
foreach (var item in row.Values)
{
rowModel.Values.Add(item.Key, GenericObjectToDisplayable(item.Value));
}
set.Values.Add(rowModel);
}
return(set);
}
/// <summary>
/// 获取自动生成编号[默认后面4位自增流水，可重载]
/// </summary>
/// <param name="tran"></param>
/// <param name="prefix">标识符</param>
/// <param name="format">格式</param>
/// <param name="custom">自定义数据</param>
/// <returns></returns>
protected string GetFormNo(string prefix, string format, string custom)
{
try
{
DateTime now = DateTime.Now;
string curDateYMD = now.ToString(format);
int curSNValue = 0;
DataRowModel r = SqlModel.SelectAll().From(DB.BASFORMNO)
.Where(BASFORMNO.PREFIX == prefix & BASFORMNO.RULEVALUE == curDateYMD).ExecToRowModel();
//如果没有数据，则先添加一条初始数据
if (r == null || r.Count == 0)
{
curSNValue = 1;
BASFORMNOModel fnModel = new BASFORMNOModel();
fnModel.PREFIX = prefix;
fnModel.RULENAME = format;// "yyyyMMdd";
fnModel.RULEVALUE = now.ToString(fnModel.RULENAME);
fnModel.SNBIT = 4;
fnModel.SNVALUE = curSNValue;
//fnModel.TSNO = tsno;
fnModel.Insert();
//fnModel.Inserting(tran);
}
else
{
curSNValue = r[BASFORMNO.SNVALUE].ToInt32() + 1;
BASFORMNOModel fModel = new BASFORMNOModel();
fModel.SNVALUE = curSNValue;
fModel.Update(BASFORMNO.ID == r[BASFORMNO.ID].ToInt32());
//fModel.Updating(tran, BASFORMNO.ID == r[BASFORMNO.ID].ToInt32());
}
string billNumber = string.Format("{0}{1}{2}"
, curDateYMD
, custom
, curSNValue.ToString().PadLeft(4, '0'));
return(billNumber);
}
catch (Exception ex)
{
throw ex;
}
}
public ActionResult Login(RequestData data)
{
LangHelper.Name = "zhcn";
if (string.IsNullOrEmpty(data.Get("lang")) == false)
{
LangHelper.Name = data.Get("lang");
}
LangHelper.Instance.Read(base.Request, true);
base.Response.ContentType = "text/plain";
var userName = data.Get("username");
var password = data.Get("password");
var validateCode = data.Get("validateCode");
var saveCookieDays = data.GetInt("savedays");
var msg = new { success = false, message = "用户名不存在！" };
SqlModel model = SqlModel.SelectAll().From(DB.BASUSER).Where(BASUSER.USERNAME == userName);
DataRowModel uModel = model.ExecToRowModel();
if (uModel != null)
{
if (uModel[BASUSER.ISDISABLED].ToInt32() == 1)
{
bool flag = CurrentUser.Login(userName, password);
if (flag == true)
{
msg = new { success = true, message = "登录成功！" };
DataInitor.Log = new LogData();
base.AddLog(LogType.UserLogin, "用户登录成功");
}
else
{
msg = new { success = false, message = "用户名或密码输入错误！" };
}
}
else
{
msg = new { success = false, message = "用户已经被禁用，请联系管理员！" };
}
}
return(Json(msg));
}
public void SelectedDataRow(DataRowModel dataRowModel)
{
BusinessEventManager.RaiseOnSelectedEntity(Entity, dataRowModel.Id);
}
