/// <summary> /// Edit name /// </summary> /// <param name="obj"></param> public void Edit(Roles obj) { string queryStr = "UPDATE role SET"; queryStr += string.Format(" " + RoleColumn.RoleName + " = '{0}'", obj.RoleName); queryStr += string.Format(" WHERE " + RoleColumn.RoleId + " = '{0}'", obj.RoleId); PosService.DataExecute(Username, Password, queryStr, ref errorString); }
public void Edit(Users obj) { string queryStr = "UPDATE user SET"; queryStr += string.Format(" Pwd = '{0}'", obj.Pwd); queryStr += string.Format(" ,LastLogin = '******'", obj.LastLogin); queryStr += string.Format(" ,Status = '{0}'", obj.Status); queryStr += string.Format(" ,ModifiedBy = '{0}'", obj.ModifiedBy); queryStr += " ,ModifiedBy = NOW()"; queryStr += string.Format(" ,ModifiedBy = '{0}'", obj.ModifiedBy); queryStr += string.Format(", '{0})'", obj.RoleId); queryStr += string.Format(" WHERE UserId = '{0}'", obj.UserId); PosService.DataExecute(Username, Password, queryStr, ref errorString); }
public void Delete(string id, string stt) { string queryStr = string.Format("UPDATE user SET Status = '{0}' WHERE UserId = '{1}'", stt, id); PosService.DataExecute(Username, Password, queryStr, ref errorString); }