/// <summary>
/// 根据账号密码获取信息
/// </summary>
/// <param name="loginname">账号</param>
/// <param name="pwd">密码</param>
/// <returns></returns>
public static M_Users GetM_UserByUserName(string loginname, string pwd, string operateip)
{
pwd = ProBusiness.Encrypt.GetEncryptPwd(pwd, loginname);
DataTable dt = new M_UsersDAL().GetM_UserByUserName(loginname, pwd);
M_Users model = null;
if (dt.Rows.Count > 0)
{
model = new M_Users();
model.FillData(dt.Rows[0]);
if (!string.IsNullOrEmpty(model.RoleID))
{
model.Role = ManageSystemBusiness.GetRoleByID(model.RoleID);
}
//权限
if (model.Role != null && model.Role.IsDefault == 1)
{
model.Menus = CommonBusiness.ClientMenus;
}
else if (model.IsAdmin == 1)
{
model.Menus = CommonBusiness.ClientMenus;
}
else
{
model.Menus = model.Role.Menus;
}
}
return(model);
}
public ActionResult Login()
{
if (CurrentUser != null)
{
return(Redirect("/Home/Index"));
}
HttpCookie cook = Request.Cookies["cp"];
if (cook != null)
{
if (cook["status"] == "1")
{
string operateip = OperateIP;
int result;
M_Users model = ProBusiness.M_UsersBusiness.GetM_UserByProUserName(cook["username"], cook["pwd"], operateip, out result);
if (model != null)
{
model.LastLoginIP = OperateIP;
Session["Manager"] = model;
return(Redirect("/Home/Index"));
}
}
}
return(View());
}
public ActionResult UploadEmployeePhoto()
{
#region Save to Server
bool isSuccess = false;
string serverMessage = string.Empty;
var fileOne = Request.Files[0] as HttpPostedFileBase;
string uploadPath = Server.MapPath(@"~/PictureResources/UsersPhoto/");
string newFileOne = Path.Combine(uploadPath, fileOne.FileName);
//fileOne.SaveAs(newFileOne);
//fileOne.SaveAs(HttpContext.Server.MapPath("~/PictureResources/UsersPhoto/") + Path.GetFileName(fileOne.FileName));
fileOne.SaveAs(HttpContext.Server.MapPath("~/PictureResources/UsersPhoto/") + Path.GetFileName(Regex.Replace(fileOne.FileName, @"\s+", "")));
#endregion
#region ImageSet
M_Users pack = (from c in db.M_Users where c.UserName == user.UserName select c).FirstOrDefault();
string[] data = fileOne.FileName.Split('\\');
//pack.UserPhoto = data[data.Length - 1];//fileOne.FileName;
pack.UserPhoto = Regex.Replace(data[data.Length - 1], @"\s+", "");//fileOne.FileName;
db.Entry(pack).State = EntityState.Modified;
db.SaveChanges();
#endregion
M_Users check = (from c in db.M_Users where c.UserName == user.UserName select c).FirstOrDefault();
System.Web.HttpContext.Current.Session["user"] = check;
return(Json(new { wew = "" }, JsonRequestBehavior.AllowGet));
}
public M_Users _getUserInfo(string UId)
{
try
{
M_Users s = new M_Users();
using (DBLinqDataContext datacontext = new DBLinqDataContext())
{
datacontext.Connection.ConnectionString = Connection_;
System.Data.Linq.ISingleResult <_getUserInfoResult> ckuser = datacontext._getUserInfo(UId);
foreach (_getUserInfoResult result in ckuser)
{
s.Designation = result.Designation;
s.UserName = result.PersonName;
s.UserId = result.UserID;
s.IsActive = result.IsActive;
s.Email = result.Email;
s.UserGroup = result.UserGroupID;
}
}
return(s);
}
catch (Exception ex)
{
// Console.WriteLine(ex.Message.ToString());
ErrorLog.LogError(ex);
return(null);
}
}
public ActionResult GetPageAccess(string UserName)
{
M_Users userchosen = (from c in db.M_Users where c.UserName == UserName select c).FirstOrDefault();
List <M_SP_PageandAccess_Result> MasterPageList = db.M_SP_PageandAccess(UserName, "Master").ToList();
List <M_SP_PageandAccess_Result> ApplicationFormPageList = db.M_SP_PageandAccess(UserName, "Application Form").ToList();
List <M_SP_PageandAccess_Result> SummaryPageList = db.M_SP_PageandAccess(UserName, "Reports").ToList();
List <M_SP_PageandAccess_Result> ForeCastList = db.M_SP_PageandAccess(UserName, "ForeCast").ToList();
if (userchosen.Section == null || userchosen.Section == "")
{
ApplicationFormPageList = ApplicationFormPageList.Where(x => x.PageIndex != "OT" && x.PageIndex != "ChangeSchedule" && x.PageIndex != "DTR").ToList();
}
int MasterGoodcount = MasterPageList.Where(x => x.AccessType == true).Count();
int AFGoodcount = ApplicationFormPageList.Where(x => x.AccessType == true).Count();
int REGoodcount = SummaryPageList.Where(x => x.AccessType == true).Count();
int FCGoodcount = ForeCastList.Where(x => x.AccessType == true).Count();
return(Json(new
{
MasterPageList = MasterPageList,
ApplicationFormPageList = ApplicationFormPageList,
SummaryPageList = SummaryPageList,
ForeCastList = ForeCastList,
GoodCount = MasterGoodcount + AFGoodcount + REGoodcount + FCGoodcount
}, JsonRequestBehavior.AllowGet));
}
public string setNewUser(M_Users Model, string Createdby)
{
try
{
bool Uname = checkUserName(Model.UserId);
if (Uname)
{
return("IN");
}
string pass = Encrypt_Decrypt.Encrypt(Model.Password_, Password);
using (DBLinqDataContext datacontext = new DBLinqDataContext())
{
datacontext.Connection.ConnectionString = Connection_;
datacontext._setNewUser(Model.UserId, Model.UserGroup, Model.UserName, pass,
Model.Designation, Model.Email, Createdby);
datacontext.SubmitChanges();
return("Success");
}
}
catch (Exception ex)
{
// Console.WriteLine(ex.Message.ToString());
ErrorLog.LogError(ex);
return("Error");
}
}
public List <M_Users> getBackEndUsers()
{
try
{
List <M_Users> lstUser = new List <M_Users>();
using (DBLinqDataContext datacontext = new DBLinqDataContext())
{
datacontext.Connection.ConnectionString = Connection_;
System.Data.Linq.ISingleResult <_getBackendSystemUsersResult> lst = datacontext._getBackendSystemUsers();
foreach (_getBackendSystemUsersResult result in lst)
{
M_Users usr = new M_Users();
usr.UserId = result.UserID;
usr.UserGroup = result.UserGroupID;
usr.UserName = result.PersonName;
usr.IsActive = result.IsActive;
usr.Email = result.Email;
usr.Designation = result.Designation;
lstUser.Add(usr);
}
}
return(lstUser);
}
catch (Exception ex)
{
ErrorLog.LogError(ex);
return(null);
}
}
/// <summary>
/// 保存会员信息
/// </summary>
/// <param name="bHeight"></param>
/// <param name="bWeight"></param>
/// <param name="jobs"></param>
/// <param name="bPay"></param>
/// <param name="isMarry"></param>
/// <param name="myContent"></param>
/// <param name="name"></param>
/// <param name="talkTo"></param>
/// <param name="age"></param>
/// <param name="myservice"></param>
/// <returns></returns>
public JsonResult SaveUserInfo(string bHeight, string bWeight, string jobs, string bPay, int isMarry,
string myContent, string name, string talkTo, int age, string myservice)
{
M_Users users = CurrentUser;
users.BHeight = bHeight;
users.BWeight = bWeight;
users.Jobs = jobs;
users.TalkTo = talkTo;
users.BPay = bPay;
users.IsMarry = isMarry;
users.MyService = myservice;
users.Age = age;
users.Name = name;
users.IsMarry = isMarry;
users.MyContent = myContent;
var result = M_UsersBusiness.UpdateM_UserBase(CurrentUser.UserID, bHeight, bWeight, jobs, bPay, isMarry,
myContent, name, talkTo, age, myservice);
if (result)
{
Session["Manage"] = users;
}
JsonDictionary.Add("result", result);
return(new JsonResult
{
Data = JsonDictionary,
JsonRequestBehavior = JsonRequestBehavior.AllowGet
});
}
/// <summary>
/// 获取订单基本信息
/// </summary>
public static ClientOrder GetClientOrderInfo(string orderID)
{
DataTable dt = ClientOrderDAL.BaseProvider.GetClientOrderInfo(orderID);
ClientOrder model = new ClientOrder();
if (dt.Rows.Count == 1)
{
DataRow row = dt.Rows[0];
model.FillData(row);
model.CreateUser = OrganizationBusiness.GetUserByUserID(model.CreateUserID, model.ClientID);
if (string.IsNullOrEmpty(model.CreateUser.Name))
{
M_Users mUser = M_UsersBusiness.GetUserDetail(model.CreateUserID);
if (mUser != null && !string.IsNullOrEmpty(mUser.Name))
{
model.CreateUser.Name = mUser.Name;
}
}
if (!string.IsNullOrEmpty(model.CheckUserID))
{
model.CheckUser = OrganizationBusiness.GetUserByUserID(model.CheckUserID, model.ClientID);
if (string.IsNullOrEmpty(model.CheckUser.Name))
{
M_Users mUser = M_UsersBusiness.GetUserDetail(model.CheckUserID);
if (mUser != null && !string.IsNullOrEmpty(mUser.Name))
{
model.CheckUser.Name = mUser.Name;
}
}
}
}
return(model);
}
public static int CreateBettOrderList(List <LotteryBettAuto> models, M_Users user, string ip, int isStart, ref string errmsg)
{
int k = 0;
string msg = "";
models.ForEach(x =>
{
string errormsg = "";
string orderCode = Getordercode() + user.AutoID;
x.TypeName = x.TypeName.Replace("大小单双", "").Replace("趣味型", "趣味");
if (x.CPCode.ToLower() != "bjsc")
{
x.TypeName = x.TypeName.Replace("龙虎斗", "");
}
var result = CreateBettOrder(orderCode, x.StartNum, x.Type, x.TypeName, x.CPCode, x.CPName, x.Content.Replace("\"", ""),
x.Num, x.PayFee, user.UserID, x.PMuch, x.RPoint, ip, isStart, x.BettNum, x.BMuch, x.TotalFee, x.Profits, x.WinFee, x.BettType, x.JsonContent, x.ModelName, x.MType, ref errormsg);
if (!result)
{
//msg += x.Content + " " + errormsg + "/n";
msg += errormsg;
}
else
{
k++;
}
});
errmsg = msg;
return(k);
}
public static List <M_Users> GetImgList(string userid, int sex, int pageIndex, int pageSize, ref int totalCount, ref int pageCount)
{
string whereSql = " a.Status<>9 and b.ImgCount>0";
if (sex > -1)
{
whereSql += " and a.Sex=" + sex;
}
if (!string.IsNullOrEmpty(userid))
{
whereSql += " and a.UserID='" + userid + "' ";
}
string clumstr = "a.userID,a.Avatar,a.Name,a.Age,a.LoginName,a.MyService,a.Province,a.City,a.District,a.CreateTime,a.Status,a.Sex,a.IsMarry,a.Education," +
"a.BHeight,a.Levelid,a.BWeight,a.MyContent,a.MyCharacter,a.TalkTo,a.BPay,a.Account,b.ImgCount,b.IsLogin,b.RecommendCount,b.SeeCount";
DataTable dt = CommonBusiness.GetPagerData("M_Users a join userReport b on a.Userid=b.Userid ", clumstr, whereSql, "a.AutoID", pageSize, pageIndex, out totalCount, out pageCount);
List <M_Users> list = new List <M_Users>();
foreach (DataRow item in dt.Rows)
{
M_Users model = new M_Users();
model.FillData(item);
list.Add(model);
}
return(list);
}
/// <summary>
/// 新增或修改用户信息
/// </summary>
public static int CreateM_User(M_Users musers)
{
int bl = M_UsersDAL.BaseProvider.CreateM_User(musers.UserName, musers.Password, musers.Email, musers.IsAdmin, musers.RoleID, musers.Email, musers.Mobile, musers.Salt, musers.Avatar, musers.AdminGid);
return(bl);
}
public static List <M_Users> GetUsers(string keyWords, string roleID, int pageSize, int pageIndex, ref int totalCount, ref int pageCount)
{
string whereSql = " Status<>9";
if (!string.IsNullOrEmpty(keyWords))
{
whereSql += " and ( Name like '%" + keyWords + "%' or MobilePhone like '%" + keyWords + "%' or Email like '%" + keyWords + "%')";
}
if (!string.IsNullOrEmpty(roleID))
{
whereSql += " and RoleID='" + roleID + "'";
}
DataTable dt = CommonBusiness.GetPagerData("M_Users", "*", whereSql, "AutoID", pageSize, pageIndex, out totalCount, out pageCount);
List <M_Users> list = new List <M_Users>();
M_Users model;
foreach (DataRow item in dt.Rows)
{
model = new M_Users();
model.FillData(item);
if (!string.IsNullOrEmpty(model.RoleID))
{
model.Role = ManageSystemBusiness.GetRoleByIDCache(model.RoleID);
}
list.Add(model);
}
return(list);
}
public static List <M_Users> GetUsers(int pageSize, int pageIndex, ref int totalCount, ref int pageCount, int type = 2, int status = -1, string keyWords = "", string colmonasc = "", bool isasc = false)
{
string whereSql = " a.isfreeze<>9";
if (type > -1)
{
whereSql += " and a.admingid=" + type + " ";
}
if (status > -1)
{
whereSql += " and a.isfreeze=" + status;
}
if (!string.IsNullOrEmpty(keyWords))
{
whereSql += " and (a.UserName like '%" + keyWords + "%' or a.mobile like'%" + keyWords + "%' or a.email like'%" + keyWords + "%') ";
}
string cstr = @" a.*,convert(varchar(25),b.registertime,120) registertime,convert(varchar(25),b.lastvisittime,120) lastvisittime ";
DataTable dt = CommonBusiness.GetPagerData("Owzx_Users a join owzx_userdetails b on a.uid=b.uid ", cstr, whereSql, "a.Uid", colmonasc, pageSize, pageIndex, out totalCount, out pageCount, isasc);
List <M_Users> list = new List <M_Users>();
M_Users model;
foreach (DataRow item in dt.Rows)
{
model = new M_Users();
model.FillData(item);
if (!string.IsNullOrEmpty(model.RoleID))
{
model.Role = ManageSystemBusiness.GetRoleByIDCache(model.RoleID);
}
list.Add(model);
}
return(list);
}
public JsonResult UserRegister(string userName, string pwd, string id)
{
string Errmsg = "";
M_Users user = new M_Users()
{
Type = 0,
SourceType = 0,
UserName = userName,
LoginName = userName,
LoginPwd = pwd,
Description = "自动注册",
RoleID = "48eb0491-d92c-4664-ab27-37320ac7de38"
//dd87ca0a-b425-4e1e-b7ec-7a1e02dad0f8 代理角色
//48eb0491-d92c-4664-ab27-37320ac7de38 会员ID
};
var result = M_UsersBusiness.CreateM_User(user, ref Errmsg);
if (string.IsNullOrEmpty(Errmsg))
{
return(UserLogin(userName, pwd));
}
else
{
JsonDictionary.Add("result", result);
JsonDictionary.Add("Errmsg", Errmsg);
return(new JsonResult
{
Data = JsonDictionary,
JsonRequestBehavior = JsonRequestBehavior.AllowGet
});
}
}
public void RefreshPageAccess(string UserName, string Section)
{
#region For Page Access
M_Users userchosen = (from c in db.M_Users where c.UserName == UserName select c).FirstOrDefault();
//if (userchosen.Section == "Production Engineering")
//{
// MasterPageList = db.M_SP_PageandAccess(UserName, "Master").Where(x => x.AccessType == true).ToList(); ;
//}
//else
//{
// MasterPageList = db.M_SP_PageandAccess(UserName, "Master").Where(x => x.PageIndex != "CostCenter" && x.PageIndex != "FormatorTemplate" && x.PageIndex != "Section" && x.AccessType == true).ToList();
//}
List <M_SP_PageandAccess_Result> MasterPageList = db.M_SP_PageandAccess(UserName, "Master").Where(x => x.AccessType == true).ToList();
List <M_SP_PageandAccess_Result> ApplicationFormPageList = db.M_SP_PageandAccess(UserName, "Application Form").Where(x => x.AccessType == true).ToList();
List <M_SP_PageandAccess_Result> SummaryPageList = db.M_SP_PageandAccess(UserName, "Reports").Where(x => x.AccessType == true).ToList();
List <M_SP_PageandAccess_Result> ForeCastList = db.M_SP_PageandAccess(UserName, "ForeCast").Where(x => x.AccessType == true).ToList();
#region FORCE REMOVE Form to super user
if (Section == null || Section == "")
{
ApplicationFormPageList = ApplicationFormPageList.Where(x => x.PageIndex != "OT" && x.PageIndex != "ChangeSchedule" && x.PageIndex != "DTR").ToList();
}
#endregion
System.Web.HttpContext.Current.Session["MasterPageList"] = MasterPageList;
System.Web.HttpContext.Current.Session["ApplicationFormPageList"] = ApplicationFormPageList;
System.Web.HttpContext.Current.Session["SummaryPageList"] = SummaryPageList;
System.Web.HttpContext.Current.Session["ForeCastList"] = ForeCastList;
#endregion
}
public ActionResult Login()
{
if (CurrentUser != null)
{
return(Redirect("/User/UserInfo"));
}
HttpCookie cook = Request.Cookies["zpy"];
if (cook != null)
{
if (cook["status"] == "1")
{
string operateip = OperateIP;
int result;
M_Users model = PCDDBusiness.M_UsersBusiness.GetM_UserByProUserName(cook["username"], cook["pwd"], operateip, out result);
if (model != null)
{
if (DateTime.Now.CompareTo(model.AuthorETime) < 1)
{
model.AuthorType = 0;
}
Session["Manager"] = model;
return(Redirect("/User/UserInfo"));
}
}
}
return(View());
}
public ActionResult CreateUser(M_Users data)
{
try
{
data.CreateID = user.UserName;
data.CreateDate = DateTime.Now;
data.UpdateID = user.UserName;
data.UpdateDate = DateTime.Now;
data.IsDeleted = false;
M_Users checker = (from c in db.M_Users
where c.UserName == data.UserName &&
c.IsDeleted == false
select c).FirstOrDefault();
if (checker == null)
{
db.M_Users.Add(data);
db.SaveChanges();
return(Json(new { msg = "Success" }, JsonRequestBehavior.AllowGet));
}
else
{
return(Json(new { msg = "Failed" }, JsonRequestBehavior.AllowGet));
}
}
catch (Exception err)
{
return(Json(new { msg = err.Message }, JsonRequestBehavior.AllowGet));
}
}
public static List <M_Users> GetUsers(int pageSize, int pageIndex, ref int totalCount, ref int pageCount, int type = -1, int status = -1, string keyWords = "", string colmonasc = "", bool isasc = false)
{
string whereSql = " a.Status<>9";
if (type > -1)
{
whereSql += " and a.type=" + type + " ";
}
if (status > -1)
{
whereSql += " and a.Status=" + status;
}
if (!string.IsNullOrEmpty(keyWords))
{
whereSql += " and (a.UserName like '%" + keyWords + "%' or a.LoginName like'%" + keyWords + "%') ";
}
string cstr = @" a.* ";
DataTable dt = CommonBusiness.GetPagerData("M_Users a ", cstr, whereSql, "a.AutoID", colmonasc, pageSize, pageIndex, out totalCount, out pageCount, isasc);
List <M_Users> list = new List <M_Users>();
M_Users model;
foreach (DataRow item in dt.Rows)
{
model = new M_Users();
model.FillData(item);
if (!string.IsNullOrEmpty(model.RoleID))
{
model.Role = ManageSystemBusiness.GetRoleByIDCache(model.RoleID);
}
list.Add(model);
}
return(list);
}
public static M_Users GetNewUserInfo(Grid userInfoGrid, Grid workTimeInfoGrid)
{
var user = new M_Users
{
P_Names = new List <M_Names>
{
new M_Names
{
NameFirst = ((TextBox)userInfoGrid.FindName("TB_UserFN")).Text,
NameLast = ((TextBox)userInfoGrid.FindName("TB_UserSN")).Text,
NameThird = ((TextBox)userInfoGrid.FindName("TB_UserTN")).Text
}
},
Address = ((TextBox)userInfoGrid.FindName("TB_UsesrAddr")).Text,
D_Birth = ((DateTimePicker)userInfoGrid.FindName("DP_UserBithday")).SelectedDate,
HourRate = Convert.ToDouble(((TextBox)workTimeInfoGrid.FindName("TB_HourRate")).Text),
OvertimeRate = Convert.ToDouble(((TextBox)workTimeInfoGrid.FindName("TB_OverTimerate")).Text),
IsAdmin = ((CheckBox)userInfoGrid.FindName("CB_IsAdmin")).IsChecked,
IsDirector = ((CheckBox)userInfoGrid.FindName("CB_IsDirecor")).IsChecked,
IsAccountant = ((CheckBox)userInfoGrid.FindName("CB_IsAccountant")).IsChecked,
IsUser = true,
P_Phones = GetNewPhones((TextBox)userInfoGrid.FindName("PhoneNumber1"),
(TextBox)userInfoGrid.FindName("PhoneNumber2"), (TextBox)userInfoGrid.FindName("PhoneNumber3"),
(TextBox)userInfoGrid.FindName("TB_UserPhone"))
};
return(user);
}
public static string GetPhotoPath(M_Users user, bool isImageExists, string img)
{
if (!isImageExists)
{
return(null);
}
if (string.IsNullOrEmpty(img))
{
return(null);
}
var imageFile = new FileInfo(img);
var imageName = string.Empty;
imageName = string.Format("{0}_{1}_{2}.{3}",
user.ID,
user.P_Names.FirstOrDefault().NameFirst.Replace(" ", string.Empty),
user.P_Names.FirstOrDefault().NameLast.Replace(" ", string.Empty),
imageFile.ToString().Split('.').Last()
);
var dir = new DirectoryInfo(Singelton.PathToPhoto);
if (!dir.Exists)
{
dir.Create();
}
var source = img;
var dest = Path.Combine(dir.FullName, imageName);
//File.Delete(dest);
File.Copy(img, dest, true);
//imageFile.CopyTo(Path.Combine(dir.FullName, imageName), true);
return(imageName);
}
public ActionResult Modify(M_Users User)
{
object result = "";
try
{
B_Users bUser = new B_Users();
var oldUser = bUser.GetUsers(User.Id);
if (oldUser.ImageName.ToLower() != "default.jpg" && oldUser.ImageName.ToLower() != User.ImageName)
{
System.IO.File.Delete(Server.MapPath("~/Areas/Admin/Images/Profile") + "/" + oldUser.ImageName);
}
bUser.Edit(User);
result = "Success";
}
catch (Exception ex)
{
M_SystemLog exx = new M_SystemLog(E_SystemType.SHAHRDARI_WEB_APPLICATION, E_LogType.ERROR, ex);
result = "Error";
if (ex.Source == E_LogType.SYSTEM_ERROR.ToString())
{
exx.LogType = E_LogType.SYSTEM_ERROR;
result = exx;
}
L_Log.SubmitLog(exx);
}
return(Json(result));
}
public ActionResult Login1()
{
//if (Session["IsLogin"] == null || Session["IsLogin"].ToString() != CommonBusiness.GetAppSet().Where(x => x.KName == "Login").FirstOrDefault().KValue)
//{
// Session.RemoveAll();
// return Redirect("/Home/Login");
//}
if (CurrentUser != null)
{
return(Redirect("/Home/Index"));
}
HttpCookie cook = Request.Cookies["cp"];
if (cook != null)
{
if (cook["status"] == "1")
{
string operateip = OperateIP;
int result;
M_Users model = ProBusiness.M_UsersBusiness.GetM_UserByProUserName(cook["username"], cook["pwd"], operateip, out result);
if (model != null)
{
model.LastLoginIP = OperateIP;
Session["Manager"] = model;
Session["KFUrl"] = CommonBusiness.KFUrl;
M_UsersBusiness.UpdLine(model.UserID, 1);
return(Redirect("/Home/Index"));
}
}
}
return(View());
}
void run(int Id)
{
RfidContext db = new RfidContext();
M_Users user = new M_Users();
user = db.C_Users.Where(z => z.ID == Id).Single();
List <M_Rfids> prfids = new List <M_Rfids>();
prfids = user.P_Rfids.ToList();
var rfideCode = prfids.Where(x => x.IsArhive == false).Single();
RFIDCodeTags.Content = rfideCode.RfidID.ToString();
var queryAllCustomers = from cust in db.C_Rfids
where cust.IsArhive == true && cust.P_Users.ID == Id
select new { cust.Date, cust.RfidID, cust.Comment };
List <M_Rfids> queryAllCustomers1 = db.C_Rfids.Where(x => x.IsArhive == true && x.P_Users.ID == Id).ToList();
var ListQueryAllCustomers = queryAllCustomers.ToList();
LAadded.Content = user.P_Rfids.ToList()[0].Date.ToShortDateString();
GridRegistryChangesRFIDtags.ItemsSource = queryAllCustomers.ToList();
dynamic sdsdd = GridRegistryChangesRFIDtags.Items.CurrentItem;
dynamic sdsdd1 = GridRegistryChangesRFIDtags.Items;
if (GridRegistryChangesRFIDtags.Columns.Count > 0)
{
this.GridRegistryChangesRFIDtags.Columns[0].ClipboardContentBinding.StringFormat = "dd.MM.yyyy";
}
GridRegistryChangesRFIDtags.Items.Refresh();
}
public JsonResult UserRegister2(string entity)
{
M_Users users = JsonConvert.DeserializeObject <M_Users>(entity);
users.OfficePhone = "";
users.Avatar = "";
users.CreateUserID = "";
users.IsAdmin = 0;
users.RoleID = "";
users.Description = "";
users.UserID = ((M_Users)Session["PartManage"]).UserID;
var result = PCDDBusiness.M_UsersBusiness.UpdateM_UserBase(users);
if (result)
{
var outresult = 0;
PCDDEntity.Manage.M_Users model = PCDDBusiness.M_UsersBusiness.GetUserDetail(((M_Users)Session["PartManage"]).UserID);
if (model != null)
{
CurrentUser = model;
Session["Manager"] = model;
}
}
JsonDictionary.Add("result", result);
return(new JsonResult
{
Data = JsonDictionary,
JsonRequestBehavior = JsonRequestBehavior.AllowGet
});
}
public void SetInfoAboutSelectedUser(int?selectedId = null, M_Users selectedUser = null)
{
_selectedId = selectedId;
_selectedUser = selectedUser;
DP_SigleDate.Culture = App.Language;
DP_StarDate.Culture = App.Language;
DP_EndDate.Culture = App.Language;
}
public static List <M_Users> GetUsers(int sex, int pageSize, int pageIndex, ref int totalCount, ref int pageCount, string address = "", string age = "", int sourcetype = 0, int status = -1, string keyWords = "")
{
string whereSql = " a.Status<>9";
if (sex > -1)
{
whereSql += " and a.Sex=" + sex;
}
if (status > -1)
{
whereSql += " and a.Status=" + status;
}
if (!string.IsNullOrEmpty(keyWords))
{
whereSql += " and (a.Name like '%" + keyWords + "%' or a.LoginName like'%" + keyWords + "%') ";
}
if (sourcetype > -1)
{
whereSql += " and a.sourcetype=" + sourcetype;
}
if (!string.IsNullOrEmpty(address))
{
string[] strArr = address.Split(',');
for (int i = 0; i < strArr.Length; i++)
{
whereSql += (i == 0
? " and a. province='"
: i == 1 ? " and a.City='" : i == 2 ? " and a.District='" : "") + strArr[i] + "'";
}
}
if (!string.IsNullOrEmpty(age))
{
string[] strArr = age.Split('~');
for (int i = 0; i < strArr.Length; i++)
{
whereSql += (i == 0? " and a.Age>=": " and a.Age<=") + strArr[i];
}
}
string cstr = @"a.AuthorBTime,a.AuthorETime,a.AuthorType,a.userID,a.Avatar,a.Name,a.LoginName,a.Age,a.MyService,a.Province,a.City,a.District,a.CreateTime,a.Status,a.Sex,a.IsMarry,a.Education,a.ROleID,
a.BHeight,a.Levelid,a.BWeight,a.MyContent,a.MyCharacter,a.BPay,a.Account,a.TalkTo,a.Description";
DataTable dt = CommonBusiness.GetPagerData("M_Users a", cstr, whereSql, "a.AutoID", pageSize, pageIndex, out totalCount, out pageCount);
List <M_Users> list = new List <M_Users>();
M_Users model;
foreach (DataRow item in dt.Rows)
{
model = new M_Users();
model.FillData(item);
if (!string.IsNullOrEmpty(model.RoleID))
{
model.Role = ManageSystemBusiness.GetRoleByIDCache(model.RoleID);
}
list.Add(model);
}
return(list);
}
public static void UpdateInOutTimes(Grid workTimeInfoGrid, M_Users user)
{
var newTimes = GetInOutValidTimes(workTimeInfoGrid);
user.P_InOutValidTimes.Start = newTimes.Start;
user.P_InOutValidTimes.End = newTimes.End;
user.P_InOutValidTimes.Valid = newTimes.Valid;
user.P_InOutValidTimes.Dinner = newTimes.Dinner;
}
/// <summary>
/// 新增或修改用户信息
/// </summary>
public static string CreateM_User(M_Users musers, ref string errormsg)
{
string userid = Guid.NewGuid().ToString();
musers.LoginPwd = ProBusiness.Encrypt.GetEncryptPwd(musers.LoginPwd, musers.LoginName);
bool bl = M_UsersDAL.BaseProvider.CreateM_User(userid, musers.LoginName, musers.LoginPwd, musers.UserName, musers.SourceType, musers.Type, musers.RoleID, out errormsg, musers.Description);
return(bl ? userid : "");
}
/// <summary>
/// 获取客户订单账目列表
/// </summary>
public static List <ClientOrderAccount> GetClientOrderAccounts(string keyWords, string orderID, string clientID, int payType, int status, int type, int pageSize, int pageIndex, ref int totalCount, ref int pageCount)
{
string sqlWhere = "a.Status<>9";
if (!string.IsNullOrEmpty(keyWords))
{
sqlWhere += " and ( a.OrderID like '%" + keyWords + "%' or a.ClientID like '%" + keyWords + "%' )";
}
if (!string.IsNullOrEmpty(orderID))
{
sqlWhere += " and ( a.OrderID ='" + orderID + "' )";
}
if (!string.IsNullOrEmpty(clientID))
{
sqlWhere += " and ( a.ClientID ='" + clientID + "' )";
}
if (payType > 0)
{
sqlWhere += " and ( a.PayType ='" + payType + "' )";
}
if (type > 0)
{
sqlWhere += " and ( a.Type ='" + type + "' )";
}
if (status > 0)
{
sqlWhere += " and ( a.Status ='" + status + "' )";
}
string sqlColumn = @" * ";
DataTable dt = CommonBusiness.GetPagerData("ClientOrderAccount a", sqlColumn, sqlWhere, "a.AutoID", pageSize, pageIndex, out totalCount, out pageCount);
List <ClientOrderAccount> list = new List <ClientOrderAccount>();
ClientOrderAccount model;
foreach (DataRow item in dt.Rows)
{
model = new ClientOrderAccount();
model.FillData(item);
if (!string.IsNullOrEmpty(model.CreateUserID))
{
model.CreateUser = OrganizationBusiness.GetUserByUserID(model.CreateUserID, model.ClientID);
if (string.IsNullOrEmpty(model.CreateUser.Name))
{
M_Users mUser = M_UsersBusiness.GetUserDetail(model.CreateUserID);
model.CreateUser.Name = mUser != null ? mUser.Name : "";
model.CreateUser.UserID = model.CreateUserID;
}
}
if (!string.IsNullOrEmpty(model.CheckUserID))
{
model.CheckerUser = M_UsersBusiness.GetUserDetail(model.CheckUserID);
}
list.Add(model);
}
return(list);
}
/// <summary>
/// 根据账号密码获取信息（登录）
/// </summary>
/// <param name="loginname">账号</param>
/// <param name="pwd">密码</param>
/// <returns></returns>
public static M_Users GetM_UserByUserName(string loginname, string pwd, string operateip)
{
pwd = CloudSalesTool.Encrypt.GetEncryptPwd(pwd, loginname);
DataTable dt = new M_UsersDAL().GetM_UserByUserName(loginname, pwd);
M_Users model = null;
if (dt.Rows.Count > 0)
{
model = new M_Users();
model.FillData(dt.Rows[0]);
}
//记录登录日志
LogBusiness.AddLoginLog(loginname, model != null, CloudSalesEnum.EnumSystemType.Manage, operateip, "", "", "");
return model;
}
/// <summary>
/// 根据账号密码获取信息（登录）
/// </summary>
/// <param name="loginname"></param>
/// <param name="pwd"></param>
/// <param name="operateip"></param>
/// <param name="result"></param>
/// <returns></returns>
public static M_Users GetM_UserByProUserName(string loginname, string pwd, string operateip, out int result)
{
pwd = CloudSalesTool.Encrypt.GetEncryptPwd(pwd, loginname);
DataSet ds = new M_UsersDAL().GetM_UserByProUserName(loginname, pwd, out result);
M_Users model = null;
if (ds.Tables.Contains("M_User") && ds.Tables["M_User"].Rows.Count > 0)
{
model = new M_Users();
model.FillData(ds.Tables["M_User"].Rows[0]);
if (!string.IsNullOrEmpty(model.RoleID))
model.Role = ManageSystemBusiness.GetRoleByIDCache(model.RoleID);
//权限
if (model.Role != null && model.Role.IsDefault == 1)
{
model.Menus = CommonBusiness.ManageMenus;
}
else if (model.IsAdmin == 1)
{
model.Menus = CommonBusiness.ManageMenus;
}
else
{
model.Menus = new List<Menu>();
foreach (DataRow dr in ds.Tables["Permission"].Rows)
{
Menu menu = new Menu();
menu.FillData(dr);
model.Menus.Add(menu);
}
}
}
//记录登录日志
LogBusiness.AddLoginLog(loginname, model != null, CloudSalesEnum.EnumSystemType.Manage, operateip, "", "", "");
return model;
}
/// <summary>
/// 新增或修改用户信息
/// </summary>
public string CreateM_User(M_Users musers)
{
string userid = Guid.NewGuid().ToString();
musers.LoginPWD = CloudSalesTool.Encrypt.GetEncryptPwd(musers.LoginPWD, musers.LoginName);
bool bl = M_UsersDAL.BaseProvider.CreateM_User(userid, musers.LoginName, musers.LoginPWD, musers.Name, musers.IsAdmin, musers.RoleID, musers.Email, musers.MobilePhone, musers.OfficePhone, musers.Jobs, musers.Avatar, musers.Description, musers.CreateUserID);
if (bl)
{
return userid;
}
return "";
}
public static List<M_Users> GetUsers(string keyWords, string roleID, int pageSize, int pageIndex, ref int totalCount, ref int pageCount)
{
string whereSql = " Status<>9";
if (!string.IsNullOrEmpty(keyWords))
whereSql += " and ( Name like '%" + keyWords + "%' or MobilePhone like '%" + keyWords + "%' or Email like '%" + keyWords + "%')";
if (!string.IsNullOrEmpty(roleID))
whereSql += " and RoleID='" + roleID + "'";
DataTable dt = CommonBusiness.GetPagerData("M_Users", "*", whereSql, "AutoID", pageSize, pageIndex, out totalCount, out pageCount);
List<M_Users> list = new List<M_Users>();
M_Users model;
foreach (DataRow item in dt.Rows)
{
model = new M_Users();
model.FillData(item);
if (!string.IsNullOrEmpty(model.RoleID))
model.Role = ManageSystemBusiness.GetRoleByIDCache(model.RoleID);
list.Add(model);
}
return list;
}
public static M_Users GetUserDetail(string userID)
{
DataTable dt = M_UsersDAL.BaseProvider.GetUserDetail(userID);
M_Users model = null;
if (dt.Rows.Count == 1)
{
model = new M_Users();
model.FillData(dt.Rows[0]);
}
return model;
}
