public void saveReport(string savePath, int year, int month) { Workbook wk = new Workbook(); TB_User[] sales = UserBusiness.getAllSalersAndWrite(); //获取所有销售渠道和完工录入信息 if (Global.g_usergroupid != (int)EnmUserRole.财务 && Global.g_usergroupid != (int)EnmUserRole.全部 && Global.g_usergroupid != (int)EnmUserRole.销售总监) { TB_User u = UserBusiness.findUserById(Global.g_userid); List <TB_User> list = new List <TB_User>(); list.Add(u); sales = list.ToArray(); } string str = year.ToString() + "-" + month.ToString() + "-01"; DateTime startdate = DateTime.Parse(str).Date; DateTime enddate = DateTime.Parse(str).AddMonths(1).AddDays(-1).Date; for (int i = 0; i < sales.Length; i++) { DataTable salesData = ScoreBusiness.makeActualScore(startdate, enddate, "", sales[i].Id, ""); if (salesData.Rows.Count > 0) { writeSalesReport(wk, i, salesData, year, month, sales[i].USER_NAME); try { wk.Password = DES.Decode(sales[i].PASSWORD, Global.DB_PWDKEY); wk.Save(savePath + "//" + sales[i].USER_NAME + " " + year + "-" + month + "月度提成清单1.xls"); } catch (Exception ex) { MessageHelper.ShowMessage("E999", "错误" + ex.Message + "\n此文件导出失败,其他文件仍将被导出到所选目录。"); } } } MessageHelper.ShowMessage("I007"); }
public ActionResult ValidEmail(string code = "") { if (string.IsNullOrEmpty(code)) { if (CurrentUserInfo == null)//无用户信息 { return(RedirectToAction("Login")); } else { Session["UserInfo"] = db.FirstOrDefault <TB_User>("where Id=@0", CurrentUserInfo.Id); if (CurrentUserInfo.EmailValid)//刷新页面,重新获取用户信息,已验证邮箱则跳回首页。 { return(Redirect("/Home/Index")); } } return(View()); } else { var message = ""; TB_User user = null; if (!VerifyUtil.CheckEmailVerfyCode(code, out user, out message)) { return(Content(message)); } Session["UserInfo"] = user; return(RedirectToAction("Recharge")); } }
private void bindProjectData() { try { //mProj this.txtOBJECTNAME.Text = mProj.OBJECTNAME; this.txtCONTRACTNO.Text = mProj.CONTRACTNO; this.txtCOMPANYNAME.Text = mProj.COMPANYNAME; this.txtADDRESS.Text = mProj.ADDRESS; this.dtpBeginDate.DateTime = mProj.BEGINDATE; this.dtpEndDate.DateTime = mProj.ENDDATE; if (mProj.OBJECTTYPENAME != null) { setProjIdentity(mProj.OBJECTTYPENAME); } this.txtMoney.Text = mProj.MONEY.ToString(); if (mProj.BILLSTATUS == "已结算") { this.chkBillStatus.IsChecked = true; } if (!string.IsNullOrEmpty(mProj.TEAMLEDER)) { TB_User leader = TB_UserDao.FindFirst(new EqExpression("USER_CODE", mProj.TEAMLEDER)); this.txtleder.Text = leader.USER_NAME; this.txtleder.Tag = leader; } //绑定组员 string menbers = mProj.TEAMMEMBER; if (!string.IsNullOrEmpty(menbers)) { string[] arr = menbers.Split('|'); if (arr.Length > 0) { for (int i = 0; i < arr.Length; i++) { TB_User user = TB_UserDao.FindFirst(new EqExpression("USER_CODE", arr[i])); uc_user uc = new uc_user(user); uc.DelSelectUser += uc_DelSelectUser; this.warp.Children.Add(uc); } } TB_BILL[] arr_bills = TB_BILLDAO.FindAll(new EqExpression("PROJECTID", mProj.Id), new EqExpression("STATUS", 1)); if (arr_bills.Length > 0) { //绑定发票信息 for (int i = 0; i < arr_bills.Length; i++) { uc_bill uc = new uc_bill(arr_bills[i]); uc.DelSelectBill += uc_DelSelectBill; this.warp2.Children.Add(uc); } } this.txtMemo.Text = mProj.MEMO; } } catch (Exception ex) { MessageHelper.ShowMessage(ex.Message); } }
public void Login(WD001ViewModel model) { if (string.IsNullOrWhiteSpace(model.UserId) || string.IsNullOrWhiteSpace(model.PassWord)) { return; } using (EntityDao db = new EntityDao()) { List <MySqlParameter> para = new List <MySqlParameter>(); StringBuilder sql = new StringBuilder(); sql.AppendLine("select * from tb_user"); para.Add(new MySqlParameter("CD", model.UserId)); sql.AppendLine("where CD = @CD"); para.Add(new MySqlParameter("Password", model.PassWord)); sql.AppendLine(" and Password = md5(@Password)"); sql.AppendLine(" and DateStart <= CURDATE()"); sql.AppendLine(" and CURDATE() <= DateEnd"); sql.AppendLine(" and DelFlg = '0'"); TB_User user = db.FindSingle <TB_User>(sql.ToString(), para); if (user != null) { App.LoginUser = user; model.UserName = user.Name; } else { } } }
public TB_User Login(TB_User user, OleDbConnection db) { string pwd = Security.DesEncriptar(user.password); DataSet dataSet = new DataSet(); OleDbDataAdapter da = new OleDbDataAdapter("select * from TB_User where Login='******'and Password ='******';", db);; da.Fill(dataSet); db.Close(); DataTable dt = dataSet.Tables[0]; TB_User _User = null; foreach (DataRow rows in dt.Rows) { _User = new TB_User( int.Parse(rows["Id"].ToString()), rows["Login"].ToString(), rows["Password"].ToString(), int.Parse(rows["TypeUserId"].ToString()), rows["NameUser"].ToString(), rows["Lastname"].ToString(), rows["DNI"].ToString()); } return(_User); }
/// <summary> /// 编辑用户信息 /// </summary> /// <param name="tb_User"></param> /// <param name="lstDormAreaID"></param> /// <returns></returns> public string Edit(TB_User tb_User, List <int> lstDormAreaID) { string strErrMsg = string.Empty; TB_User mTB_User = null; mTB_User = _mTB_UserDAL.GetUserInfo(tb_User.ADAccount); //编辑 if (tb_User.ID > 0) { if (mTB_User != null && mTB_User.ID != tb_User.ID) { strErrMsg = "该用户添加!"; return(strErrMsg); } this.Update(tb_User, lstDormAreaID); } //添加 else { if (mTB_User != null) { strErrMsg = "该用户添加!"; return(strErrMsg); } this.Add(tb_User, lstDormAreaID); } return(strErrMsg); }
protected void btnSave_Click(object sender, EventArgs e) { try { string strErrorMsg = string.Empty;; UserBLL mUserBLL = new UserBLL(); List <int> lstDormAreaID = new List <int>(); for (int i = 0; i < gdvRight.Rows.Count; i++) { lstDormAreaID.Add(Convert.ToInt32(gdvRight.DataKeys[i].Value.ToString())); } TB_User mTB_User = new TB_User(); mTB_User.ID = Request.QueryString["id"] == null ? 0 : Convert.ToInt32(Request.QueryString["id"]); mTB_User.SiteID = (base.UserInfo == null ? base.SystemAdminInfo.SiteID : base.UserInfo.SiteID); mTB_User.Creator = (base.UserInfo == null ? base.SystemAdminInfo.Account : base.UserInfo.ADAccount); mTB_User.ADAccount = this.txtADAccount.Text.Trim(); mTB_User.CName = this.txtCName.Text.Trim(); mTB_User.EName = this.txtEName.Text.Trim(); mTB_User.EmployeeNo = this.txtEmployeeNo.Text.Trim(); mTB_User.RoleID = Convert.ToInt32(this.ddlRole.SelectedValue); strErrorMsg = mUserBLL.Edit(mTB_User, lstDormAreaID); if (string.IsNullOrEmpty(strErrorMsg)) { ClientScript.RegisterStartupScript(ClientScript.GetType(), "myscript", "<script>saveComplete();</script>"); } else { ClientScript.RegisterStartupScript(ClientScript.GetType(), "message", "<script>alert('" + strErrorMsg + "');</script>"); } } catch (Exception ex) { LogManager.GetInstance().ErrorLog(ex.Message); } }
/// <summary> /// 获取分页数据 /// </summary> /// <param name="tb_User"></param> /// <param name="pager"></param> /// <returns></returns> public DataTable GetPagerData(TB_User tb_User, ref Pager pager) { DataTable dt = _mTB_UserDAL.GetTable(tb_User, ref pager); //DataTable dtNew = dt.Clone(); //DataRow[] drFilter = null; //foreach (DataRow dr in dt.Rows) //{ // DataRow drNew = dtNew.NewRow(); // drFilter = dtNew.Select("[ADAccount]='" + dr[TB_User.col_ADAccount] + "'"); // if (drFilter.Length > 0) // { // drFilter[0]["DormName"] = drFilter[0]["DormName"] + "," + dr["DormName"]; // } // else // { // drNew.ItemArray = dr.ItemArray; // dtNew.Rows.Add(drNew); // } //} //if (dtNew.Rows.Count>0) //{ // pager.TotalRecord = dtNew.Rows.Count; //} //else //{ // pager.TotalRecord = 0; //} return(dt); }
protected void btnLogin_Click(object sender, EventArgs e) { using (var en = new WeekReportEntities()) { //var dd = en.Table_2.ToList(); TB_User user = (from q in en.TB_User where q.Acc == txtAcc.Text && q.pass == txtCode.Text select q).FirstOrDefault(); if (user != null) { Session[GlobalInfo.Session_User] = user; if (user.lv == 3) { Response.Redirect("~/L2/FrmL2Bridge.aspx"); } if (user.lv == 2) { Response.Redirect("~/L1/L1Bridge.aspx"); } if (user.lv == 1) { Response.Redirect("~/UserInput/FrmUserInputBrige.aspx"); } } else { Response.Write("沒有此帳號或是密碼錯誤"); } } }
public ActionResult Login(FormCollection f) { string staikhoan = f["user_name"].ToString(); string smatkhau = f["user_password"].ToString(); TB_User user = login.TB_User.SingleOrDefault(n => n.UserName == staikhoan && n.Password == smatkhau); if (user != null) { Session["NguoiDung"] = user; return(Redirect(Request.UrlReferrer.ToString())); } else if (staikhoan == "") { ViewBag.TBTK = "Nhập tài khoản"; } else if (smatkhau == "") { ViewBag.TBMK = "Nhập mật khảu"; } else { ViewBag.ThongBao = " <div class=alert - danger>Bạn nhập sai. Vui lòng nhập lại</div>"; } return(View()); }
/// <summary> /// 新增用户 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnNew_Click(object sender, RoutedEventArgs e) { try { mStatus = "add"; if (!string.IsNullOrEmpty(txtName.Text) && !string.IsNullOrEmpty(txtCode.Text)) { if (!getUserInfo(txtCode.Text)) { return; } TB_User user = new TB_User(); user.USER_NAME = this.txtName.Text.Trim(); user.USER_CODE = this.txtCode.Text.Trim(); user.ROLEID = (this.cmbUserRole.SelectedValue as PTS_TABLE_SRC).ID; TB_User tmp = TB_UserDao.FindFirst(new EqExpression("USER_CODE", this.txtCode.Text.Trim())); user.PASSWORD = DES.Encode("111111", Global.DB_PWDKEY); user.DEPT = txtDept.Text; user.Save(); //保存 MessageHelper.ShowMessage("保存成功"); this.txtName.Text = ""; this.txtCode.Text = ""; this.cmbUserRole.SelectedIndex = 0; } mStatus = ""; bindUserData(); } catch (Exception ex) { MessageHelper.ShowMessage(ex.Message); } }
public ActionResult Login(LoginModel model, string returnUrl) { TB_User user = repo.LoginAdmin(model.UserName, model.Password); if (user != null) { FormsAuthentication.SetAuthCookie(model.UserName, false); Session["Admin"] = user; if (user.Active == "Admin") { return(RedirectToAction("Products", "Admin")); } else { return(RedirectToAction("Index", "Home")); } } //if (ModelState.IsValid && WebSecurity.Login(model.UserName, model.Password, persistCookie: model.RememberMe)) //{ // return RedirectToLocal(returnUrl); //} // If we got this far, something failed, redisplay form ModelState.AddModelError("", "The user name or password provided is incorrect."); return(View("Index", model)); }
private void CheckBox_Click(object sender, RoutedEventArgs e) { TB_User user = (TB_User)this.dgUser.SelectedItem; if (user != null) { user.IsChecked = !user.IsChecked; } }
public uc_user(TB_User user) { InitializeComponent(); if (user != null) { mUser = user; this.txtName.Text = mUser.USER_NAME; this.txtName.Tag = mUser; } }
private void writeAccountReport(TB_User sales, int year, int month, int line, decimal totalScore) { AccountSheet.Cells[ACCOUNTDATA_STARTLINE_INDEX + line, 2].PutValue(sales.USER_NAME); AccountSheet.Cells[ACCOUNTDATA_STARTLINE_INDEX + line, 2].Style.Copy(cellstyle); AccountSheet.Cells[ACCOUNTDATA_STARTLINE_INDEX + line, 3].PutValue(GlobalBusiness.getUserRoleType(sales.ROLEID)); AccountSheet.Cells[ACCOUNTDATA_STARTLINE_INDEX + line, 3].Style.Copy(cellstyle); AccountSheet.Cells[ACCOUNTDATA_STARTLINE_INDEX + line, 4].PutValue(Math.Round(totalScore, 2)); AccountSheet.Cells[ACCOUNTDATA_STARTLINE_INDEX + line, 4].Style.Copy(this.cellstyle); }
public static bool checkPwd(int id, string pwd) { TB_User user = TB_UserDao.FindFirst(new EqExpression("Id", id), new EqExpression("Password", DES.Encode(pwd, Global.DB_PWDKEY))); if (user != null) { return(true); } return(false); }
public TB_UserProfile login(string userName, string password) { TB_User user = entities.TB_User.Where(u => u.UserName.Equals(userName) && u.Password.Equals(password)).SingleOrDefault(); if (user != null) { return(user.TB_UserProfile.SingleOrDefault()); } return(null); }
/// <summary> /// 事务添加 /// </summary> /// <param name="info"></param> /// <param name="tran"></param> /// <param name="db"></param> /// <returns></returns> public int Create(TB_User info, DbTransaction tran, Database db) { DbCommand dbCommandWrapper = null; int intId; string strInsertSql = @"INSERT INTO [TB_User] ([SiteID] ,[ADAccount] ,[EmployeeNo] ,[EName] ,[Creator] ,[CName] ,[RoleID]) VALUES(@SiteID ,@ADAccount ,@EmployeeNo ,@EName ,@Creator ,@CName ,@RoleID )"; string strSelectIdSql = ";SELECT SCOPE_IDENTITY()"; try { dbCommandWrapper = db.GetSqlStringCommand(strInsertSql + strSelectIdSql); #region Add parameters db.AddInParameter(dbCommandWrapper, "@SiteID", DbType.Int32, info.SiteID); db.AddInParameter(dbCommandWrapper, "@ADAccount", DbType.String, info.ADAccount); db.AddInParameter(dbCommandWrapper, "@EmployeeNo", DbType.String, info.EmployeeNo); db.AddInParameter(dbCommandWrapper, "@EName", DbType.String, info.EName); db.AddInParameter(dbCommandWrapper, "@Creator", DbType.String, info.Creator); db.AddInParameter(dbCommandWrapper, "@CName", DbType.String, info.CName); db.AddInParameter(dbCommandWrapper, "@RoleID", DbType.Int32, info.RoleID); #endregion if (tran == null) { intId = Convert.ToInt32(db.ExecuteScalar(dbCommandWrapper)); } else { intId = Convert.ToInt32(db.ExecuteScalar(dbCommandWrapper, tran)); } return(intId); } catch (Exception ex) { throw ex; } finally { if (dbCommandWrapper != null) { dbCommandWrapper = null; } } }
private void InitPageData() { string strUserID = Request.QueryString["id"]; TB_DormArea mTB_DormArea = new TB_DormArea(); DormAreaBLL mDormAreaBLL = new DormAreaBLL(); TB_User mTB_User = null; UserBLL mUserBLL = new UserBLL(); RoleBLL mRoleBLL = new RoleBLL(); TB_Role mTB_Role = new TB_Role() { SiteID = (base.UserInfo == null ? base.SystemAdminInfo.SiteID : base.UserInfo.SiteID), }; Pager pager = null; this.ddlRole.DataTextField = TB_Role.col_Name; this.ddlRole.DataValueField = TB_Role.col_ID; this.ddlRole.DataSource = mRoleBLL.GetPagerData(mTB_Role, ref pager); this.ddlRole.DataBind(); this.ddlRole.Items.Insert(0, new ListItem() { Value = "0", Text = "--请选择--" }); mTB_DormArea.SiteID = (base.UserInfo == null ? base.SystemAdminInfo.SiteID : base.UserInfo.SiteID); DataTable dtLeft = mDormAreaBLL.GetTable(mTB_DormArea, ref pager); DataTable dtRight = null; if (null != strUserID && !string.IsNullOrEmpty(strUserID)) { mTB_User = mUserBLL.Get(Convert.ToInt32(strUserID)); this.txtADAccount.Text = mTB_User.ADAccount; this.txtEmployeeNo.Text = mTB_User.EmployeeNo; this.txtCName.Text = mTB_User.CName; this.txtEName.Text = mTB_User.EName; this.ddlRole.SelectedValue = mTB_User.RoleID.ToString(); dtRight = mDormAreaBLL.GetTableByUserID(Convert.ToInt32(strUserID)); DataRow[] drFilter = null; for (int i = dtLeft.Rows.Count - 1; i >= 0; i--) { drFilter = dtRight.Select("ID=" + dtLeft.Rows[i][TB_DormArea.col_ID] + ""); if (drFilter.Length > 0) { dtLeft.Rows.Remove(dtLeft.Rows[i]); } } } ViewState["dtLeft"] = dtLeft; gdvLeft.DataSource = dtLeft; gdvLeft.DataBind(); ViewState["dtRight"] = dtRight; gdvRight.DataSource = dtRight; gdvRight.DataBind(); }
private void timer1_tick(object sender, EventArgs e) { TB_Password.UseSystemPasswordChar = false; TB_User.ForeColor = Color.Black; TB_Password.ForeColor = Color.Black; TB_User.Text = "Usuario"; TB_Password.Text = "Contraseña"; TB_User.Refresh(); TB_Password.Refresh(); timer1.Enabled = false; }
/// <summary> /// 添加项目负责人 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnLeader_Click(object sender, RoutedEventArgs e) { frmUserSearch frm = new frmUserSearch(); frm.ShowDialog(); if (frm.mUser != null) { TB_User user = frm.mUser[0]; this.txtleder.Text = user.USER_NAME; this.txtleder.Tag = user; } }
public ActionResult History() { if (Session["Admin"] == null) { return(RedirectToAction("Index", "Admin")); } TB_User user = (TB_User)Session["Admin"]; List <TB_Transaction> transactions = entities.TB_Transaction.Where(x => x.UserId == user.UserId).ToList(); return(View(transactions)); }
public ActionResult EWallet() { if (Session["user"] == null) { return(RedirectToAction("Login", "Account")); } TB_User user = (TB_User)Session["user"]; EWallet wallet = entities.EWallets.Where(x => x.UserID == user.UserId).FirstOrDefault(); return(View(wallet)); }
/// <summary> /// 添加 /// </summary> /// <param name="info"></param> /// <returns></returns> public int Create(TB_User info) { try { Database db = DBO.CreateDatabase(); return(this.Create(info, (DbTransaction)null, db)); } catch (Exception ex) { throw ex; } }
public IActionResult User_Permission_edit(string sEmployeeID) { TB_User tb_user = new TB_User(); PTTGSP_DWSContext db = new PTTGSP_DWSContext(); TB_User qtb_user = db.TB_User.Where(w => w.sEmployeeID == sEmployeeID).FirstOrDefault(); if (qtb_user != null) { tb_user = qtb_user; } return(Ok(tb_user)); }
public static void updateUserInfo(TB_User user) { try { user.Update(); //MessageHelper.ShowMessage("I001"); } catch (Exception ex) { Log.Error(ex.Message); MessageHelper.ShowMessage("E999"); } }
public async Task <bool> AddAccount(TB_User user) { var dbUser = await _accountDbContext.TB_User.SingleOrDefaultAsync(u => u.StrUserID == user.StrUserID || u.Email == user.Email); if (dbUser == null) { _accountDbContext.Set <TB_User>().Add(user); await _accountDbContext.SaveChangesAsync(); return(true); } return(false); }
/// <summary> /// 抓出某課所有的報表 /// </summary> /// <param name="p_User"></param> /// <returns></returns> public static List <TB_Report> ShowOldReport(TB_User p_User) { using (var en = new WeekReportEntities()) { //end必須從新設定 List <TB_Report> data = (from q in en.TB_Report where q.Bureau == p_User.Bureau && q.Class == p_User.Class select q).ToList(); return(data); } }
public ActionResult PayUsingWallet() { RechargeModel model = (RechargeModel)Session["recharge"]; EWallet wallet = null; if (Session["user"] != null) { TB_User user = (TB_User)Session["user"]; wallet = user.EWallets.FirstOrDefault(); if (Convert.ToDecimal(model.amount) < wallet.Amount) { ServiceReference1.ClientAPIServiceSoapClient s = new ServiceReference1.ClientAPIServiceSoapClient(); string clientId = ConfigurationManager.AppSettings["ClientId"]; string clientPwd = ConfigurationManager.AppSettings["ClientPwd"]; string responseid = ""; string status = ""; string balances = ""; string number = Guid.NewGuid().ToString().Substring(0, 6); TB_Transaction tx = repo.createTransaction(number, model.amount, wallet.UserID ?? 0, Convert.ToInt32(model.ProductId), model.phone); bool result = s.RequestInput(clientId, clientPwd, number, model.Operators, Convert.ToDecimal(model.amount), model.phone, ref responseid, ref status, ref balances); tx.Status = status; tx.ResponseId = responseid; repo.updateTrasnaction(tx); if (status == "SUBMIT_SUCCESS") { TB_Transaction txu = entities.TB_Transaction.Where(x => x.TransactionId == tx.TransactionId).FirstOrDefault(); txu.PaymentStatus = "Payment Recieved."; entities.SaveChanges(); repo.DeductMoneyFromWallet(((TB_User)Session["user"]).UserId, Convert.ToDecimal(model.amount)); TB_Paypal paypal = new TB_Paypal(); paypal.Amount = Convert.ToDecimal(model.amount); paypal.date = DateTime.Now; paypal.EWalletID = wallet.EWalletID; paypal.Type = "Mobile Recharge"; paypal.UserID = user.UserId; paypal.TransactionID = txu.TransactionId; entities.TB_Paypal.Add(paypal); entities.SaveChanges(); ViewBag.Message = "Recharge Succesful !"; } else { ViewBag.Message = "Recharge was UnSuccesful !"; ViewBag.MessageDesc = "Some issue occured in the backend. We haven't deducted money from your wallet. Please try again later"; } } } return(View(model)); }
/// <summary> /// 取出某課當周的主報表 /// </summary> /// <param name="p_User"></param> /// <returns></returns> public static List <TB_Report> GetNowReport(TB_User p_User) { using (var en = new WeekReportEntities()) { List <TB_Report> data = (from q in en.TB_Report where q.Bureau == p_User.Bureau && q.Class == p_User.Class && q.TimeStart <= DateTime.Now && q.TimeEnd >= DateTime.Now select q).ToList(); return(data); } }