public bool UpdatePassword(string logName, string passWord) { var szPassword = CommonLib.HashEncrypt.BgPassWord(HashEncrypt.md5(passWord)); string sql = string.Format("UPDATE Users SET Password='******',OperateDate=getdate() where UserName in ({1})", szPassword, logName); return(DbHelperSql.ExecuteNonQuery(sql) > 0); }
public bool UpdateCustomerHeadImg(Guid sid, Guid welfareCentreIds, string headImg) { if (sid == null || sid == Guid.Empty) { return(false); } string sql = string.Format("update tbCustomer set CustomerHeadImg='{0}',OperateDate=getdate() where id in('{1}')", headImg, sid); var isFlag = DbHelperSql.ExecuteNonQuery(sql) > 0; return(isFlag); }
public bool ChangePassword(Guid welfareCentreId, Guid id, string iNewPassword) { string sql = string.Format("UPDATE Users SET Password='******',OperateDate=getdate() where UserID ='{1}'", iNewPassword, id); var isFlag = DbHelperSql.ExecuteNonQuery(sql) > 0; if (isFlag == true) { var isFw = false; if (isFw == false) { var userService = new DbHelperEfSql <Users>(); var userItem = userService.SearchBySingle(c => c.UserID == id); } } return(isFlag); }
private bool OperateDataStatus(string[] ids, ESystemStatus eSystemStatus) { if (ids.Length <= 0) { return(false); } var buf = new System.Text.StringBuilder(); foreach (var s in ids) { buf.AppendFormat("'{0}',", s); } string szIds = buf.ToString().TrimEnd(','); string sql = string.Format("UPDATE tbOrganization SET IsValid={0},OperateDate=getdate() WHERE ID in ({1})", (int)eSystemStatus, szIds); return(DbHelperSql.ExecuteNonQuery(sql) > 0); }
public bool DeletePaymentPlan(string[] ids, int isValid) { if (ids == null || ids.Length <= 0) { return(false); } var buf = new System.Text.StringBuilder(); foreach (var s in ids) { buf.AppendFormat("'{0}',", s); } string szIds = buf.ToString().TrimEnd(','); string sql = string.Format("UPDATE tbPaymentPlan SET IsValid={0},OperateDate=getdate() WHERE ID in ({1})", isValid, szIds); return(DbHelperSql.ExecuteNonQuery(sql) > 0); }
public bool ResetPassword(string[] ids) { if (ids == null || ids.Length <= 0) { return(false); } var szPassword = CommonLib.HashEncrypt.BgPassWord(HashEncrypt.md5(Config.SystemInitPassword)); var buf = new System.Text.StringBuilder(); foreach (var s in ids) { buf.AppendFormat("'{0}',", s); } string szIds = buf.ToString().TrimEnd(','); string sql = string.Format("UPDATE Users SET Password='******',OperateDate=getdate() where UserID in ({1})", szPassword, szIds); return(DbHelperSql.ExecuteNonQuery(sql) > 0); }
public bool OperateDataStatus(string[] ids, ESystemStatus eSystemStatus, Guid welfareCentreId) { if (ids == null || ids.Length <= 0) { return(false); } var buf = new System.Text.StringBuilder(); foreach (var item in ids) { buf.AppendFormat("'{0}',", item); } var szIds = buf.ToString().TrimEnd(','); string sql = string.Format("update tbCustomer set IsValid={0},OperateDate=getdate() where id in({1})", (int)eSystemStatus, szIds); var isFlag = DbHelperSql.ExecuteNonQuery(sql) > 0; return(isFlag); }
public bool OperateNursType(Guid id, int nursType) { string sql = string.Format("update tbCustomer set CustomerHLMC_dic={0},OperateDate=getdate() where id in('{1}')", nursType, id); return(DbHelperSql.ExecuteNonQuery(sql) > 0); }
public bool ChangePassword(Guid id, string iNewPassword) { string sql = string.Format("UPDATE Users SET Password='******',OperateDate=getdate() where UserID ='{1}'", iNewPassword, id); return(DbHelperSql.ExecuteNonQuery(sql) > 0); }