/// <summary>
/// 根据关键字段的值获取记录
/// </summary>
/// <param name="Id">关键字段的值</param>
/// <returns>符合查询条件的记录</returns>
public TestEFCodeFirst GetTestEFCodeFirstById(string Id)
{
using (ITestEFCodeFirstBLL TestEFCodeFirstBLL = BLLContainer.Resolve <ITestEFCodeFirstBLL>())
{
TestEFCodeFirst model = TestEFCodeFirstBLL.GetFirstOrDefault(Id);
return(model);
}
}
/// <summary>
/// 修改
/// </summary>
/// <param name="mTestEFCodeFirst">模型</param>
/// <returns>是否成功</returns>
public bool UpdateTestEFCodeFirst(TestEFCodeFirst mTestEFCodeFirst)
{
if (mTestEFCodeFirst == null)
{
return(false);
}
using (ITestEFCodeFirstBLL TestEFCodeFirstBLL = BLLContainer.Resolve <ITestEFCodeFirstBLL>())
{
return(TestEFCodeFirstBLL.Update(mTestEFCodeFirst));
}
}
/// <summary>
/// 按照关键字段删除
/// </summary>
/// <param name="Id">关键字段</param>
/// <returns>是否成功</returns>
public bool DelTestEFCodeFirst(string Id)
{
using (ITestEFCodeFirstBLL TestEFCodeFirstBLL = BLLContainer.Resolve <ITestEFCodeFirstBLL>())
{
try
{
TestEFCodeFirst item = TestEFCodeFirstBLL.GetFirstOrDefault(Id);
return(TestEFCodeFirstBLL.Delete(item));
}
catch { return(false); }
}
}
/// <summary>
/// 按照关键字段删除
/// </summary>
/// <param name="Ids">关键字段数组</param>
/// <returns>是否成功</returns>
public bool DelTestEFCodeFirsts(string[] Ids)
{
using (ITestEFCodeFirstBLL TestEFCodeFirstBLL = BLLContainer.Resolve <ITestEFCodeFirstBLL>())
{
try
{
List <TestEFCodeFirst> entitys = new List <TestEFCodeFirst>();
foreach (string id in Ids)
{
TestEFCodeFirst item = TestEFCodeFirstBLL.GetFirstOrDefault(id);
entitys.Add(item);
}
return(TestEFCodeFirstBLL.Delete(entitys));
}
catch { return(false); }
}
}
private async void button3_Click(object sender, RoutedEventArgs e)
{
//Add
TestEFCodeFirst test = new TestEFCodeFirst()
{
PKNO = tbIn.Text,
USER_NAME = "Test1",
PASSWORD = "******",
};
string value = SafeConverter.JsonSerializeObject(test);
TestEFCodeFirst test2 = SafeConverter.JsonDeserializeObject <TestEFCodeFirst>(value);
bool m_SysUser = (await testEfCodeFirstF.Add(test));
tbResult.Text = SafeConverter.JsonSerializeObject(m_SysUser);
}
public ActionResult CheckLogin(string username, string password, string code)
{
try
{
if (Session["nfine_session_verifycode"].IsEmpty() || Md5.md5(code.ToLower(), 16) != Session["nfine_session_verifycode"].ToString())
{
throw new Exception("验证码错误，请重新输入");
}
PLMService test = new PLMService();
TestEFCodeFirst codeFirst = test.GetTestEFCodeFirsts($"USER_NAME = '{username}'").FirstOrDefault();
if (codeFirst != null)
{
string mdPassword = Md5.md5(codeFirst.PASSWORD, 32).ToLower();
if (mdPassword == password)
{
//codeFirst.REMARK = "登陆成功 " + DateTime.Now.ToString();
test.UpdateTestEFCodeFirst(codeFirst);
OperatorModel operatorModel = new OperatorModel();
operatorModel.UserId = codeFirst.PKNO;
operatorModel.UserCode = codeFirst.USER_NAME;
operatorModel.UserName = codeFirst.USER_NAME;
operatorModel.CompanyId = codeFirst.PKNO;
operatorModel.DepartmentId = codeFirst.PKNO;
operatorModel.RoleId = codeFirst.PKNO;
operatorModel.LoginIPAddress = Net.Ip;
operatorModel.LoginIPAddressName = Net.GetLocation(operatorModel.LoginIPAddress);
operatorModel.LoginTime = DateTime.Now;
operatorModel.LoginToken = DESEncrypt.Encrypt(Guid.NewGuid().ToString());
operatorModel.IsSystem = true;
OperatorProvider.Provider.AddCurrent(operatorModel);
return(Content(new AjaxResult {
state = ResultType.success.ToString(), message = "登录成功。"
}.ToJson()));
}
else
{
return(Content(new AjaxResult {
state = ResultType.error.ToString(), message = "密码错误！"
}.ToJson()));
}
}
else
{
return(Content(new AjaxResult {
state = ResultType.error.ToString(), message = "用户不存在！"
}.ToJson()));
}
}
catch (Exception ex)
{
return(Content(new AjaxResult {
state = ResultType.error.ToString(), message = ex.Message
}.ToJson()));
}
// LogEntity logEntity = new LogEntity();
// logEntity.F_ModuleName = "系统登录";
// logEntity.F_Type = DbLogType.Login.ToString();
// try
// {
// if (Session["nfine_session_verifycode"].IsEmpty() || Md5.md5(code.ToLower(), 16) != Session["nfine_session_verifycode"].ToString())
// {
// throw new Exception("验证码错误，请重新输入");
// }
// UserEntity userEntity = new UserApp().CheckLogin(username, password);
// if (userEntity != null)
// {
// OperatorModel operatorModel = new OperatorModel();
// operatorModel.UserId = userEntity.F_Id;
// operatorModel.UserCode = userEntity.F_Account;
// operatorModel.UserName = userEntity.F_RealName;
// operatorModel.CompanyId = userEntity.F_OrganizeId;
// operatorModel.DepartmentId = userEntity.F_DepartmentId;
// operatorModel.RoleId = userEntity.F_RoleId;
// operatorModel.LoginIPAddress = Net.Ip;
// operatorModel.LoginIPAddressName = Net.GetLocation(operatorModel.LoginIPAddress);
// operatorModel.LoginTime = DateTime.Now;
// operatorModel.LoginToken = DESEncrypt.Encrypt(Guid.NewGuid().ToString());
// if (userEntity.F_Account == "admin")
// {
// operatorModel.IsSystem = true;
// }
// else
// {
// operatorModel.IsSystem = false;
// }
// OperatorProvider.Provider.AddCurrent(operatorModel);
// logEntity.F_Account = userEntity.F_Account;
// logEntity.F_NickName = userEntity.F_RealName;
// logEntity.F_Result = true;
// logEntity.F_Description = "登录成功";
// new LogApp().WriteDbLog(logEntity);
// }
// return Content(new AjaxResult { state = ResultType.success.ToString(), message = "登录成功。" }.ToJson());
// }
// catch (Exception ex)
// {
// logEntity.F_Account = username;
// logEntity.F_NickName = username;
// logEntity.F_Result = false;
// logEntity.F_Description = "登录失败，" + ex.Message;
// new LogApp().WriteDbLog(logEntity);
// return Content(new AjaxResult { state = ResultType.error.ToString(), message = ex.Message }.ToJson());
// }
}
