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);
}
