public object SaveEmployee(Employee employee)
{
using (var db = new webdevContext())
{
MongoDBServer dBServer = new MongoDBServer();
string msg = "";
bool IsSuccess = true;
var user = db.Employee.Where(a => a.BillId == employee.BillId).FirstOrDefault();
if (user == null)
{
db.Employee.Add(employee);
}
else
{
user.Address = employee.Address;
user.BankCard = employee.BankCard;
user.BankName = employee.BankName;
user.BirthDate = employee.BirthDate;
user.EmployeeType = employee.EmployeeType;
user.EntryDate = employee.EntryDate;
user.IdentityId = employee.IdentityId;
user.Zfbid = employee.Zfbid;
user.Vxid = employee.Vxid;
user.UserName = employee.UserName;
user.UrgentPhone = employee.UrgentPhone;
user.UrgentName = employee.UrgentName;
user.QuitDate = employee.QuitDate;
user.IsOnLine = employee.IsOnLine;
db.Employee.Update(user);
}
var relust = db.SaveChangesAsync();
msg = relust.Exception?.Message;
if (!string.IsNullOrEmpty(msg))
{
IsSuccess = false;
}
if (relust.Result <= 0)
{
IsSuccess = false;
}
if (IsSuccess)
{
if (cache.Exists("EmployeeList").Result)
{
IsSuccess = cache.Remove("EmployeeList").Result;
cache.Remove("EmployeeOnLineList");
}
if (user != null)
{
dBServer.db.GetCollection <Employee>("Employee").ReplaceOne(a => a.BillId == employee.BillId, employee);
cache.Remove("Employee_" + user.BillId);
}
else
{
dBServer.db.GetCollection <Employee>("Employee").InsertOne(employee);
}
}
return(new { IsSuccess = IsSuccess, msg = msg });
}
}
public ActionResult GetFriendList()
{
Byte[] UserByte = HttpContext.Session.Get("user");
int UserId = Library.Other.SerializeToObject <Sysuser>(UserByte).BillId;
using (webdevContext db = new webdevContext())
{
object FriendList = null;
string msg = "";
bool success = true;
try
{
FriendList = (from a in db.Friend
join b in db.Sysuser
on a.FriendId equals b.BillId
where a.UserId == UserId
select new
{
b.BillId,
b.UserName
}).ToList();
// FriendList = db.Friend.Join(db.Sysuser,) Where(a => a.UserId == UserId).ToList();
}
catch (Exception ex)
{
success = false;
msg = ex.Message;
}
return(Json(new { success = success, msg = msg, data = FriendList }));
}
}
public object BaseInfo(int id = 0)
{
using (webdevContext web = new webdevContext())
{
string msg = "";
bool IsSuccess = true;
List <Billmodularinfo> lb = new List <Billmodularinfo>();
try
{
if (id == 0)
{
lb = web.Billmodularinfo.OrderBy(a => a.BillId).ToList();
}
else
{
lb = web.Billmodularinfo.Where(a => a.Id == id).ToList();
}
}
catch (Exception ex)
{
msg = ex.Message;
IsSuccess = false;
}
return(new { msg = msg, IsSuccess = IsSuccess, data = lb });
}
}
public object BaseRemaskSave(string JsonData, string TableName)
{
using (webdevContext web = new webdevContext())
{
try
{
string msg = "";
bool IsSuccess = true;
var list = web.Billtableremask.Where(a => a.BillTableName == TableName);
foreach (var item in list)
{
web.Billtableremask.Remove(item);
}
var json = Library.Other.ObjectToJson <List <Billtableremask> >(JsonData);
foreach (var item in json)
{
web.Billtableremask.Add(item);
}
IsSuccess = web.SaveChanges() > 0;
return(new { IsSuccess = IsSuccess, msg = msg });
}
catch (Exception ex)
{
return(new { IsSuccess = false, msg = ex.Message });
}
}
}
public ActionResult BaseBillSave(Billmodularinfo billmodularinfo)
{
using (webdevContext webdev = new webdevContext())
{
string msg = "";
bool IsSuccess = true;
try
{
var model = webdev.Billmodularinfo.Where(a => a.Id == billmodularinfo.Id).FirstOrDefault();
if (model == null)
{
webdev.Billmodularinfo.Add(billmodularinfo);
}
else
{
model.BillId = billmodularinfo.BillId;
model.BillTable = billmodularinfo.BillTable;
model.Islist = billmodularinfo.Islist;
model.Modulardtnametext = billmodularinfo.Modulardtnametext;
model.ModularInfoId = billmodularinfo.ModularInfoId;
model.ModularInfoname = billmodularinfo.ModularInfoname;
model.ModularInfoulr = billmodularinfo.ModularInfoulr;
webdev.Billmodularinfo.Update(model);
}
IsSuccess = webdev.SaveChanges() > 0;
cache.Remove("Sysdb");
}
catch (Exception ex)
{
msg = ex.Message;
IsSuccess = false;
}
return(Json(new { msg = msg, IsSuccess = IsSuccess }));
}
}
public object EmployeeDetail(int EmpId)
{
Employee employee;
string msg = "";
bool IsSuccess = true;
if (cache.Exists("Employee_" + EmpId).Result)
{
var relust = cache.Get <Employee>("Employee_" + EmpId);
msg = relust.Exception?.Message;
if (!string.IsNullOrEmpty(msg))
{
IsSuccess = false;
}
employee = relust.Result;
return(new { IsSuccess = IsSuccess, msg = msg, data = employee });
}
using (var db = new webdevContext())
{
employee = db.Employee.Where(a => a.BillId == EmpId).FirstOrDefault();
if (employee != null)
{
var r = cache.Set("Employee_" + employee.BillId, employee, TimeSpan.FromHours(2));
msg = r.Exception?.Message;
if (!string.IsNullOrEmpty(msg))
{
IsSuccess = false;
}
}
return(new { IsSuccess = IsSuccess, msg = msg, data = employee });
}
}
public object DelPayslip(int BillID)
{
using (webdevContext webdev = new webdevContext())
{
string msg = "";
bool IsSuccess = true;
try
{
var user = webdev.Employeepayslip.Where(a => a.BillId == BillID).FirstOrDefault();
if (user == null)
{
IsSuccess = false;
msg = "删除的工资条不存在";
}
else
{
webdev.Employeepayslip.Remove(user);
int i = webdev.SaveChanges();
if (i > 0)
{
MongoDBServer mongo = new MongoDBServer();
var v = mongo.db.GetCollection <Employeepayslip>("Employeepayslip");
v.DeleteOne(a => a.BillId == BillID);
}
}
}
catch (Exception ex)
{
msg = ex.Message;
IsSuccess = false;
}
return(new { IsSuccess = IsSuccess, msg = msg });
}
}
public object Employeepayslip(Employeepayslip employeepayslip)
{
using (webdevContext webdev = new webdevContext())
{
string msg = "";
bool IsSuccess = true;
try
{
MongoDBServer mongoDB = new MongoDBServer();
var model = webdev.Employeepayslip.Where(a => a.BillId == employeepayslip.BillId).FirstOrDefault();
if (model != null)
{
model.BasePay = employeepayslip.BasePay;
model.Deduction = employeepayslip.Deduction;
model.Subsidy = employeepayslip.Subsidy;
model.WagesPayable = employeepayslip.WagesPayable;
model.Other = employeepayslip.Other;
model.PayDate = employeepayslip.PayDate;
model.Remarks = employeepayslip.Remarks;
model.UserId = employeepayslip.UserId;
webdev.Employeepayslip.Update(model);
}
else
{
webdev.Employeepayslip.Add(employeepayslip);
}
var i = webdev.SaveChanges();
if (i <= 0)
{
msg = "发生未知错误";
IsSuccess = false;
}
if (model != null)
{
mongoDB.db.GetCollection <Employeepayslip>("Employeepayslip").ReplaceOneAsync(a => a.BillId == employeepayslip.BillId, employeepayslip);
}
else
{
mongoDB.InsertOne <Employeepayslip>(employeepayslip, "Employeepayslip");
}
}
catch (Exception ex)
{
msg = ex.Message;
IsSuccess = false;
}
return(new { IsSuccess = IsSuccess, msg = msg });
}
}
public string CreateGuid(string socketId)
{
using (webdevContext context = new webdevContext())
{
string userId = "";
var user = context.Sysuser.Where(a => a.BillId.ToString() == socketId).FirstOrDefault();
if (user == null)
{
userId = Guid.NewGuid().ToString();
}
else
{
userId = user.BillId.ToString();
}
return(userId);
}
}
public async Task <int> DelDownList(int id)
{
using (webdevContext webdev = new webdevContext())
{
var sys = webdev.Sysdropdwondt.Where(a => a.Id == id).FirstOrDefault();
if (sys == null)
{
throw new Exception("下拉不存在");
}
else
{
webdev.Sysdropdwondt.Remove(sys);
await cache.Remove("DownList");
return(await webdev.SaveChangesAsync());
}
}
}
public ActionResult Login(string UserName, string Password)
{
using (webdevContext DB = new webdevContext())
{
Sysuser us = DB.Sysuser.Where(a => a.UserCode == UserName && a.PassWrod == Password).FirstOrDefault();
if (us == null)
{
return(Json(new { Success = false, msg = "账号或密码有误" }));
}
else
{
byte[] SessionUser = Other.SerializeToByte(us);
HttpContext.Session.Set("user", SessionUser);
var token = JwtJsonModel.BulidJwtJson(us);
return(Json(new { Success = true, token = token, name = us.UserName }));
}
}
}
public async Task <int> InsertDownList(int id)
{
using (webdevContext webdev = new webdevContext())
{
var sys = webdev.Sysdropdown.Where(a => a.BillId == id).FirstOrDefault();
if (sys == null)
{
throw new Exception("下拉不存在");
}
else
{
webdev.Sysdropdwondt.Add(new Sysdropdwondt()
{
BillId = id, Value = "未命名"
});
await cache.Remove("DownList");
return(await webdev.SaveChangesAsync());
}
}
}
public object EmployeeLeaveInsert(Employeeleave employeeLeave)
{
using (webdevContext webdev = new webdevContext())
{
string msg = "";
bool IsSuccess = true;
webdev.Employeeleave.Add(employeeLeave);
var re = webdev.SaveChangesAsync();
msg = re.Exception?.Message;
if (!string.IsNullOrEmpty(msg))
{
IsSuccess = false;
}
if (re.Result > 0)
{
MongoDBServer mongoDB = new MongoDBServer();
mongoDB.InsertOne <Employeeleave>(employeeLeave, "EmployeeLeave");
}
return(new { IsSuccess = IsSuccess, msg = msg });
}
}
public object DelLeave(int BillID)
{
using (webdevContext webdev = new webdevContext())
{
string msg = "";
bool IsSuccess = true;
var us = webdev.Employeeleave.Where(a => a.BillId == BillID).FirstOrDefault();
if (us == null)
{
IsSuccess = false;
msg = "需要删除的请假单不存在！";
}
else
{
try
{
webdev.Employeeleave.Remove(us);
var i = webdev.SaveChanges();
if (i > 0)
{
MongoDBServer mongoDB = new MongoDBServer();
mongoDB.db.GetCollection <Employeeleave>("EmployeeLeave").DeleteOne(a => a.BillId == BillID);
}
else
{
IsSuccess = false;
msg = "发生未知错误";
}
}
catch (Exception ex)
{
IsSuccess = false;
msg = ex.Message;
}
}
return(new { IsSuccess = IsSuccess, msg = msg });
}
}
public object DelEmployee(int EmpID)
{
using (var db = new webdevContext())
{
var user = db.Employee.Where(a => a.BillId == EmpID).FirstOrDefault();
string msg = "";
bool IsSuccess = true;
if (user == null)
{
IsSuccess = false;
IsSuccess = false;
msg = "删除的员工信息不存在,请联系管理员确认！";
}
else
{
db.Employee.Remove(user);
var relurt = db.SaveChangesAsync();
msg = relurt.Exception?.Message;
if (!string.IsNullOrEmpty(msg))
{
IsSuccess = false;
}
else
{
if (relurt.Result > 0)
{
cache.Remove("EmployeeList");
cache.Remove("Employee_" + user.BillId);
MongoDBServer mongo = new MongoDBServer();
mongo.db.GetCollection <Employee>("Employee").FindOneAndDelete(a => a.BillId == user.BillId);
}
}
}
return(new { IsSuccess = IsSuccess, msg = msg });
}
}
public ProductController(webdevContext context)
{
_context = context;
}
public object BaseSave(string BillID, string Mb)
{
string msg = "";
bool IsSuccess = true;
try
{
var Parm = Mb.Split("&");
string sql = $"select * from BillModularInfo where id={BillID}";
DataTable dt = dBServices.QueryTable(sql).Result;
string TableName = dt.Rows[0]["ModularInfoId"].ToString();
var T = TableName.Substring(0, 1).ToUpper();
T += TableName.Substring(1);
Assembly assembly = Assembly.Load("MysqlEntity.Core");
var model = assembly.CreateInstance("MysqlEntity.Core.Model." + T);
var ModelCol = model.GetType().GetProperties();
foreach (var item in Parm)
{
var KeyValue = item.Split("=");
string Key = KeyValue[0];
string Value = KeyValue[1];
if (string.IsNullOrEmpty(Value))
{
continue;
}
var Col = ModelCol.Where(a => a.Name.ToUpper() == Key.ToUpper()).FirstOrDefault();
if (Col != null)
{
var t = Library.Other.GetCoreType(Col.PropertyType);
if (t == typeof(DateTime))
{
model.GetType().GetProperty(Col.Name)?.SetValue(model, Convert.ToDateTime(Value));
}
else if (t == typeof(Int32))
{
model.GetType().GetProperty(Col.Name)?.SetValue(model, Convert.ToInt32(Value));
}
else if (t == typeof(Decimal))
{
model.GetType().GetProperty(Col.Name)?.SetValue(model, Convert.ToDecimal(Value));
}
else
{
model.GetType().GetProperty(Col.Name)?.SetValue(model, Value);
}
}
}
if (ModelCol.Where(a => a.Name.ToUpper() == "BILLNO").FirstOrDefault() != null)
{
if (string.IsNullOrEmpty(model.GetType().GetProperty("BillNo").GetValue(model)?.ToString()))
{
string BillNo = DateTime.Now.ToString("yyyyMMddHHmmss");
model.GetType().GetProperty("BillNo").SetValue(model, BillNo);
}
}
using (webdevContext webdev = new webdevContext())
{
var mi2 = webdev.GetType().GetMethod("Set");
var genMethod = mi2.MakeGenericMethod(model.GetType());
var obj = genMethod.Invoke(webdev, null);
var BIllid = model.GetType().GetProperty("BillId").GetValue(model).ToString();
if (string.IsNullOrEmpty(BillID) || BIllid == "0")
{
var add = obj.GetType().GetMethod("Add");
var ob = add.Invoke(obj, new object[] { model });
}
else
{
var upd = obj.GetType().GetMethod("Update");
upd.Invoke(obj, new object[] { model });
}
var i = webdev.SaveChanges();
IsSuccess = i > 0;
return(new { msg = msg, IsSuccess = IsSuccess });
}
}
catch (Exception ex)
{
return(new { msg = ex.Message, IsSuccess = false });
}
}
public UsersController(webdevContext context)
{
_context = context;
}
